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