Re: Foreign key data type mismatches

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.

Regards,
Andreas