Re: transaction error handling - Mailing list pgsql-admin

From Bèrto ëd Sèra
Subject Re: transaction error handling
Date
Msg-id CAKwGa__C8k4nCfjGHoYDCrB2MWt2k_0qPVccnEPi=AVh0-o=Rg@mail.gmail.com
Whole thread Raw
In response to Re: transaction error handling  (Rob Richardson <RDRichardson@rad-con.com>)
Responses Re: transaction error handling
List pgsql-admin
On 29 November 2011 21:34, Rob Richardson <RDRichardson@rad-con.com> wrote:
If Oracle saves half of the data  between the beginning and ending of the transaction, doesn't that defeat the purpose of the transaction?
 
It sure enough kills Atomicity. I can see a use for this on importing data from external sources that may violate existing unique keys, so illegal inserts are ignored, but you still are left without any knowledge of what rows where silently dropped. Since when is Oracle doing this, FMI? (It's been a long while since I used it for anything serious)

Bèrto

--
==============================
If Pac-Man had affected us as kids, we'd all be running around in a darkened room munching pills and listening to repetitive music.

pgsql-admin by date:

Previous
From: Rural Hunter
Date:
Subject: Re: transaction error handling
Next
From: Rudolf van der Leeden
Date:
Subject: Upgrade from 9.0.5 to 9.1.1 - Problems with citext indexes