On 13.09.2011 00:33, Dermot wrote:
I have seen this feature on the todo list:
http://wiki.postgresql.org/wiki/Todo#Referential_Integrity

It's my understanding that this will allow FK constraints on array
elements, if I'm wrong, please stop me now....

You're right.

I don't want to discourage further development in the area, of course, but I think you can already accomplish that with exclusion constraints. And starting with 9.1, regular triggers can be used too, if you use serializable snapshot isolation.

--
  Heikki Linnakangas
  EnterpriseDB   http://www.enterprisedb.com

--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

Reply via email to