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@gmail.com> wrote:
> On Thu, Nov 3, 2011 at 5:07 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> > "Greg Fausak" <greg@named.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
>