Re: Cannot Create Foreign Key

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@pse-consulting.d        To:
sgbrodie@mts.net                                                                                  e>
          cc:       pgadmin-support@postgresql.org
Sentby:                         Subject:  Re: [pgadmin-support] Cannot Create Foreign Key
                    pgadmin-support-owner@pos
                                         tgresql.org


                                                                                                        09/18/2004
04:01AM


                              
 




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@postgresql.org