Andreas Pflug wrote:
> Peter Eisentraut wrote:
>
> >I was just annoyed to find out that a foreign key doesn't check whether
> >the referenced column has a sufficiently similar data type, it only checks
> >whether an = operator exists. This masks schema design errors and typos.
> >Should this be tightened up, for example using the castability
> >characteristics between the two data types?
> >
> >
>
> Sounds like a good idea. IMHO normally only *equal* data types should be
> referenced in a good data model design, but there's probably the need
> for some relaxed check option too.
Yes, we already talked about throwing a warning if the primary/foreign
key data types are mismatched.
-- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610)
359-1001+ If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square,
Pennsylvania19073