Re: taking actions on rollback (PHP) - Mailing list pgsql-general

From Martijn van Oosterhout
Subject Re: taking actions on rollback (PHP)
Date
Msg-id 20080427143243.GB6816@svana.org
Whole thread Raw
In response to Re: taking actions on rollback (PHP)  (Ivan Sergio Borgonovo <mail@webthatworks.it>)
Responses Re: taking actions on rollback (PHP)  (Hannes Dorbath <light@theendofthetunnel.de>)
List pgsql-general
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.

Attachment

pgsql-general by date:

Previous
From: "Douglas McNaught"
Date:
Subject: Re: plpgsql functions and the planner
Next
From: Gregory Stark
Date:
Subject: Re: plpgsql functions and the planner