Re: gSoC add MERGE command new patch -- merge_v104

Marko Tiikkaja <marko.tiikkaja@cs.helsinki.fi>

From: Marko Tiikkaja <marko.tiikkaja@cs.helsinki.fi>

To: Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>

Cc: Andres Freund <andres@anarazel.de>, Boxuan Zhai <bxzhai2010@gmail.com>, pgsql-hackers@postgresql.org

Date: 2010-08-25T07:50:06Z

Lists: pgsql-hackers

On 2010-08-25 9:26 AM +0300, Heikki Linnakangas wrote:
>> Whats the plan to go forward at that subject? I think the patch needs
>> to lock tables exclusively (the pg level, not access exclusive) as
>> long as there is no additional handling...
>
> Well, you can always do LOCK TABLE before calling MERGE if that's what
> you want, but I don't think doing that automatically would make people
> happy.

I don't think having a MERGE that throws UNIQUE violations would make 
people happy either.


Regards,
Marko Tiikkaja