Re: Arrays and foreign keys

From: Chris Bitmead <chrisb(at)nimrod(dot)itg(dot)telstra(dot)com(dot)au>
To: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Arrays and foreign keys
Date: 2000-08-11 01:42:59
Message-ID: 39935A23.EC361C08@nimrod.itg.telecom.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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.

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message hstenger 2000-08-11 02:00:40 Re: AW: Now PostgreSQL recovers from errors within trns
Previous Message Stephan Szabo 2000-08-11 01:33:43 Re: Arrays and foreign keys