Re: Cause of error message?

From: Mark Roberts <mailing_lists(at)pandapocket(dot)com>
To: Bayless Kirtley <bkirt(at)cox(dot)net>
Cc: "List, Postgres" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Cause of error message?
Date: 2008-07-15 01:10:40
Message-ID: 1216084240.26739.197.camel@localhost
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Klint Gore 2008-07-15 01:11:02 Re: Cause of error message?
Previous Message Bayless Kirtley 2008-07-15 00:44:05 Cause of error message?