Transaction end on error - Mailing list pgsql-general

From Christian Traber
Subject Transaction end on error
Date
Msg-id 4020C15B.4090909@traber-net.de
Whole thread Raw
Responses Re: Transaction end on error  (Richard Huxton <dev@archonet.com>)
List pgsql-general
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;-)

Regards,
Christian

pgsql-general by date:

Previous
From: Richard Huxton
Date:
Subject: Re: RETURN NEXT and reversing order
Next
From: "Rod K"
Date:
Subject: Re: BLOB problem