Re: COMMIT after an ERROR?

On Fri, 12 Oct 2001 11:05:21 -0700 (PDT)
Stephan Szabo <sszabo@megazone23.bigpanda.com> wrote:
> On Fri, 12 Oct 2001, 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?

> The transaction will be forced to roll back.

Thanks.  Is this a PostgresQL specific behaviour, or is it defined
under ANSI?  I've been reading thru the SQL books I have here, and
its pretty ambiguous.

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