Re: MERGE vs REPLACE - Mailing list pgsql-hackers

From Jaime Casanova
Subject Re: MERGE vs REPLACE
Date
Msg-id c2d9e70e0511160900r22075e21uc3040514f488ee02@mail.gmail.com
Whole thread Raw
In response to Re: MERGE vs REPLACE  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: MERGE vs REPLACE  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: MERGE vs REPLACE  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-hackers
On 11/16/05, Bruce Momjian <pgman@candle.pha.pa.us> wrote:
>
> Interesting approach.  Actually, we could tell the user they have to use
> BEGIN;LOCK tab before doing MERGE, and throw an error if we don't
> already have a table lock.
>

If the lock will be required, what's the problem in doing it
internally? without user interaction?

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


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: OS X 7.4 failure
Next
From: Tom Lane
Date:
Subject: Re: MERGE vs REPLACE