Re: gSoC add MERGE command new patch -- merge_v104 - Mailing list pgsql-hackers

From Marko Tiikkaja
Subject Re: gSoC add MERGE command new patch -- merge_v104
Date
Msg-id 4C74CB2E.9060805@cs.helsinki.fi
Whole thread Raw
In response to Re: gSoC add MERGE command new patch -- merge_v104  (Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>)
List 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


pgsql-hackers by date:

Previous
From: Andrew Dunstan
Date:
Subject: Re: WIP: extensible enums
Next
From: Dimitri Fontaine
Date:
Subject: Re: EXPLAIN doesn't show the actual function expression for FunctionScan