Search Postgresql Archives

Re: Cause of error message?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux