Re: Foreign key constraint accepted even when not same

Tom Lane wrote:
> Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com> writes:
> > On Mon, 22 Sep 2003, Jean-Christian Imbeault wrote:
> >> Is it right for postgres to accept a foreign key constraint when the
> >> type of the field is not the same as that of the foreign key?
>
> > IIRC in SQL92 it's said that they need to be the same type, but in SQL99
> > it says that the two types must be comparable. We basically implement the
> > latter, basically using the existance of a usable equality operator as the
> > determination of comparable.
>
> Note however that performance may be poor with a cross-type foreign key
> reference, if the planner is unable to figure out how to use an index
> for the check queries.

Didn't we agree to throw a NOTICE in cases of a mismatch? (I think
Peter agreed to a NOTICE but not a WARNING) Is that completed?

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073