Re: Adding MERGE to the TODO list (resend with subject) - Mailing list pgsql-hackers

From Christopher Kings-Lynne
Subject Re: Adding MERGE to the TODO list (resend with subject)
Date
Msg-id 409DAFEB.7020300@familyhealth.com.au
Whole thread Raw
In response to Re: Adding MERGE to the TODO list (resend with subject)  (Alvaro Herrera <alvherre@dcc.uchile.cl>)
Responses Re: Adding MERGE to the TODO list (resend with subject)  (Alvaro Herrera <alvherre@dcc.uchile.cl>)
List pgsql-hackers
> I intend to release locks on subtransaction abort, so if the update
> fails there's room for another transaction to insert the key (which I
> understand should fail?).  I guess there's a different locking mechanism
> needed; I believe nested transactions will not be enough.

Except you can keep trying and trying without the outermost transaction 
failing.

Chris



pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Adding MERGE to the TODO list (resend with subject)
Next
From: Shachar Shemesh
Date:
Subject: Re: Relocatable installs