Обсуждение: Partitioned Tables Foreign Key Constraints Problem

Поиск

Список

Период

Сортировка

Partitioned Tables Foreign Key Constraints Problem

От

"Gauri Kanekar"

Дата:

24 июля 2008 г., 07:15:51

Hi all,

Have a problem related to partition tables.

We have the following schema's :

master -
id integer (PRIMARY KEY)
cid integer

child1, child2 are the child tables of master table. Here "cid" is the field used for partitioning.

We have another table called
other_tbl -
id integer (PRIMARY KEY)
m_id integer (FOREIGN KEY FROM master(id))

Now the problem is, since other_tbl->m_id referenced from master->id, if we try to insert any vales in "other_tbl" for m_id its checks it presence in only master table and not in its child table. As the master table is always empty in partitions tables a foreign key violation ERROR is being given.

How can we define the Foreign_key constraint on "other_tbl" based upon any partitioned table field.

--
Regards
Gauri

Re: Partitioned Tables Foreign Key Constraints Problem

От

Josh Berkus

Дата:

25 июля 2008 г., 19:32:10

Gauri,

> How can we define the Foreign_key constraint on "other_tbl" based upon
> any partitioned table field.

Currently PostgreSQL doesn't have any simple way to support this.  There
are a few workarounds, but they're fairly awkward, such as a trigger to
check if the ID is correct.

--Josh

Вход в личный кабинет

Восстановление пароля

Подтверждение аккаунта

Изменение пароля

Обсуждение: Partitioned Tables Foreign Key Constraints Problem

Partitioned Tables Foreign Key Constraints Problem

Re: Partitioned Tables Foreign Key Constraints Problem