2010/5/20 Pavel <baro...@seznam.cz>: > > 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 (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
