Re: COMMIT after an ERROR?

From: J C Lawrence <claw(at)kanga(dot)nu>
To: patrick keshishian <patrick(at)pioneerdigital(dot)com>
Cc: Charles Tassell <ctassell(at)isn(dot)net>, pgsql-general(at)postgresql(dot)org
Subject: Re: COMMIT after an ERROR?
Date: 2001-10-13 07:07:29
Message-ID: 18880.1002956849@kanga.nu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, 12 Oct 2001 19:35:30 -0700
patrick keshishian <patrick(at)pioneerdigital(dot)com> wrote:

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

Ahh, that's actually critical information (which makes sense too
BTW). <thinks> Excellent. Then as long as the auto-ROLLBACK on
error is a guaranteed ANSI behaviour rather than a PGSQL thing,
everything is just perfect. Thanks.

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Allan Engelhardt 2001-10-13 12:47:13 [Off-topic, Meta-question] Problems with psql-general list
Previous Message J C Lawrence 2001-10-13 07:04:01 Re: COMMIT after an ERROR?