Re: COMMIT after an ERROR?

From: J C Lawrence <claw(at)kanga(dot)nu>
To: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: COMMIT after an ERROR?
Date: 2001-10-13 07:04:01
Message-ID: 18809.1002956641@kanga.nu
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message J C Lawrence 2001-10-13 07:07:29 Re: COMMIT after an ERROR?
Previous Message Mona 2001-10-13 06:32:01