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

From David Fetter
Subject Re: Foreign key constraint for array-field?
Date
Msg-id 20080921034645.GA18040@fetter.org
Whole thread Raw
In response to Foreign key constraint for array-field?  ("Dmitry Koterov" <dmitry@koterov.ru>)
Responses Re: Foreign key constraint for array-field?  ("Joshua D. Drake" <jd@commandprompt.com>)
List pgsql-hackers
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 :)

Cheers,
David.
-- 
David Fetter <david@fetter.org> http://fetter.org/
Phone: +1 415 235 3778  AIM: dfetter666  Yahoo!: dfetter
Skype: davidfetter      XMPP: david.fetter@gmail.com

Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Common Table Expressions (WITH RECURSIVE) patch
Next
From: "Joshua D. Drake"
Date:
Subject: Re: Do we really need a 7.4.22 release now?