Re: Cannot Create Foreign Key - Mailing list pgadmin-support

From Andreas Pflug
Subject Re: Cannot Create Foreign Key
Date
Msg-id 414EF3FE.7010407@pse-consulting.de
Whole thread Raw
In response to Re: Cannot Create Foreign Key  (Richard_D_Levine@raytheon.com)
List pgadmin-support
Richard_D_Levine@raytheon.com wrote:
> I haven't worked with PostgreSQL much at all yet, but doesn't there need to
> be a primary key constraint on the emp_address_tb's emp_id column in order
> to set up the foreign key relation between the two emp_id columns? 

Sort of, there has to be a unique index (which a pk by design is).
in a future version (1.3/1.4) we might have some autodetect mechanism 
for those columns.

Regards,
Andreas


pgadmin-support by date:

Previous
From: Richard_D_Levine@raytheon.com
Date:
Subject: Re: Cannot Create Foreign Key
Next
From: Richard_D_Levine@raytheon.com
Date:
Subject: Re: Cannot Create Foreign Key