> > Is it > > possible to have FK that spans into child tables? > > This is a well known (and documented, see [1]) deficiency. It's due to > the current implementation of indices, which are bound to exactly one > table, meaning they do return a position within the table, but cannot > point to different tables. Is this set to be fixed in any particular release? (Here's hoping that someone smarter than I am is working on it...) -W ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq