Re: Partitioned Tables Foreign Key Constraints Problem

Поиск
Список
Период
Сортировка
От Josh Berkus
Тема Re: Partitioned Tables Foreign Key Constraints Problem
Дата
Msg-id 488A545B.4070609@agliodbs.com
обсуждение исходный текст
Ответ на Partitioned Tables Foreign Key Constraints Problem  ("Gauri Kanekar" <meetgaurikanekar@gmail.com>)
Список pgsql-performance
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


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

Предыдущее
От: "Gauri Kanekar"
Дата:
Сообщение: Partitioned Tables Foreign Key Constraints Problem
Следующее
От: "David Andersen"
Дата:
Сообщение: Using ENUM with huge NAMEDATALEN