Re: COMMIT after an ERROR? - Mailing list pgsql-general

From J C Lawrence
Subject Re: COMMIT after an ERROR?
Date
Msg-id 2985.1003389022@kanga.nu
Whole thread Raw
In response to Re: COMMIT after an ERROR?  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
List pgsql-general
On Sat, 13 Oct 2001 07:13:25 -0700 (PDT)
Stephan Szabo <sszabo@megazone23.bigpanda.com> wrote:

> Well, that's difficult.  The spec is very hard to understand about
> that.  I believe we determined that our behavior was very very
> close to complient, but that it does not match the standard
> reading of that section.

My reading of the spec came out as:

  The spec in regard to exact behaviour at COMMIT in the presence of
  errors is, in spec language, "undefined".

  The current PostgresQL behaviour doesn't violate the spec, but is
  also one of many possible mutually contradictory behaviours (such
  as not rolling back on error) that don't appear to violate the
  spec.

Ahh well, its not like inserting explicit ROLLBACKs is that hard.

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

pgsql-general by date:

Previous
From: "Dr. Evil"
Date:
Subject: Re: TEXT field's length limit in PostgreSQL
Next
From: Jochem van Dieten
Date:
Subject: Re: To Postgres Devs : Wouldn't changing the select limit