Re: unique across two tables

true :(

My applogize to all - my BIG fault - i haven't tested that before sent
suggestion

Kind Regards,

Misa

2011/6/22 David Johnston <polobo(at)yahoo(dot)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-owner(at)postgresql(dot)org [mailto:
> pgsql-general-owner(at)postgresql(dot)org] *On Behalf Of *Misa Simic
> *Sent:* Wednesday, June 22, 2011 8:49 AM
> *To:* Tarlika Elisabeth Schmitz
> *Cc:* pgsql-general(at)postgresql(dot)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...****
>
> ** **
>
> ** **
>
> ** **
>