Re: Re: Failed Statements within Transactions - Mailing list pgsql-general

From Jan Wieck
Subject Re: Re: Failed Statements within Transactions
Date
Msg-id 200101030021.TAA12493@jupiter.jw.home
Whole thread Raw
In response to Re: Failed Statements within Transactions  (Tim Kientzle <kientzle@acm.org>)
List pgsql-general
Tim Kientzle wrote:
> [...]
>
> Basically, the PostgreSQL developers have decided
> that any integrity violation is a serious error;
> therefore, PostgreSQL does not really permit
> tentative INSERTs within transactions.  This violates
> SQL conventions that are pretty well-established
> in some circles, needlessly complicates
> applications that use complex transactions
> and introduces a fairly minor performance issue.

    We haven't, it's just that our code inherited this feature by
    the way, ROLLBACK is implemented - and if you'd know  only  a
    little  about  the  storage  management  in PostgreSQL, you'd
    never  tell  it  the  way  you   did.    With   the   current
    implementation  of  tuple  visibility  there  is only all-or-
    nothing. Savepoints will get us out of there, but not  before
    7.2 or 7.3.


Jan

--

#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#================================================== JanWieck@Yahoo.com #



pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: cyrillic and sort order (ORDER BY)
Next
From: Artur Pietruk
Date:
Subject: Re: ECPG could not connect to the database.