>
>
> 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"):https://www.postgresql.org/message-id/flat/[email protected]#[email protected] 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
