Common problem with inheritance is that references work ONLY with top table and are not propagated to children.
Is it possible to write triggers (like utils/adt/ri_triggers.c) which will act on INSERT/UPDATE/DELETE and check/cascade/restrict properly ? pg_attribute, pg_inherits inherits can be used along with an additional (non-system) table to store foreign keys. ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match