Re: MERGE Specification - Mailing list pgsql-hackers

From Hannu Krosing
Subject Re: MERGE Specification
Date
Msg-id 1209107004.6972.1.camel@huvostro
Whole thread Raw
In response to Re: MERGE Specification  (Simon Riggs <simon@2ndquadrant.com>)
Responses Re: MERGE Specification  (Simon Riggs <simon@2ndquadrant.com>)
List pgsql-hackers
On Tue, 2008-04-22 at 00:24 +0100, Simon Riggs wrote:
> On Mon, 2008-04-21 at 16:38 -0400, A.M. wrote:
> 
> > "MERGE will not invoke Rules." Does this imply that MERGE cannot be  
> > used on views or that the resulting INSERTs or UPDATEs do not work on  
> > views?
> 
> Yes, that's right. Just like COPY. That seems fine to me because you're
> likely to be doing a MERGE immediately after a COPY anyway, so the
> restriction just continues.

May be the bulk data merging variant of MERGE to be used after initial
COPY should be a variant of COPY with special keyword(s) instead of
MERGE ?

------------
Hannu




pgsql-hackers by date:

Previous
From: Gregory Stark
Date:
Subject: Re: Proposed patch - psql wraps at window width
Next
From: Simon Riggs
Date:
Subject: Re: MERGE Specification