true :( My applogize to all - my BIG fault - i haven't tested that before sent suggestion
Kind Regards, Misa 2011/6/22 David Johnston <pol...@yahoo.com> > 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...**** > > ** ** > > ** ** > > ** ** >