Re: someone working to add merge? - Mailing list pgsql-hackers

Jaime Casanova wrote:

>>Funny, we were just discussing this at OpenDBCon.   Seems that you can't do a
>>full implementation of MERGE without Predicate Locking (the ability to say
>>"lock this table against inserts or updates of any row with key=5").
>>    
>>
>
>it isn't what select for update does?
>
>  
>
>  
>

It won't prevent the insertion of a row with the given predicate.

cheers

andrew