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?
In response to
pgsql-admin by date
|Next:||From: Scott Marlowe||Date: 2011-11-29 18:36:20|
|Subject: Re: Deadlock on "select ... for update"?|
|Previous:||From: Craig James||Date: 2011-11-29 18:15:32|
|Subject: Deadlock on "select ... for update"?|
pgsql-bugs by date
|Next:||From: Kevin Grittner||Date: 2011-11-29 18:55:16|
|Subject: Re: transaction error handling|
|Previous:||From: Kasia Tuszynska||Date: 2011-11-29 17:57:24|
|Subject: transaction error handling |