Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-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

pgsql-admin by date

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

pgsql-bugs by date

Next:From: Kevin GrittnerDate: 2011-11-29 18:55:16
Subject: Re: transaction error handling
Previous:From: Kasia TuszynskaDate: 2011-11-29 17:57:24
Subject: transaction error handling

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group