Re: [GENERAL] COMMIT after an ERROR?

[Charles Tassell]

The failed query will abort the transaction, and throw out every command that comes before or after it until your rollback.  You don't have to specifically issue a rollback unless you want to issue more commands though.  When you disconnect from the DB it will automatically roll back the transaction.


At 05:18 AM 10/12/01, J C Lawrence wrote:

Does an error during a transaction invalidate the transaction?

eg

  BEGIN
  SomeQueryThatSucceeds
  SomeQueryThatFails
  SomeOtherQueryThatSucceeds
  COMMIT

Will the transaction successfully COMMIT, or will the COMMIT fail?

Translation: Do I need to monitor for error conditions during a
transaction and manually do the ROLLBACK in those cases?

--
J C Lawrence
---------(*)                Satan, oscillate my metallic sonatas.
[EMAIL PROTECTED]               He lived as a devil, eh?
http://www.kanga.nu/~claw/ Evil is a name of a foeman, as I live.

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster