Re: unique across two tables

Поиск
Список
Период
Сортировка
От Misa Simic
Тема Re: unique across two tables
Дата
Msg-id BANLkTimUpsyv5F=F4GdsOJW6+9t3Jd4=7w@mail.gmail.com
обсуждение исходный текст
Ответ на Re: unique across two tables  ("David Johnston" <polobo@yahoo.com>)
Список pgsql-general
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@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-owner@postgresql.org [mailto:pgsql-general-owner@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...

 

 

 


В списке pgsql-general по дате отправления:

Предыдущее
От: "David Johnston"
Дата:
Сообщение: Re: unique across two tables
Следующее
От: Merlin Moncure
Дата:
Сообщение: Re: CRUD plpgsql generator