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
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
