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(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

--
patrick keshishian
Pioneer Digital Technologies

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