i would like to suggest the following modification to the foreign key
syntax (and underlying implementation) to support table inheritance:
alter table [only] foo add foreign key (a_field) references [only] bar
(another_field) on delete restrict;
the only changes from the current syntax are the "[only]" modifiers
(pardon the pun) to the source and target tables. this modifier would
behave the same was as the "[only]" modifier in the "from [only]
foo_table" clause.
i really, really need foreign keys to support table inheritance. right
now, i have a script i run that generates 1000's of alter table commands
because i have to take into account not only the target table's
inheritance but the source table's inheritance too and all the
combinations of inheriting tables between them.
postgresql developers: please treat this as an enhancement request. i
think this would be a very popular enhancement.
--
Soli Deo gloria,
Floyd Shackelford