Re: COMMIT after an ERROR?

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(at)kanga(dot)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