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.