| 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: | Whole Thread | Raw Message | 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
| 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) |