Re: [HACKERS] Foreign keys on array elements

2005-04-20 Thread Tom Lane
Stephan Szabo <[EMAIL PROTECTED]> writes: >> If not, is this a TODO perhaps? > Maybe. It's been discussed before IIRC. Doing the referential actions > might get tricky, and you'd often want to index so that finding the > individual array elements isn't expensive. Checking PK deletions efficientl

Re: [HACKERS] Foreign keys on array elements

2005-04-20 Thread Stephan Szabo
On Wed, 20 Apr 2005, Christopher Kings-Lynne wrote: > Hi, > > Can you put a foreign key constraint on an array column that says that > each element of the array must match a primary key? Not currently, because foreign keys are between directly comparable things. > If not, is this a TODO perhaps?

Re: [HACKERS] Foreign keys on array elements

2005-04-20 Thread Pavel Stehule
> Hi, > > Can you put a foreign key constraint on an array column that says that > each element of the array must match a primary key? > > If not, is this a TODO perhaps? > > Chris > Hello, Using array values for foreign key is very special. I not sure, so all people need it. More interest

[HACKERS] Foreign keys on array elements

2005-04-19 Thread Christopher Kings-Lynne
Hi, Can you put a foreign key constraint on an array column that says that each element of the array must match a primary key? If not, is this a TODO perhaps? Chris ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? ht