Re: Cannot Create Foreign Key

That makes sense.  Thanks Andreas --Rick


                                          Andreas Pflug
                                                               <pgadmin@pse-consulting.d        To:
Richard_D_Levine@raytheon.com                                                                     e>
          cc:       pgadmin-support@postgresql.org, pgadmin-support-owner@postgresql.org,
Sentby:                          sgbrodie@mts.net
                    pgadmin-support-owner@pos        Subject:  Re: [pgadmin-support] Cannot Create Foreign Key
                                         tgresql.org


                                                                                                        09/20/2004
10:15AM


                              
 




Richard_D_Levine@raytheon.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

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
              http://www.postgresql.org/docs/faqs/FAQ.html