Tom Lane wrote:
> "Sven Klemm" <sven@c3d2.de> writes:
> > CREATE TABLE base( name TEXT );
> > CREATE TABLE child() INHERITS( base );
>
> > CREATE RULE "_RETURN" AS ON SELECT TO child DO INSTEAD SELECT 'Chunky
> > Bacon'::text AS name;
>
> This is definitely in the category of "don't do that". It's an
> oversight that DefineQueryRewrite() doesn't check for the case.
>
> Actually, I wonder whether we still need to support conversion of
> tables to views at all. That was never meant as anything but a
> temporary hack to allow loading pre-7.1 pg_dump scripts.
IIRC I tried it when I was reviewing the updatable views patch, and it
worked.
--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support