Re: [COMMITTERS] pgsql: Automatic view update rules Bernd Helmle - Mailing list pgsql-hackers

From Guillaume Smet
Subject Re: [COMMITTERS] pgsql: Automatic view update rules Bernd Helmle
Date
Msg-id 1d4e0c10901250041l5bcbfcfahb131fbd21741d481@mail.gmail.com
Whole thread Raw
In response to Re: [COMMITTERS] pgsql: Automatic view update rules Bernd Helmle  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: [COMMITTERS] pgsql: Automatic view update rules Bernd Helmle  (Bernd Helmle <mailings@oopsware.de>)
List pgsql-hackers
On Sat, Jan 24, 2009 at 1:17 AM, Tom Lane <tgl@sss.pgh.pa.us> 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.

Another question related to the choice of explicit rules for the
implementation: if we change the way these rules are generated in 8.5,
will we upgrade all the existing rules? What if the user modified one
of them on purpose?

-- 
Guillaume


pgsql-hackers by date:

Previous
From: Jaime Casanova
Date:
Subject: Re: [COMMITTERS] pgsql: Automatic view update rules Bernd Helmle
Next
From: Simon Riggs
Date:
Subject: Re: Hot standby, dropping a tablespace