Re: Arrays and foreign keys

Поиск
Список
Период
Сортировка
От Kaare Rasmussen
Тема Re: Arrays and foreign keys
Дата
Msg-id 00081016553805.00770@bering
обсуждение исходный текст
Ответ на Re: Arrays and foreign keys  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
Ответы Re: Arrays and foreign keys  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
Re: Arrays and foreign keys  (Jan Wieck <janwieck@Yahoo.com>)
Re: Arrays and foreign keys  (Bruce Momjian <pgman@candle.pha.pa.us>)
Список pgsql-hackers
> Well, the two types aren't the same (one is an integer the
> other an integer array,) so I wouldn't expect it to work. Note: 

Eh, I could figure that out myself. What I'm asking for is if there is a way to
combine arrays with foreign keys?

I believe the answer for now is 'no', but did like to get it confirmed, and
also draw attention to this if someone wants to make it.

> * Make sure that types used in foreign key constraints
>   are comparable.

And maybe 
* Add foreign key constraint for arrays

-- 
Kaare Rasmussen            --Linux, spil,--        Tlf:        3816 2582
Kaki Data                tshirts, merchandize      Fax:        3816 2582
Howitzvej 75               �ben 14.00-18.00        Email: kar@webline.dk
2000 Frederiksberg        L�rdag 11.00-17.00       Web:      www.suse.dk


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

Предыдущее
От: Zeugswetter Andreas SB
Дата:
Сообщение: AW: VERY strange query plan (LONG)
Следующее
От: Stephan Szabo
Дата:
Сообщение: Re: Arrays and foreign keys