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