| From: | Josh Berkus <josh(at)agliodbs(dot)com> |
|---|---|
| To: | Jaime Casanova <jcasanov(at)systemguards(dot)com(dot)ec> |
| Cc: | 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>, 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 04:03:41 |
| Message-ID: | 497E879D.6020101@agliodbs.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-committers pgsql-hackers |
Jaime, Bernd,
> having said that, i don't think that inventing new syntax is the way
> to go... a reloption seems better (thinking a little more, it could be
> a problem if the user changes the reloptions of an already created
> view)
There's also the issue with backup/restore: we need some kind of syntax
for restoring a read-only view which doesn't depend on command ordering.
So we need a ALTER VIEW SET READ ONLY or similar.
Overall, I'm starting to think there's a lot of syntax and issues that
need to be worked out, and I'm thinking it's too late in the cycle to do
that for 8.4.
--Josh
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bernd Helmle | 2009-01-27 10:31:26 | Re: [COMMITTERS] pgsql: Automatic view update rules Bernd Helmle |
| Previous Message | Jaime Casanova | 2009-01-27 03:39:48 | Re: [COMMITTERS] pgsql: Automatic view update rules Bernd Helmle |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2009-01-27 04:05:13 | Re: Meridiem markers (was: [BUGS] Incorrect "invalid AM/PM string" error from to_timestamp) |
| Previous Message | Bruce Momjian | 2009-01-27 04:02:33 | Re: 8.4 release planning |