Re: Foreign keys on array elements - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Foreign keys on array elements
Date
Msg-id 26878.1114008106@sss.pgh.pa.us
Whole thread Raw
In response to Re: Foreign keys on array elements  (Stephan Szabo <sszabo@megazone.bigpanda.com>)
List pgsql-hackers
Stephan Szabo <sszabo@megazone.bigpanda.com> writes:
>> If not, is this a TODO perhaps?

> Maybe. It's been discussed before IIRC.  Doing the referential actions
> might get tricky, and you'd often want to index so that finding the
> individual array elements isn't expensive.

Checking PK deletions efficiently would be impossible, at least without
using index types that aren't considered mainstream yet ... I can't see
doing this until GIST is in a better state ...
        regards, tom lane


pgsql-hackers by date:

Previous
From: "Dave Held"
Date:
Subject: Re: argtype_inherit() is dead code
Next
From: "Matthew T. O'Connor"
Date:
Subject: Re: Win32 presentation