> 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