Re: COMMIT after an ERROR?

Поиск
Список
Период
Сортировка
От J C Lawrence
Тема Re: COMMIT after an ERROR?
Дата
Msg-id 2985.1003389022@kanga.nu
обсуждение исходный текст
Ответ на Re: COMMIT after an ERROR?  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
Список 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 по дате отправления:

Предыдущее
От: "Dr. Evil"
Дата:
Сообщение: Re: TEXT field's length limit in PostgreSQL
Следующее
От: Jochem van Dieten
Дата:
Сообщение: Re: To Postgres Devs : Wouldn't changing the select limit