Re: current transaction is aborted, commands ignored until

On 19.04.2005 02:33 Kris Jurka wrote:
>>>>Is this a problem with the JDBC interface that I'm using, or is this a
>>>>general Postgres problem?
>>>
>
> 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.
>

No problem. I can work around most of the areas where this can occur and I have
control over the transaction handling. So it's not a big issue. It would have
been nice though :)

Thanks
Thomas