"Sven Klemm" <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
