I have a very similar case, I am using erlang with postgres. I began a transaction then make an insertion and then I got the error "ERROR: current transaction is aborted, commands ignored until end of transaction block" when i try any other query. When i added the rollback line, It gave me another error which is "RollBack Failed". Does anyone know why a rollback fails in the transaction? Thanks Alot, Mai Fawzy Bayless Kirtley wrote: > > An old app is giving a new error message. I query a table and make one > update. Later I come back to query the table again and get this error: > > ERROR: current transaction is aborted, commands ignored until end of > transaction block > > The error only occurs after I have made an update. As long as no updates, > I can query multiple times. Can anyone give me an idea of what sort of > actions or errors usually cause this error? > > Thanks, > Bayless > > -- View this message in context: http://old.nabble.com/Cause-of-error-message--tp18456162p26811115.html Sent from the PostgreSQL - general mailing list archive at Nabble.com. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general