Simon Riggs <[EMAIL PROTECTED]> writes: > 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. I find this to be pretty ugly. COPY is a special case because (a) it is a utility statement not a plannable one, and (b) its only reason to exist is to transfer data as fast as possible, so bypassing rules isn't an unreasonable restriction. MERGE has neither of those properties, and thus arguing that it can or should be like COPY is an entirely unconvincing proposition. (In fact, I don't even want to think about what kind of crock you're going to need in order to get it through the planner without also going through the rewriter.) Please think a bit harder. regards, tom lane -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers