Re: foreign keys for array/period contains relationships - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Re: foreign keys for array/period contains relationships
Date
Msg-id 1288113737.22800.1.camel@vanquo.pezone.net
Whole thread Raw
In response to Re: foreign keys for array/period contains relationships  (Pavel Stehule <pavel.stehule@gmail.com>)
List pgsql-hackers
On mån, 2010-10-25 at 22:10 +0200, Pavel Stehule wrote:
> 2010/10/25 Robert Haas <robertmhaas@gmail.com>:
> >> Example #1: Foreign key side is an array, every member must match some
> >> PK.
> >>
> >> CREATE TABLE pk (a int PRIMARKY KEY, ...);
> >>
> >> CREATE TABLE fk (x int[] REFERENCES pk (a), ...);
> 
> What about optimalizations and planning?

Some work will be required to get the respective checking queries to do
the right think fast, but it's solvable in principle.




pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: xlog.c: WALInsertLock vs. WALWriteLock
Next
From: Peter Eisentraut
Date:
Subject: Re: foreign keys for array/period contains relationships