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

Right. Thanks for all the feedback guys.
I was just trying to figure out how to do sql/med with partitioned tables.
Can't go there, got it.

-g

On Fri, Nov 4, 2011 at 11:14 AM, Robert Haas <robertmhaas(at)gmail(dot)com> wrote:

> 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
>