Re: MERGE Specification

On Fri, 2008-04-25 at 10:03 +0300, Hannu Krosing wrote:
> 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 ?

That does sound like a good way of differentiating between the OLTP and
bulk loading cases.

I'll bear that in mind as we develop.

-- 
  Simon Riggs
  2ndQuadrant  http://www.2ndQuadrant.com