PostgreSQL and invalid link resource errors

Anon

I am getting mad with this. I have some code that do various pg_connect() and other pg_xxx() calls. Every 2nd pg_connect() gets an invalid link resource. Always. My code worked perfectly on php 4.0.0. On 4.0.1pl2, the "is not a valid PostgreSQL link resource" error message appears on every 2nd consecutive use of a link resource generated by pg_connect(). I was getting mad then, but php 4.0.2 goes out and this behaviour simply disappear when I install it. Then, I installed the 4.0.3pl1 version and... voila! There is all the "is not a valid PostgreSQL link resource" messages again, with the same code that runs smoothly in php 4.0.2.
On bugs.php.net I found at least 7 reports on this. Two of them are now closed, due to lack of user feedback. One of them are open since July (on 4.0.1pl1).
Please, did someone know something more about this? Some workaround to use the 4.0.3pl1 php version?
Thanks

Anon

I have been building an application and it has been running fine for weeks now, until today, when I started to experience the errors you described.

My application makes multiple database calls from included files, classes, functions, any place you like. I can't for the life of me work out the set of circumstances which makes this error occur, but I think the error was occuring on trying to open a 2nd database connection.

Anyway I stumbled across a solution: change your 'pg_connect' calls to 'pg_pconnect' calls.

If anyone can shed more light on why this was happening that would be appreciated, I don't like putting fixes in without knowing why I'm doing it.

First I figured the pg_pconnect fixed it because it would be using the first connection again, instead of trying to create a second. Then I realised I only put the pconnect call into the 2nd connection. Wierd.

falbu

Hello,

I had the same problem. It seemed that after you initiate a database connection with pg_connect you have to close it (at the end of your function) with pg_close.

I did that and now everything is fine.

Best,
Florentin

Anon

Hi,

I was getting mad at these errors too.
George\'s solution works for me (thanks George), but I thought of something else:

If you are just trying to execute 2 (or more) queries within the same PHP file, is it really necessary to have more than one pg_connect()?
If the original pg_connect() hasn\'t been closed, you can run another pg_exec() with a different SQL query and everything seems to work fine (for me, at least!).

Just a thought...

Alfonzo Smith

Anon

I received an email from bugs.php.net stating that this issue was fixed on 4.0.5, but I havent tried 4.0.5 yet...
Norman Schmidt

blue-morph

Hi,

I'm using 4.0.3, is there a patch to take care of this problem.
I'm able to run multiple queries through a function, if i open and close db connections.But if i try to get numrows as well, the next query doesn't execute and gives the "not a valid postgresql link resource" error.
Pls help.

Regds,
Sanju

byager

I found this thread because I was experiencing what I think is the same problem on PHP 4.05. I kludged it by adding an unused connection to occupy resource ID #2. Everything works if the 'second' connection is using resource ID #3.

blue-morph

Hi,

Tks for your help. That's a smart work around, changing the connection's(resource) id. I saved myself further head-ache by installing the latest version.

Regds,
Sanjukta

matto

my workaround:

http://www.phpbuilder.com/board/showthread.php?s=&threadid=10218880

yours
matto