Re: Cause of error message?

From: Mai Fawzy <maifawzy(dot)emaifaw(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Cause of error message?
Date: 2009-12-16 13:34:50
Message-ID: 26811098.post@talk.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


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

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--tp18456162p26811098.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Mai Fawzy 2009-12-16 13:36:19 Re: Cause of error message?
Previous Message Michael Clark 2009-12-16 13:19:37 Re: Possible causes for database corruption and solutions