Re: [PATCH] Support for foreign keys with arrays - Mailing list pgsql-hackers

From Noah Misch
Subject Re: [PATCH] Support for foreign keys with arrays
Date
Msg-id 20111212004617.GC10399@tornado.leadboat.com
Whole thread Raw
In response to Re: [PATCH] Support for foreign keys with arrays  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
On Thu, Nov 17, 2011 at 12:08:32AM -0500, Tom Lane wrote:
> The least we could do is invent some non-spec syntax that makes the
> intention clear, rather than having the system assume that an error case
> was intended to mean something else.  Maybe
> 
>     pids INTEGER[] ARRAY REFERENCES pt,

+1.  Perhaps this for the table_constraint syntax:
FOREIGN KEY (ARRAY foo, bar, ARRAY pids) REFERENCES pt


pgsql-hackers by date:

Previous
From: Noah Misch
Date:
Subject: Re: [PATCH] Support for foreign keys with arrays
Next
From: Robert Haas
Date:
Subject: Re: Why do regression tests now leave "regress_test_role_super" around?