Inheritance + references fixup

Started by Ilia Kantorover 20 years ago1 messages
#1Ilia Kantor
ilia@obnovlenie.ru

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.