Re: Foreign key type checking patch - Mailing list pgsql-patches

From Tom Lane
Subject Re: Foreign key type checking patch
Date
Msg-id 296.1078160047@sss.pgh.pa.us
Whole thread Raw
In response to Foreign key type checking patch  (Fabien COELHO <coelho@cri.ensmp.fr>)
Responses Re: Foreign key type checking patch
List pgsql-patches
Fabien COELHO <coelho@cri.ensmp.fr> writes:
> Here is a proposed patch against 7.4.1 to check exact match
> of foreign key types wrt the referenced keys, and to show
> a warning if this is not the case.

I think that this concern may be obsolete in CVS tip, at least for the
cases where we have indexable cross-type operators.  The correct way
to do this would be to look at the operator found by oper() and see
whether it's indexable.

            regards, tom lane

pgsql-patches by date:

Previous
From: Fabien COELHO
Date:
Subject: Foreign key type checking patch
Next
From: Fabien COELHO
Date:
Subject: Re: Foreign key type checking patch