| From: | Bruce Momjian <bruce(at)momjian(dot)us> |
|---|---|
| To: | Jaime Casanova <jcasanov(at)systemguards(dot)com(dot)ec> |
| Cc: | 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>, Peter Eisentraut <peter_e(at)gmx(dot)net>, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: [COMMITTERS] pgsql: Automatic view update rules Bernd Helmle |
| Date: | 2009-01-27 00:56:14 |
| Message-ID: | 200901270056.n0R0uEl22715@momjian.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-committers pgsql-hackers |
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
OK, so we are going to need an option to suppress that warning, even
without the problems of upgrades and customization.
We already use READ ONLY in SET TRANSACTION and START TRANSACTION, so it
would be logical to use READ ONLY to control this.
--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ If your life is a hard drive, Christ can be your backup. +
| From | Date | Subject | |
|---|---|---|---|
| Next Message | User Itagaki | 2009-01-27 01:35:54 | reorg - pg_reorg: workaround with 8.2. |
| Previous Message | Josh Berkus | 2009-01-26 22:22:56 | Re: [COMMITTERS] pgsql: Automatic view update rules Bernd Helmle |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Rick Vernam | 2009-01-27 00:58:22 | Re: 8.4 release planning |
| Previous Message | ITAGAKI Takahiro | 2009-01-27 00:50:28 | Re: Compiler warnings fix |