Postgres Pro
Downloads
Home   >   mailing lists

Re: Foreign keys for non-default datatypes - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Foreign keys for non-default datatypes
Date
Msg-id 28738.1140753648@sss.pgh.pa.us
Whole thread Raw
In response to Re: Foreign keys for non-default datatypes  (Christopher Kings-Lynne <chriskl@familyhealth.com.au>)
List pgsql-hackers
Tree view 
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

pgsql-hackers by date:

Previous
From: Michael Glaesemann
Date:
Subject: Re: PostgreSQL unit tests
Next
From: Gavin Sherry
Date:
Subject: Re: PostgreSQL unit tests