Re: Arrays and foreign keys

Chris <chrisb@nimrod.itg.telstra.com.au>

From: Chris Bitmead <chrisb@nimrod.itg.telstra.com.au>
To: Stephan Szabo <sszabo@megazone23.bigpanda.com>
Cc: pgsql-hackers@postgresql.org
Date: 2000-08-11T01:42:59Z
Lists: pgsql-hackers
Stephan Szabo wrote:

> Remember, his structure was the array referenced the integer, not the
> other way around.  So, if you say, delete one of the integers from the
> referenced table you need to find any array element that referenced that
> integer in all rows of the referencing table, that's the slow part.

Ah yes. I guess that's a problem crying out for a new indexing solution.