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

From Zeugswetter Andreas OSB sIT
Subject Re: [COMMITTERS] pgsql: Automatic view update rules Bernd Helmle
Date
Msg-id 6DAFE8F5425AB84DB3FCA4537D829A561CF5E55F5F@M0164.s-mxs.net
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  (Jaime Casanova <jcasanov@systemguards.com.ec>)
List pgsql-hackers
> There is another thing that's bothering me, though, which is that the
> present approach to dumping rules isn't adequate.  Consider the
> following scenario:
>
> 1. You create a view that the system considers updatable, so
> it creates
> some automatic rules.
>
> 2. You don't want those rules, so you delete them, leaving
> you with the
> traditional behavior where attempted inserts etc on the view fail.

Is that why other db's only make views updateable, that are created
"WITH CHECK OPTION" ? Should we also follow that path ?

Andreas

pgsql-hackers by date:

Previous
From: Heikki Linnakangas
Date:
Subject: Re: 8.4 release planning (was Re: [COMMITTERS] pgsql: Automatic view update rules)
Next
From: Dave Page
Date:
Subject: Re: 8.4 release planning (was Re: [COMMITTERS] pgsql: Automatic view update rules)