Tom Lane wrote: > "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.
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 ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
