Re: current transaction is aborted, commands ignored until

On Tue, 19 Apr 2005, Thomas Kellerer wrote:

> Joshua D. Drake wrote on 19.04.2005 00:21:
> >> 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?
> >
> > Only if you are using savepoints (nested transactions) otherwise you
> > must rollback.
> >
> >> Is this a problem with the JDBC interface that I'm using, or is this a
> >> general Postgres problem?
> >
> > I do not know if the JDBC interface supports savepoints.
>
> The problem is, that I need to support several different DBMS and only
> for handling Postgres stuff I don't really want to introduce this.
>

This is an open todo item for the JDBC driver. It could be done by
automatically wrapping all statements in savepoints behind the scenes.
Then any error would rollback to the savepoint and you could continue on
with your transaction. This option would only be used for
compatibility which makes it a low priority for people who are mostly
PostgreSQL users. Also, it'll certainly decrease performance.

Kris Jurka