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.