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 <[email protected]> wrote: > On Thu, Nov 3, 2011 at 5:07 PM, Tom Lane <[email protected]> wrote: > > "Greg Fausak" <[email protected]> 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 >
