Skip site navigation (1) Skip section navigation (2)

Re: Cannot Create Foreign Key

From: Andreas Pflug <pgadmin(at)pse-consulting(dot)de>
To: Richard_D_Levine(at)raytheon(dot)com
Cc: pgadmin-support(at)postgresql(dot)org,pgadmin-support-owner(at)postgresql(dot)org, sgbrodie(at)mts(dot)net
Subject: Re: Cannot Create Foreign Key
Date: 2004-09-20 15:15:10
Message-ID: 414EF3FE.7010407@pse-consulting.de (view raw or flat)
Thread:
Lists: pgadmin-support
Richard_D_Levine(at)raytheon(dot)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

In response to

pgadmin-support by date

Next:From: Richard_D_LevineDate: 2004-09-20 16:40:12
Subject: Re: Cannot Create Foreign Key
Previous:From: Richard_D_LevineDate: 2004-09-20 14:25:39
Subject: Re: Cannot Create Foreign Key

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group