Misa,
Your statement is utterly false simply by virtue of the documentation. Inserts never propagate to other tables in a hierarchy Indexes/Constraints only apply to individual tables Since inserts do not propagate the base table never sees the records and thus the index on the base table cannot enforce uniqueness. Other caveats and restrictions to the current inheritance implementation can be found in section 5.8 (Inheritance) of the documentation. It is in the “Data Definition” chapter. David J. From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Misa Simic Sent: Wednesday, June 22, 2011 8:49 AM To: Tarlika Elisabeth Schmitz Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] unique across two tables Hi Tarlika, I think easy solution could be: create baseTable with just one column as PK TableA inhertis baseTable, it will have inherited Column + additianl tables for TableA TableB inherits baseTable, it will aslo have inherited Column + additianl tables for TableB Insert in any table TableA or TableB will automatically insert row in baseTable what will fail if value already exist...
