Re: MERGE vs REPLACE

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Cc: Jaime Casanova <systemguards(at)gmail(dot)com>, Peter Eisentraut <peter_e(at)gmx(dot)net>
Subject: Re: MERGE vs REPLACE
Date: 2005-11-11 21:55:49
Message-ID: 200511111355.49405.josh@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Jaime Casanova 2005-11-11 22:04:25 Re: MERGE vs REPLACE
Previous Message Tom Lane 2005-11-11 21:10:29 Re: Multi-table-unique-constraint