On Mon, Jan 26, 2009 at 8:47 PM, Josh Berkus <j...@agliodbs.com> wrote: > Bruce, > >>> yes. we detect that and send a warning saying that there not be any rules >> >> OK, so we are going to need an option to suppress that warning, even >> without the problems of upgrades and customization. > > Per my response earlier, I think we really logically need an error if the > user specifies UPDATABLE. >
a view should be updatable by default if the query expression is updatable... what we need is something to make a view READ ONLY even if it should be updatable by spec... having said that, i don't think that inventing new syntax is the way to go... a reloption seems better (thinking a little more, it could be a problem if the user changes the reloptions of an already created view) -- Atentamente, Jaime Casanova Soporte y capacitación de PostgreSQL AsesorÃa y desarrollo de sistemas Guayaquil - Ecuador Cel. +59387171157 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers