On Tuesday 27 January 2009 00:21:08 Jaime Casanova wrote:
> On Mon, Jan 26, 2009 at 5:18 PM, Bruce Momjian <bruce@momjian.us> 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.
> >
> > UNUPDATABLE? :-)
> >
> > BTW, how do we handle cases where the query cannot be updatable, e.g.
> > aggregates? Do we throw a warning?
>
> yes. we detect that and send a warning saying that there not be any rules
No, you get a notice *if* the view is updatable. You don't get anything if
the view is not.