Re: Don't understand transaction error - Mailing list pgsql-general

From Michael Fuhr
Subject Re: Don't understand transaction error
Date
Msg-id 20050901161344.GA28602@winnie.fuhr.org
Whole thread Raw
In response to Don't understand transaction error  ("Jonathan Villa" <jonathan@innovativesource.net>)
List pgsql-general
On Thu, Sep 01, 2005 at 10:36:07AM -0500, Jonathan Villa wrote:
> I'm getting the following error when attempting to use my application:
>
> ERROR: current transaction is aborted, commands ignored until end of
> transaction block

Some earlier command failed so the entire transaction (or subtransaction)
has failed and no further commands will be allowed; you'll have to
issue a ROLLBACK and then start a new transaction (or issue ROLLBACK
TO SAVEPOINT if you're using savepoints, which are available in 8.0
and later).  If you're doing adequate error checking then you should
be able to find out which command failed and why.

--
Michael Fuhr

pgsql-general by date:

Previous
From: Michael Fuhr
Date:
Subject: Re: Order By for aggregate functions (Simulating Group_concat)
Next
From: marcelo Cortez
Date:
Subject: lock problem