Bruce Momjian wrote:
Tom Lane wrote:
Bernd Helmle <maili...@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
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
