Bruce Momjian wrote:
> 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.
I'd frankly look at WITH, which is where we've historically stuck
non-SQL extensions.
> BTW, how do we handle cases where the query cannot be updatable, e.g.
> aggregates? Do we throw a warning?
>
Error if "updatable" is specified, warning if not.
--Josh