| From: | Peter Eisentraut <peter_e(at)gmx(dot)net> |
|---|---|
| To: | pgsql-hackers(at)postgresql(dot)org |
| Cc: | Jaime Casanova <jcasanov(at)systemguards(dot)com(dot)ec>, Bruce Momjian <bruce(at)momjian(dot)us>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Bernd Helmle <mailings(at)oopsware(dot)de>, Andrew Dunstan <andrew(at)dunslane(dot)net>, Guillaume Smet <guillaume(dot)smet(at)gmail(dot)com> |
| Subject: | Re: [COMMITTERS] pgsql: Automatic view update rules Bernd Helmle |
| Date: | 2009-01-27 12:05:00 |
| Message-ID: | 200901271405.01678.peter_e@gmx.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-committers pgsql-hackers |
On Tuesday 27 January 2009 00:21:08 Jaime Casanova wrote:
> On Mon, Jan 26, 2009 at 5:18 PM, Bruce Momjian <bruce(at)momjian(dot)us> wrote:
> > Tom Lane wrote:
> >> Bernd Helmle <mailings(at)oopsware(dot)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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter Eisentraut | 2009-01-27 12:40:16 | pgsql: Revert updatable views |
| Previous Message | Peter Eisentraut | 2009-01-27 12:04:05 | Re: [COMMITTERS] pgsql: Automatic view update rules Bernd Helmle |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Zdenek Kotala | 2009-01-27 12:06:48 | [PATCH] Space reservation v02 |
| Previous Message | Peter Eisentraut | 2009-01-27 12:04:05 | Re: [COMMITTERS] pgsql: Automatic view update rules Bernd Helmle |