From: | Richard_D_Levine(at)raytheon(dot)com |
---|---|
To: | Andreas Pflug <pgadmin(at)pse-consulting(dot)de> |
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 14:25:39 |
Message-ID: | OF8CEB7A0F.D4E05E93-ON05256F15.004EF776@ftw.us.ray.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
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? --Rick
Andreas Pflug
<pgadmin(at)pse-consulting(dot)d To: sgbrodie(at)mts(dot)net
e> cc: pgadmin-support(at)postgresql(dot)org
Sent by: Subject: Re: [pgadmin-support] Cannot Create Foreign Key
pgadmin-support-owner(at)pos
tgresql.org
09/18/2004 04:01 AM
Shane G. Brodie wrote:
> App: pgAdminIII V1.2.0 Post Beta 1 (Sept 17 2004)
> DB: PostgreSQL 7.4.2
> O/S: Fedora Core 2
> Kernel: 2.6.8-1.521
>
> Cannot add a foreign key to a table using the gui provided by the "New
> Object" ... "Foreign Key" dialog. The dialog appears complete and I
> have filled out all of the requisite parts of the dialog. On the
> "Columns" tab, the two related columns are selected, but the "Add"
> button remains grayed out.
If you change a column, Add is enabled.
I committed a change to CVS which hopefully fixes this issue.
Regards,
Andreas
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org
From | Date | Subject | |
---|---|---|---|
Next Message | Andreas Pflug | 2004-09-20 15:15:10 | Re: Cannot Create Foreign Key |
Previous Message | Andreas Pflug | 2004-09-18 09:03:28 | Re: pgadmin with error to run |