Re: foreign keys for array/period contains relationships

Поиск
Список
Период
Сортировка
От Peter Eisentraut
Тема Re: foreign keys for array/period contains relationships
Дата
Msg-id 1288113737.22800.1.camel@vanquo.pezone.net
обсуждение исходный текст
Ответ на Re: foreign keys for array/period contains relationships  (Pavel Stehule <pavel.stehule@gmail.com>)
Список pgsql-hackers
On mån, 2010-10-25 at 22:10 +0200, Pavel Stehule wrote:
> 2010/10/25 Robert Haas <robertmhaas@gmail.com>:
> >> Example #1: Foreign key side is an array, every member must match some
> >> PK.
> >>
> >> CREATE TABLE pk (a int PRIMARKY KEY, ...);
> >>
> >> CREATE TABLE fk (x int[] REFERENCES pk (a), ...);
> 
> What about optimalizations and planning?

Some work will be required to get the respective checking queries to do
the right think fast, but it's solvable in principle.




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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: xlog.c: WALInsertLock vs. WALWriteLock
Следующее
От: Peter Eisentraut
Дата:
Сообщение: Re: foreign keys for array/period contains relationships