Re: [pgadmin-support] Cannot Create Foreign Key

2004-09-20 Thread Richard_D_Levine
That makes sense. Thanks Andreas --Rick Andreas Pflug

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
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