Re: Foreign keys on array elements

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com>
Cc: Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>, Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Foreign keys on array elements
Date: 2005-04-20 14:41:46
Message-ID: 26878.1114008106@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Marc G. Fournier 2005-04-20 15:10:41 Re: HAVING <alias> ...
Previous Message Dave Held 2005-04-20 14:34:28 Re: argtype_inherit() is dead code