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

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.