Skip site navigation (1) Skip section navigation (2)

Re: taking actions on rollback (PHP)

From: Martijn van Oosterhout <kleptog(at)svana(dot)org>
To: Ivan Sergio Borgonovo <mail(at)webthatworks(dot)it>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: taking actions on rollback (PHP)
Date: 2008-04-27 14:32:44
Message-ID: 20080427143243.GB6816@svana.org (view raw or flat)
Thread:
Lists: 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(at)svana(dot)org>   http://svana.org/kleptog/
> Please line up in a tree and maintain the heap invariant while 
> boarding. Thank you for flying nlogn airlines.

In response to

Responses

pgsql-general by date

Next:From: Hannes DorbathDate: 2008-04-27 17:10:49
Subject: Re: taking actions on rollback (PHP)
Previous:From: Gregory StarkDate: 2008-04-27 14:30:40
Subject: Re: plpgsql functions and the planner

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group