Re: transaction error handling - Mailing list pgsql-admin

From Rob Richardson
Subject Re: transaction error handling
Date
Msg-id 67D108EDFAD3C148A593E6ED7DCB4BBDEDDBAE@RADCONWIN2K8PDC.radcon.local
Whole thread Raw
In response to transaction error handling  (Kasia Tuszynska <ktuszynska@esri.com>)
Responses Re: transaction error handling  (Rural Hunter <ruralhunter@gmail.com>)
Re: transaction error handling  (Bèrto ëd Sèra <berto.d.sera@gmail.com>)
Re: transaction error handling  ("Nicholson, Brad (Toronto, ON, CA)" <bnicholson@hp.com>)
List pgsql-admin
Very naïve question here:  Why would you want to save the data from the first insert?

I thought the purpose of a transaction was to make sure that all steps in the transaction executed, or none of them
executed. If Oracle saves half of the data  between the beginning and ending of the transaction, doesn't that defeat
thepurpose of the transaction? 

RobR

pgsql-admin by date:

Previous
From: senthilnathan
Date:
Subject: Re: streaming replication
Next
From: senthilnathan
Date:
Subject: Read Only Role