| From: | Bernd Helmle <mailings(at)oopsware(dot)de> |
|---|---|
| To: | Guillaume Smet <guillaume(dot)smet(at)gmail(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | Jaime Casanova <jcasanov(at)systemguards(dot)com(dot)ec>, 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-25 12:07:09 |
| Message-ID: | FA56B1BA483870D3F4FBC0AC@imhotep.credativ.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-committers pgsql-hackers |
--On Sonntag, Januar 25, 2009 09:41:14 +0100 Guillaume Smet
<guillaume(dot)smet(at)gmail(dot)com> wrote:
>> I think that we probably want the rules to show up automatically during
>> an upgrade from an older version
>
> I'm really not convinced by that. Is it required by the standard? It's
> really far from being compliant with the principle of least surprise.
> Personnally, I don't expect my views to become updatable.
>
> There should be an easy way to make a view become updatable but making
> all of them updatable automagically on upgrade seems weird.
I didn't find such a notion in the standard. A view is automatically
updatable if it meets the criteria of updatability). If you don't want your
view writable, you have to GRANT the necessary ACLs.
I originally had the idea of a GUC which controls wether automatic rules
will be generated or not. But I abonded this idea, since this has some kind
of "parametrized SQL standard functionality".
--
Thanks
Bernd
| From | Date | Subject | |
|---|---|---|---|
| Next Message | ormod | 2009-01-25 13:45:57 | pgmemcache: pgmemcache README.pgmemcache pgmemcache.c pgmemcache.h pgmemcache.sql.in test.sql |
| Previous Message | Guillaume Smet | 2009-01-25 08:41:14 | Re: [COMMITTERS] pgsql: Automatic view update rules Bernd Helmle |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Grzegorz Jaskiewicz | 2009-01-25 12:13:44 | Re: Hot standby, dropping a tablespace |
| Previous Message | Heikki Linnakangas | 2009-01-25 09:28:42 | Re: Hot standby, dropping a tablespace |