Thread: Inheritance + references fixup

Inheritance + references fixup

From
"Ilia Kantor"
Date:
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.