Correct me if I am wrong but I remember postgresql throwing error that foreign key field was not unique in foreign table. Obviously it can not detect that without an index. Either primary key or unique constraint would need an index.

What am I missing here?


IOW, how do I exactly create foreign keys without an index?

You are taling about the primary key or the referenced key, not the foreign key. (eg. the source column)


Chris



---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Reply via email to