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

--On Dienstag, Januar 27, 2009 14:04:05 +0200 Peter Eisentraut 
<peter_e@gmx.net> wrote:

>> 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...
>
> A view is read-only if you don't grant any write permissions on it.

What i'm seeing here is a very divergent understanding what a "read-only" 
view is:

old-school PostgreSQL-Users would expect a "read-only" view to have no 
"write action" installed. If we want to follow the standard closely, they 
need to be installed automatically, changing this behavior, hence the wish 
to have a syntax to restore the old behavior (e.g. for pg_dump). I'm unsure 
what the correct approach looks like, but it seems we need a compromise.

--  Thanks
                   Bernd