Re: [pgadmin-support] Cannot Create Foreign Key

2004-09-20 Thread Richard_D_Levine
TECTED], Sent by: [EMAIL PROTECTED] [EMAIL PROTECTED]Subject: Re: [pgadmin-support] Cannot Create Foreign Key tgres

Re: [pgadmin-support] Cannot Create Foreign Key

2004-09-20 Thread Andreas Pflug
[EMAIL PROTECTED] 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

Re: [pgadmin-support] Cannot Create Foreign Key

2004-09-20 Thread Richard_D_Levine
[EMAIL PROTECTED] e> cc: [EMAIL PROTECTED] Sent by: Subject: Re: [pgadmin-su

Re: [pgadmin-support] Cannot Create Foreign Key

2004-09-18 Thread Andreas Pflug
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

[pgadmin-support] Cannot Create Foreign Key

2004-09-17 Thread Shane G. Brodie
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 p