From: | David Fetter <david(at)fetter(dot)org> |
---|---|
To: | Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com> |
Cc: | Dermot <paikkos(at)googlemail(dot)com>, pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: Sponsored development |
Date: | 2011-09-14 14:12:55 |
Message-ID: | 20110914141255.GA8425@fetter.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
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 <david(at)fetter(dot)org> http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david(dot)fetter(at)gmail(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Joshua D. Drake | 2011-09-14 14:14:10 | Re: What Would You Like To Do? |
Previous Message | Hannu Krosing | 2011-09-14 12:40:09 | Re: What Would You Like To Do? |