Re: Arrays and foreign keys - Mailing list pgsql-hackers

From Chris Bitmead
Subject Re: Arrays and foreign keys
Date
Msg-id 39935A23.EC361C08@nimrod.itg.telecom.com.au
Whole thread Raw
In response to Re: Arrays and foreign keys  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
Responses Re: Arrays and foreign keys
List 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.


pgsql-hackers by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: Arrays and foreign keys
Next
From: hstenger@adinet.com.uy
Date:
Subject: Re: AW: Now PostgreSQL recovers from errors within trns