Re: [COMMITTERS] pgsql: Automatic view update rules Bernd Helmle

On Mon, Jan 26, 2009 at 8:47 PM, Josh Berkus <josh@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