Re: MERGE Specification
Hannu Krosing <hannu@krosing.net>
From: Hannu Krosing <hannu@krosing.net>
To: Simon Riggs <simon@2ndquadrant.com>
Cc: pgsql-hackers@postgresql.org
Date: 2008-04-25T07:03:24Z
Lists: 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