Phil Monroe's Profile

How would Postgres table inheritance play into this? Couldn't it simplify the database migrations?

http://www.postgresql.org/docs/9.2/static/ddl-inherit.html

In particular:

"ALTER TABLE will propagate any changes in column data definitions and check constraints down the inheritance hierarchy. Again, dropping columns that are depended on by other tables is only possible when using the CASCADE option. ALTER TABLE follows the same rules for duplicate column merging and rejection that apply during CREATE TABLE."