Re: [PATCH] Support for foreign keys with arrays

Noah Misch <noah@leadboat.com>

From: Noah Misch <noah@leadboat.com>

To: Tom Lane <tgl@sss.pgh.pa.us>

Cc: Gabriele Bartolini <gabriele.bartolini@2ndQuadrant.it>, PostgreSQL-development <pgsql-hackers@postgresql.org>, Marco Nenciarini <marco.nenciarini@2ndQuadrant.it>

Date: 2011-12-12T00:46:17Z

Lists: pgsql-hackers

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

Allow LEAKPROOF functions for better performance of security views.
- cd30728fb2ed 9.2.0 cited
Improve labeling of pg_test_fsync open_sync test output.
- 2bbd88f8f841 9.2.0 cited

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