Re: Cause of error message? - Mailing list pgsql-general

From Mai Fawzy
Subject Re: Cause of error message?
Date
Msg-id 26811098.post@talk.nabble.com
Whole thread Raw
In response to Cause of error message?  ("Bayless Kirtley" <bkirt@cox.net>)
List 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.


pgsql-general by date:

Previous
From: AlexeyChe
Date:
Subject: Re: C functions, dll, server fall down
Next
From: mrciken
Date:
Subject: Training and open source