Re: MERGE vs REPLACE - Mailing list pgsql-hackers

From Josh Berkus
Subject Re: MERGE vs REPLACE
Date
Msg-id 200511111355.49405.josh@agliodbs.com
Whole thread Raw
In response to Re: MERGE vs REPLACE  (Jaime Casanova <systemguards@gmail.com>)
Responses Re: MERGE vs REPLACE  (Jaime Casanova <systemguards@gmail.com>)
Re: MERGE vs REPLACE  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Guys,

> I understand you well... what i was trying to say is that i prefer
> MERGE (standard SQL command) to be done because the functionally it
> has (basically a merge of two tables) seems to me to be more usefull
> than REPLACE (MySql Command)...

But even REPLACE requires predicate locking.  There's no real way to get 
around it.

--Josh

-- 
--Josh

Josh Berkus
Aglio Database Solutions
San Francisco


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Multi-table-unique-constraint
Next
From: "John Hansen"
Date:
Subject: Re: someone working to add merge?