On 02/11/2009 13:55, Chris Barnes wrote: > We are seeing the error ( 2009-11-02 08:31:30 > EST:recognit@xxxxxxxxxxxxx(48990):4562ERROR: current transaction is > aborted, commands ignored until end of transaction block ) > consistantly in the database and I'm not sure if there was something > left out of the code ( search indicates autocomit), or pgbouncer > or putting the hot standby online, but with so many changes it's a > guessing game. Hi there, This error is what you see if you (i) begin a transaction, (ii) execute a query that causes an error, and (iii) try to execute further queries in the same transaction. You'll continue to get this query until you issue a ROLLBACK. - So my guess is that there's a problem in your application. Ray. -- Raymond O'Donnell :: Galway :: Ireland rod@xxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
