On Tue, Sep 13, 2011 at 08:24:15AM +0300, Heikki Linnakangas wrote: > 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.
Unless there's something really clever whereby you would use the same syntax in the DDL that you would for non-array FKs, there's still work to be done, possibly via a wrapper around the things you mentioned. Cheers, David. -- David Fetter <da...@fetter.org> http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@gmail.com iCal: webcal://www.tripit.com/feed/ical/people/david74/tripit.ics Remember to vote! Consider donating to Postgres: http://www.postgresql.org/about/donate -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers