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.
From:
anil maran Date: Subject:
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
Есть вопросы? Напишите нам!
Соглашаюсь с условиями обработки персональных данных
✖
By continuing to browse this website, you agree to the use of cookies. Go to Privacy Policy.