Transaction end on error

On Wednesday 04 February 2004 09:54, Christian Traber wrote:

Hi,

Postgres gives an error (ERROR: current transaction is aborted,
commands ignored until end of transaction block)
on the next sql statement after an error during a transaction and the
transaction is rolled back
In Oracle you can go on with the transaction after an error and commit
or rollback...
Is there a way to change this behaviour? Somthing like a autorollback
off;-)

I'm afraid not. Nested transactions will let you do this, and they are being
looked into - they might be in the next release, might not.

--
Richard Huxton
Archonet Ltd