Skip site navigation (1) Skip section navigation (2)

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

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 (view raw or flat)
Thread:
Lists: pgsql-committerspgsql-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


In response to

Responses

pgsql-hackers by date

Next:From: Tom LaneDate: 2009-01-27 04:05:13
Subject: Re: Meridiem markers (was: [BUGS] Incorrect "invalid AM/PM string" error from to_timestamp)
Previous:From: Bruce MomjianDate: 2009-01-27 04:02:33
Subject: Re: 8.4 release planning

pgsql-committers by date

Next:From: Bernd HelmleDate: 2009-01-27 10:31:26
Subject: Re: [COMMITTERS] pgsql: Automatic view update rules Bernd Helmle
Previous:From: Jaime CasanovaDate: 2009-01-27 03:39:48
Subject: Re: [COMMITTERS] pgsql: Automatic view update rules Bernd Helmle

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group