Re: Cause of error message?

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.