Re: COMMIT after an ERROR?

The only things that are not rolled back are advancing of
sequences and such.  I suspect serial types also exhibit similar
behavior to sequences.


On Fri, Oct 12, 2001 at 04:10:49PM -0300, Charles Tassell wrote:
> 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

--
patrick keshishian
Pioneer Digital Technologies

Gnu  __   _
 -o)/ /  (_)__  __ ____  __
 /\\ /__/ / _ \/ // /\ \/ /
_\_v __/_/_//_/\_,_/ /_/\_\