"Stefan Scheidegger" <[EMAIL PROTECTED]> writes: > Why is this not possible? It seems that this is about inheritance. When I > reference directly to tbl_child1, everything works just fine.
I'm afraid inheritance doesn't work with foreign key references. You can have references to specific tables but they don't include any child tables. A related limitation is that you can't enforce unique constraints across tables and their children. Solving this doesn't seem to be high on anyone's priority list. If anything what interests more people is using inheritance for partitioning support. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about EnterpriseDB's PostGIS support! ---------------------------(end of broadcast)--------------------------- TIP 1: 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