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

Re: BUG #6286: Table Partitioning - SQL/MED - interaction broken

From: Robert Haas <robertmhaas(at)gmail(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Greg Fausak <greg(at)named(dot)com>, pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #6286: Table Partitioning - SQL/MED - interaction broken
Date: 2011-11-04 16:14:10
Message-ID: CA+TgmoYS8QOURhv8tjZ=mTQ+QMH6w1E1NUVrxfbamLd2USSxog@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-bugs
On Thu, Nov 3, 2011 at 5:07 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> "Greg Fausak" <greg(at)named(dot)com> writes:
>> Here is the bug when trying to use the two together with a rule to bind
>> them:
>
>> create rule "_RETURN" as on select to X do instead select * from Y;
>
> Creating rules on inheritance children isn't supported, and you should
> not hold your breath waiting for it to be.
>
> We probably ought to have something in there to throw an error ...

Probably not for rules in general, but we shouldn't let people turn
tables into views if they are involved in table inheritance, as either
a parent or a child.

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

In response to

Responses

pgsql-bugs by date

Next:From: Greg FausakDate: 2011-11-04 16:16:54
Subject: Re: BUG #6286: Table Partitioning - SQL/MED - interaction broken
Previous:From: Kevin GrittnerDate: 2011-11-04 16:13:54
Subject: Re: BUG #6281: need to remove

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