2010/5/20 Pavel <[email protected]>: > > d) what to do when someone use INSERT, UPDATE or DELETE against MV? > 1 - raise error? - I prefer this option
+1, FWIW > 2 - let commands change MV? (no chance to let changes propagate to > source tables, not for this summer :) > if pg lets user to DML against MV, I expect that triggers should work too > no, if you don't propagate then you don't have a view of the tables the MV comes from... error if you'll not implement propagation now -- Jaime Casanova www.2ndQuadrant.com Soporte y capacitación de PostgreSQL -- Sent via pgsql-hackers mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
