On Mar 24, 2005, at 10:38 PM, Christopher Kings-Lynne wrote:
In that case there's a datatype mismatch between the referencing and referenced columns, which prevents the index from being used for the FK check.
Is creating such a foreign key a WARNING yet?
I recall getting such a warning when importing my schema from a 7.4 to 8.0 server. I had one table with char and the other with varchar.
---------------------------(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