Embed Notice

@evan
PG docs say "SQL:1999 and later define a type inheritance feature, which differs in many respects from the features described here."

One major caveat I see in PG's INHERIT is that indexes & constraints do not extend into child tables.

Informix doc, however:

"In a table hierarchy, a subtable automatically inherits the following properties from its supertable:

All constraint definitions (primary key, unique, & referential constraints)
Storage option, All triggers, Indexes,... "