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

From Alvaro Herrera
Subject Re: Adding MERGE to the TODO list (resend with subject)
Date
Msg-id 20040509051825.GB917@dcc.uchile.cl
Whole thread Raw
In response to Re: Adding MERGE to the TODO list (resend with subject)  (Christopher Kings-Lynne <chriskl@familyhealth.com.au>)
Responses Re: Adding MERGE to the TODO list (resend with subject)  (Christopher Kings-Lynne <chriskl@familyhealth.com.au>)
List pgsql-hackers
On Sun, May 09, 2004 at 12:13:31PM +0800, Christopher Kings-Lynne wrote:
> >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.

But that won't provide the necessary next key locking you mentioned in
your first email, will it?

-- 
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
"No necesitamos banderas
No reconocemos fronteras"                  (Jorge González)


pgsql-hackers by date:

Previous
From: Marc Slemko
Date:
Subject: Re: Relocatable installs
Next
From: Christopher Kings-Lynne
Date:
Subject: Re: Adding MERGE to the TODO list (resend with subject)