childcount: 0 resource(1) of type (pgsql link persistent) PostgreSQL 8.1.2 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.3.5 (Debian 1:3.3.5-13)
childcount: 1 resource(1) of type (pgsql link persistent) error: server closed the connection unexpectedly This probably means the server terminated abnormally before or while processing the request.
childcount: 2 resource(1) of type (pgsql link persistent) error: server closed the connection unexpectedly This probably means the server terminated abnormally before or while processing the request.
The 'resource(1) of type (pgsql link persistent)' shows the connection is still valid as far as php is concerned.
In the postgresql logs I get:
LOG: connection received: host=[local] LOG: connection authorized: user=xxxxxx database=xxxxxx LOG: statement: select version() AS version LOG: duration: 3.516 ms LOG: duration: 3.516 ms statement: select version() AS version LOG: disconnection: session time: 0:00:00.02 user=xxxxxx database=xxxxxx host=[local]
Turning up debugging / logs in postgresql didn't show anything extra.
So I think either: a) I'm doing something wrong b) It's a bug in php c) It's a bug in the postgresql php "driver"
I don't think it's a or b because I change it all to mysql and it works, it doesn't drop the connection like it is here.
I'm not sure where to start looking from here... so any ideas/comments please send them through!