current transaction is aborted, commands ignored until end of transaction...

From: Thomas Kellerer <spam_eater(at)gmx(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: current transaction is aborted, commands ignored until end of transaction...
Date: 2005-04-18 22:09:27
Message-ID: d41av3$9ua$1@sea.gmane.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

I'm having a bit of trouble with the error message from the subject. Is
there a way to simply go on with my commands if I hit this error?

One example would be when I drop a table (and it doesn't exist) I still
want to run the following CREATE TABLE. But due to the error even the
following valid command will fail.
This problem is not limited to DDL. When I try to write the result sets for
several queries to disk it's the same problem, if e.g. the first select
reports an error (e.g. due to a typo in the column list) all subsequent
ones will no run as well.

I know that I can "fix" this state by issuing a rollback (or commit). The
problem is, that this stuff is part of a bigger program, and I cannot
determine whether I'm allowed to do a rollback or commit at that point.

Is this a problem with the JDBC interface that I'm using, or is this a
general Postgres problem?

Is there a setting where I can control this behaviour?

I'm using 8.0.2 on Windows 2000 (and XP)

Thanks for your help
Thomas

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Joshua D. Drake 2005-04-18 22:21:14 Re: current transaction is aborted, commands ignored until
Previous Message Bruce Momjian 2005-04-18 22:07:13 Re: PostgreSQL and Schema (pictures)