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

From Mark Roberts
Subject Re: Cause of error message?
Date
Msg-id 1216084240.26739.197.camel@localhost
Whole thread Raw
In response to Cause of error message?  ("Bayless Kirtley" <bkirt@cox.net>)
List pgsql-general
On Mon, 2008-07-14 at 19:44 -0500, 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
>

I believe that this might be caused by a syntax error.  Do you have any
error handling code that might be hiding the error from you?

-Mark


pgsql-general by date:

Previous
From: "Bayless Kirtley"
Date:
Subject: Cause of error message?
Next
From: Klint Gore
Date:
Subject: Re: Cause of error message?