Jan Wieck wrote:
>
> Tom Lane wrote:
> > "Mark Hollomon" <mhh@nortelnetworks.com> writes:
> > > Just out of curiousity, is there technical reason there isn't
> > > a (say) relisview attribute to pg_class?
> >
> > That might indeed be the most reasonable way to attack it, rather
> > than having to go messing about looking for a matching rule.
> > (Jan, any thoughts here?)
>
> The right way IMHO would be to give views another relkind.
> Then we could easily
>
> 1. detect if the final query after rewriting still tries to
> INSERT/UPDATE/DELETE a view - i.e. "missing rewrite
> rule(s)".
This appeals to me. The current silent no-op behavior of INSERT/DELETE on a view
is annoying.
--
Mark Hollomon
mhh@nortelnetworks.com
ESN 451-9008 (302)454-9008