Thread: Array element foreign keys

Array element foreign keys

From
Emrul
Date:
Hi,

I know a while ago someone posted a patch to support this:
http://blog.2ndquadrant.com/postgresql-9-3-development-array-element-foreign-keys/
but it seems that it has not made it as of 9.5.

Is anyone aware of why it wasn't already included / if it is planned for it
to be in a (near) future release?





--
View this message in context: http://postgresql.nabble.com/Array-element-foreign-keys-tp5918837.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.


Re: Array element foreign keys

From
Tom Lane
Date:
Emrul <emrul@emrul.com> writes:
> I know a while ago someone posted a patch to support this:
> http://blog.2ndquadrant.com/postgresql-9-3-development-array-element-foreign-keys/
> but it seems that it has not made it as of 9.5.

> Is anyone aware of why it wasn't already included / if it is planned for it
> to be in a (near) future release?

According to the thread at
https://www.postgresql.org/message-id/flat/1343842863.5162.4.camel%40greygoo.devise-it.lan
it was bounced back for rework because of serious semantic and performance
deficiencies.  Since that was four years ago and nothing new has been
submitted, I wouldn't hold my breath.

            regards, tom lane