Rob Butler | 2 May 02:47 2002
Picon
Picon

make errors building libpqdll.lib

Hello all,

I'm running into some sort of error building libpq on my machine.  I change
to /src and run nmake -f win32.mak as directed, but get output showing
warning messages.  OK fine, warnings are not errors..  BUT the libpqdll.lib
does not have an entry for PQescapeString..  Which causes the following
error in my project:

error LNK2001: unresolved external symbol _PQescapeString
fatal error LNK1120: 1 unresolved externals

If I comment out PQescapeString, the project compiles fine.  Other postgres
functions seem to be available and work when called.  Is this a bug in the
win32 build of libpq?  Or is something going wrong on my machine.

Either way, all I need is the libpqdll.lib, libpq-fe.h, and libpq.dll
files..  If someone else has them for postgres 7.2 already and could send
them to me, it would save some time.  Help solving the issue so I can build
my own libpq.dll would also be greatly appreciated.

I'm using VC++ Enterprise Edition, with the August 2001 Edition Microsoft
SDK update.

Thanks for the help
Rob

Here is a copy of the build output:

 cd include
 if not exist pg_config.h copy pg_config.h.win32 pg_config.h
(Continue reading)

Picon

Re: accessing a db

Andy, 

Thanks a lot for your help. Everything is working great.

Joao

-----Original Message-----
From: Andy Samuel [mailto:andysamuel <at> myrealbox.com]
Sent: terça-feira, 30 de Abril de 2002 3:33
To: pgsql-cygwin <at> postgresql.org
Subject: Re: [CYGWIN] accessing a db

May be you did not shutdown the database when the last time you start it.

Try this :
1.  type 'ps -a' .  Can you see any 'postgres'  in the 'command' column ?
If not proceed to no. 2
2.  type 'rm /usr/share/postgresql/data/postmaster.pid'

Each time PostgreSQL runs, it creates the
/usr/share/postgresql/data/postmaster.pid.
If you shutdown the database cleanly, the file will be deleted.
Upon starting the postmaster, PostgreSQL check this file, if the file exist,
then it is a sign that a postmaster already running.

Everytime you're done working with Cygwin + PostgreSQL, use this command to
cleanly shutdown the postmaster :
'pg_ctl stop -D /usr/share/postgresq/data'

Hey...I hope this is not a production server.
(Continue reading)

Rob Butler | 3 May 01:22 2002
Picon
Picon

Fw: make errors building libpqdll.lib

I tried building the postgres libs on another machine that doesn't have the
Microsoft SDK update.  Still having problems.  If I use the DLL it still
cant find PQescapeString during linking.  If I use the static library, it
compiles and links without error, but then has all sorts of problems and
crashes.

So any ideas?  Or could someone send me a working set of dll / lib files.
Someone has to have them with all the cygwin postgres users out there.

Everything else so far seems to work as long as I don't use PQescapeString.
(I just comment it out, and it compiles / links fine!)

I can connect, get a result set, and disconnect without error.  (haven't
written the code to process the result set yet, but I will soon).

Thanks again for the help
Rob.

> Hello all,
>
> I'm running into some sort of error building libpq on my machine.  I
change
> to /src and run nmake -f win32.mak as directed, but get output showing
> warning messages.  OK fine, warnings are not errors..  BUT the
libpqdll.lib
> does not have an entry for PQescapeString..  Which causes the following
> error in my project:
>
> error LNK2001: unresolved external symbol _PQescapeString
> fatal error LNK1120: 1 unresolved externals
(Continue reading)

Jakob Lund | 4 May 22:49 2002
Picon

Re: postgresql client under win 2k

I have made an easy to use MFC dll which uses ligpq to access data in a recordset manor. To get this dll swing,
swing by http://www.jsg.dk/postgresql
 
regards Jakob Simon-Gaarde
Mr. Wobbet | 5 May 20:13 2002

cygwin server w/ data on *nix machine?

can i run a cygwin based psql server that has its database files
physically located on a *nix box? do i need to be running SAMBA on
the *nix box so that the windows machine can see it? what do i need
to worry about as far as user permissions go?

many thanks!

rjsjr

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html

robert sanford | 5 May 20:13 2002

cygwin server w/ data on *nix machine?

can i run a cygwin based psql server that has its database files
physically located on a *nix box? do i need to be running SAMBA on
the *nix box so that the windows machine can see it? what do i need
to worry about as far as user permissions go?

many thanks!

rjsjr

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html

Tomek | 5 May 21:45 2002
Picon

PHP & PostrgreSQL

I've got Apache+PHP4 running under Win98 and PostgreSQL under Cygwin/Win98
(with postmaster listening on TCP/IP).
Every think is OK when I connect to PostgreSQL from my php script
(using pg_connect() function) except for disconnecting from it. At the end
of any
script that establishes connection with PostgreSQL I use pg_close() function
and see on postmaster output that a "user" has exited but PostgreSQL is
still listening on that port like as it was waiting for a next request. So,
after running few php pages I've got too many open connections and finally
postmaster is reporting an error. Could you tell me why after invoking
pg_close() php.exe doesn't really close it, or why PostgreSQL is still
listening on a port that is no longer used?

Thanks in advance and sorry for my English
Tomek

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo <at> postgresql.org so that your
message can get through to the mailing list cleanly

Liviu Taloi | 6 May 11:45 2002
Picon

The service did not respond to the start..

Hi,
I am newbie in this area, I have read more e-mails in
this list in order to put my postgresql under cygwin
as services (ipc-daemon and postmaster) and I cannot
start any of these services (on win XP).
I have followed the instructions on EJIP help file.
It didn't worked for me.
The message from the AdministrativeTools->Services
when I try to start the CygWin IPC Daemon is:
Error 1053: The service did not respond to the start
or control request in a timely fashion.
Somebody can help me?
Liviu.

__________________________________________________
Do You Yahoo!?
Yahoo! Health - your guide to health and wellness
http://health.yahoo.com

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Liviu Taloi | 6 May 11:45 2002
Picon

The service did not respond to the start..

Hi,
I am newbie in this area, I have read more e-mails in
this list in order to put my postgresql under cygwin
as services (ipc-daemon and postmaster) and I cannot
start any of these services (on win XP).
I have followed the instructions on EJIP help file.
It didn't worked for me.
The message from the AdministrativeTools->Services
when I try to start the CygWin IPC Daemon is:
Error 1053: The service did not respond to the start
or control request in a timely fashion.
Somebody can help me?
Liviu.

__________________________________________________
Do You Yahoo!?
Yahoo! Health - your guide to health and wellness
http://health.yahoo.com

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo <at> postgresql.org so that your
message can get through to the mailing list cleanly

Andrzej Zeja | 6 May 15:39 2002
Picon

Using B-Tree index for such kind of queries (with '>','<')

Hi
 
I've got table Test and index for this table B-Tree type.
and
I've made query like:
    Select * from test where Id<100;
During execution Optimizer makes no use of the index.
In documentation stands that using B-Tree index is used for such kind of queries (with '>','<').
Everything works fine only for '=' comparision.
 
Why it doesn't work in my case?
Why Sequenced Scan is executed instead of indexed scan?
 
Below is output of my query:
template1=# explain select * from test where id > 100;
NOTICE:  QUERY PLAN:
Seq Scan on test  (cost=0.00..1.06 rows=3 width=18)
NOTICE:  QUERY PLAN:
Seq Scan on test  (cost=0.00..1.06 rows=3 width=18)
 
Andrzej

Gmane