BUG #2779: Making an inherited table to a view causes could not open relation error in base table

Поиск
Список
Период
Сортировка
От Sven Klemm
Тема BUG #2779: Making an inherited table to a view causes could not open relation error in base table
Дата
Msg-id 200611241835.kAOIZiOj046288@wwwmaster.postgresql.org
обсуждение исходный текст
Ответы Re: BUG #2779: Making an inherited table to a view causes could not open relation error in base table
Список pgsql-bugs
The following bug has been logged online:

Bug reference:      2779
Logged by:          Sven Klemm
Email address:      sven@c3d2.de
PostgreSQL version: 8.1
Operating system:   Linux (Debian)
Description:        Making an inherited table to a view causes could not
open relation error in base table
Details:

Steps to reproduce:

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;

SELECT * FROM child;
SELECT * FROM ONLY base;
-- the next query causes the error
SELECT * FROM base;

After dropping child queries to base work again.

В списке pgsql-bugs по дате отправления:

Предыдущее
От: "Leon Miller-Out"
Дата:
Сообщение: Re: BUG #2759: \df doesn't show functions with no args
Следующее
От: anil maran
Дата:
Сообщение: Error in postgresql after crash unable to restart this needs to be posted on -hackers or -bugs, so that tom, oleg and teodor can take a look