Re: Foreign key constraint for array-field? - Mailing list pgsql-hackers

From Joshua D. Drake
Subject Re: Foreign key constraint for array-field?
Date
Msg-id 48D5D1A3.6060802@commandprompt.com
Whole thread Raw
In response to Re: Foreign key constraint for array-field?  (David Fetter <david@fetter.org>)
Responses Re: Foreign key constraint for array-field?  ("Dmitry Koterov" <dmitry@koterov.ru>)
List pgsql-hackers
David Fetter wrote:
> On Sun, Sep 21, 2008 at 04:38:56AM +0400, Dmitry Koterov wrote:
>> Hello.
>>
>> Is it possible to create a foreign key constraint for ALL elements of
>> an array field?
> 
> Whether it's possible or not--it probably is--it's a very bad idea.
> Just normalize :)

+1

> 
> Cheers,
> David.



pgsql-hackers by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: Do we really need a 7.4.22 release now?
Next
From: "Marko Kreen"
Date:
Subject: Re: [patch] fix dblink security hole