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. claw@kanga.nu 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