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. +