Skip site navigation (1) Skip section navigation (2)

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

From: "Sven Klemm" <sven(at)c3d2(dot)de>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #2779: Making an inherited table to a view causes could not open relation error in base table
Date: 2006-11-24 18:35:44
Message-ID: 200611241835.kAOIZiOj046288@wwwmaster.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-bugs
The following bug has been logged online:

Bug reference:      2779
Logged by:          Sven Klemm
Email address:      sven(at)c3d2(dot)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.

Responses

pgsql-bugs by date

Next:From: Tom LaneDate: 2006-11-24 21:37:21
Subject: Re: BUG #2779: Making an inherited table to a view causes could not open relation error in base table
Previous:From: Дейтер Александр ВалериевичDate: 2006-11-24 11:22:12
Subject: PostgreSQL 8.1.5: regression tests fail on sparc

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group