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

> 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