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

Tom Lane wrote:
> Bernd Helmle <mailings@oopsware.de> writes:
> > Or what about
> > CREATE [OR REPLACE] [UPDATABLE] VIEW ... ?
> > This looks closer to TEMP|TEMPORARY VIEW, which we already have.
> 
> But per spec, UPDATABLE should be the default (if not now, then
> eventually).  Are you proposing
>     CREATE [OR REPLACE] [[NOT] UPDATABLE] VIEW ...
> ?  Seems confusing.

UNUPDATABLE?  :-)

BTW, how do we handle cases where the query cannot be updatable, e.g.
aggregates?  Do we throw a warning?

--  Bruce Momjian  <bruce@momjian.us>        http://momjian.us EnterpriseDB
http://enterprisedb.com
 + If your life is a hard drive, Christ can be your backup. +