Postgress supports creating table with inheritance
CREATE TABLE cities (
altitude int – (in ft)
CREATE TABLE capitals (
) INHERITS (cities);
(excerpt from postgressql documentation)
Will TDM3 support this sometimes in the future ?
I am definitely sure I will “convert” myself to the PostgreSQL world and this inheritance is very tempting to use.
I tried to create 2 tables in logical designer with inheritance. Changed the inheritance type to “Physical as logical”, but when createing tables in physical model, tables are created but no inheritance in PostgreSQL DDL script.
I see that there are “with OIDS” checkboxes in tables for PostgreSQL physical tables. Maybe similar check could be added for this inheritance when there is foreign key added from one table to another.