Re: Arrays and foreign keys - Mailing list pgsql-hackers

From Kaare Rasmussen
Subject Re: Arrays and foreign keys
Date
Msg-id 00081016553805.00770@bering
Whole thread Raw
In response to Re: Arrays and foreign keys  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
Responses Re: Arrays and foreign keys
Re: Arrays and foreign keys
Re: Arrays and foreign keys
List 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 by date:

Previous
From: Zeugswetter Andreas SB
Date:
Subject: AW: VERY strange query plan (LONG)
Next
From: Stephan Szabo
Date:
Subject: Re: Arrays and foreign keys