Re: transaction error handling

From: Rob Richardson <RDRichardson(at)rad-con(dot)com>
To: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: transaction error handling
Date: 2011-11-29 18:34:49
Message-ID: 67D108EDFAD3C148A593E6ED7DCB4BBDEDDBAE@RADCONWIN2K8PDC.radcon.local
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-bugs

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 the purpose of the transaction?

RobR

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Scott Marlowe 2011-11-29 18:36:20 Re: Deadlock on "select ... for update"?
Previous Message Craig James 2011-11-29 18:15:32 Deadlock on "select ... for update"?

Browse pgsql-bugs by date

  From Date Subject
Next Message Kevin Grittner 2011-11-29 18:55:16 Re: transaction error handling
Previous Message Kasia Tuszynska 2011-11-29 17:57:24 transaction error handling