On Thu, 31 Oct 2002, Stefan Schwarzer wrote: > I think I've found a bug (see below). If you think it's not a bug, I > would be thankful for a workaround. I tried omitting the foreign key > constraint. That works but is unsatisfactory.
Foreign key constraints reference only the table named in the constraint, not any of its children and isn't inherited to children. If the row were in test_parent specifically, it would have worked. In general I haven't seen any great workarounds, usually I'd suggest splitting the key columns to a separate table and have the each table in the tree reference that. ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
