On Mon, 8 Dec 2003, Stephan Szabo wrote: > On Tue, 9 Dec 2003, Brendan Jurd wrote: > > > Hi all, > > > > I read on the manual page for Inheritance that: > > > > "A limitation of the inheritance feature is that indexes (including > > unique constraints) and foreign key constraints only apply to single > > tables, not to their inheritance children. Thus, in the above example, > > specifying that another table's column REFERENCES cities(name) would > > allow the other table to contain city names but not capital names. This > > deficiency will probably be fixed in some future release." > > > > I have a few projects that could benefit from inherited table structure, > > and it's a very cool idea, but this inability of indexes to include > > derived tables is a real functionality-killer. It's not "Object > > Relational" if the objects can't be related to anything! > > > > If someone could give me an idea of how far away this fix is, I'd be > > grateful. > > I'd say at least 1, probably more versions out. Unique constraints across
Errm, that was supposed to say "at least 2," given the absense of a good plan. ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]