Re: Foreign key constraint for array-field?

From: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
To: David Fetter <david(at)fetter(dot)org>
Cc: Dmitry Koterov <dmitry(at)koterov(dot)ru>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Foreign key constraint for array-field?
Date: 2008-09-21 04:46:27
Message-ID: 48D5D1A3.6060802@commandprompt.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Marko Kreen 2008-09-21 09:09:10 Re: [patch] fix dblink security hole
Previous Message Joshua D. Drake 2008-09-21 03:47:53 Re: Do we really need a 7.4.22 release now?