Re: MERGE vs REPLACE - Mailing list pgsql-hackers

From Jaime Casanova
Subject Re: MERGE vs REPLACE
Date
Msg-id c2d9e70e0511111404u3d1387cej58e5564b4b76bbe8@mail.gmail.com
Whole thread Raw
In response to Re: MERGE vs REPLACE  (Josh Berkus <josh@agliodbs.com>)
Responses Re: MERGE vs REPLACE  (Josh Berkus <josh@agliodbs.com>)
List pgsql-hackers
On 11/11/05, Josh Berkus <josh@agliodbs.com> wrote:
> 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
>

why? seems that REPLACE only work if there are at least one row matching...

--
Atentamente,
Jaime Casanova
(DBA: DataBase Aniquilator ;)


pgsql-hackers by date:

Previous
From: "John Hansen"
Date:
Subject: Re: someone working to add merge?
Next
From: Bryan White
Date:
Subject: Re: How to find a number of connections