Terry Lee Tucker <[EMAIL PROTECTED]> writes:
> From the HTML docs:
> "The referenced columns must be the columns of a unique or primary key
> constraint in the referenced table."
> I personally don't know of a work around. Maybe some of the others do.
There is no workaround, because foreign keys don't make any sense if
there isn't a uniquely identifiable referenced row.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
