By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
464,760 Members | 1,091 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 464,760 IT Pros & Developers. It's quick & easy.

Transaction end on error

P: n/a
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

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

Nov 22 '05 #1
Share this Question
Share on Google+
1 Reply

P: n/a
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

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to ma*******@postgresql.org)

Nov 22 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.