Re: taking actions on rollback (PHP)

On Sun, Apr 27, 2008 at 02:05:16PM +0200, Ivan Sergio Borgonovo wrote:
> "Eh?" was my same reaction. I'm going to check the logs... and be
> sure I wasn't dreaming.
> Do you confirm that if I wasn't dreaming and another page that should
> have opened another connection with pg_connect did cause another
>
> ERROR:  current transaction is aborted, commands ignored until end of
> transaction block
>
> there is something wrong with the Universe or at least with what's
> happening with php/postgresql?

Yes, if you're getting that message on a connection without having an
error on that connection then something is really wrong. Note, I've
never used PG with PHP so I can't help you with anything specific.

> This is interesting:
> http://archives.postgresql.org/pgsql-general/2007-08/msg00660.php

Yes, that's a pretty good summary of the problems with pconnect.

> If for any reason my code fail... I've to cleanup the simpler object
> created by the framework "by hand".

Ok...
Have a nice day,
--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> Please line up in a tree and maintain the heap invariant while
> boarding. Thank you for flying nlogn airlines.