Re: Arrays and foreign keys

From: Kaare Rasmussen <kar(at)webline(dot)dk>
To: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Arrays and foreign keys
Date: 2000-08-10 14:53:23
Message-ID: 00081016553805.00770@bering
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)webline(dot)dk
2000 Frederiksberg Lrdag 11.00-17.00 Web: www.suse.dk

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Louis-David Mitterrand 2000-08-10 15:26:46 problem with float8 input format
Previous Message Zeugswetter Andreas SB 2000-08-10 09:15:29 AW: AW: VERY strange query plan (LONG)