| From: | Michael Fuhr <mike(at)fuhr(dot)org> |
|---|---|
| To: | Jonathan Villa <jonathan(at)innovativesource(dot)net> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Don't understand transaction error |
| Date: | 2005-09-01 16:13:44 |
| Message-ID: | 20050901161344.GA28602@winnie.fuhr.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Casey T. Deccio | 2005-09-01 16:26:02 | Re: Transaction error |
| Previous Message | Dick Kniep | 2005-09-01 16:13:13 | Schema problems RedHat / SuSE 9.3 for version 7.4.8 |