Postgres Pro
Downloads
Home   >   mailing lists

Re: Array of foreign key - Mailing list pgsql-general

From Ken Tanzer
Subject Re: Array of foreign key
Date
Msg-id CAD3a31VzLD9oTf4fewSh2-gHW=cQB7D55KUxTkC1UVKdY274OQ@mail.gmail.com
Whole thread Raw
In response to Re: Array of foreign key  (Melvin Davidson <melvin6925@gmail.com>)
Responses Re: Array of foreign key
List pgsql-general
Tree view

I don't think you understand how Foreign Key constraints work in PostgreSQL.
PostgreSQL will prevent any insert where the value of a column is not within the FK table.
So you DO NOT need a check constraint or trigger.


I thought the OP was asking for this feature ("Support for Array ELEMENT Foreign Keys"):


which would be super-handy, but doesn't actually exist.  You can enforce it yourself with a trigger on both tables, but I still hope this someday gets included into Postgres!

Ken

pgsql-general by date:

Previous
From: Melvin Davidson
Date:
Subject: Re: Array of foreign key
Next
From: Jeremy Finzel
Date:
Subject: Re: Deadlock between concurrent index builds on different tables