Re: BUG #6286: Table Partitioning - SQL/MED - interaction broken - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #6286: Table Partitioning - SQL/MED - interaction broken
Date
Msg-id 10925.1320427296@sss.pgh.pa.us
Whole thread Raw
In response to Re: BUG #6286: Table Partitioning - SQL/MED - interaction broken  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: BUG #6286: Table Partitioning - SQL/MED - interaction broken  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-bugs
Robert Haas <robertmhaas@gmail.com> writes:
> On Thu, Nov 3, 2011 at 5:07 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> 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.

Well, what I had in mind was disallowing any rules to be attached to an
inheritance child, because they won't get expanded.  However, you have a
point I guess: someone could conceivably want to have a rule that only
takes effect when a child is accessed directly.

            regards, tom lane

pgsql-bugs by date:

Previous
From: Greg Fausak
Date:
Subject: Re: BUG #6286: Table Partitioning - SQL/MED - interaction broken
Next
From: "Jim Jackson \(817\) 233-2385"
Date:
Subject: Re: BUG #6281: need to remove