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:

Reply via email to