Transaction end on error

From: Christian Traber <christian(at)traber-net(dot)de>
To: Pgsql-General <pgsql-general(at)postgresql(dot)org>
Subject: Transaction end on error
Date: 2004-02-04 09:54:35
Message-ID: 4020C15B.4090909@traber-net.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Rod K 2004-02-04 11:58:03 Re: BLOB problem
Previous Message Richard Huxton 2004-02-04 09:53:13 Re: RETURN NEXT and reversing order