"Sven Klemm" <sven(at)c3d2(dot)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.
regards, tom lane