Re: Foreign keys for non-default datatypes

Tom Lane <tgl@sss.pgh.pa.us>

From: Tom Lane <tgl@sss.pgh.pa.us>

To: Christopher Kings-Lynne <chriskl@familyhealth.com.au>

Cc: Alvaro Herrera <alvherre@commandprompt.com>, pgsql-hackers@postgresql.org, CG <cgg007@yahoo.com>, Stephan Szabo <sszabo@megazone.bigpanda.com>

Date: 2006-02-24T04:00:48Z

Lists: pgsql-hackers

Christopher Kings-Lynne <chriskl@familyhealth.com.au> writes:
> Incidentally, shouldn't the existing RI queries (eg. SELECT ... FOR 
> SHARE) explicity specify operator(pg_catalog.=)?

Then they'd be guaranteed to fail for datatypes/operators created in
other schemas, rather than only at risk of failing.  Don't see that
as an improvement really.  I think we should fix it properly for 8.2
but not institute any half-measures beforehand.

			regards, tom lane