Re: ADD FOREIGN KEY (was Re: [GENERAL] 7.4Beta) - Mailing list pgsql-hackers

From Christopher Kings-Lynne
Subject Re: ADD FOREIGN KEY (was Re: [GENERAL] 7.4Beta)
Date
Msg-id 3F78E44F.4020206@familyhealth.com.au
Whole thread Raw
In response to Re: ADD FOREIGN KEY (was Re: [GENERAL] 7.4Beta)  (Shridhar Daithankar <shridhar_daithankar@persistent.co.in>)
List pgsql-hackers
> 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




pgsql-hackers by date:

Previous
From: Jan Wieck
Date:
Subject: Re: ADD FOREIGN KEY (was Re: [GENERAL] 7.4Beta)
Next
From: Bruce Momjian
Date:
Subject: Re: ADD FOREIGN KEY (was Re: [GENERAL] 7.4Beta)