That makes sense. Thanks Andreas --Rick
Andreas Pflug
<[EMAIL PROTECTED] To: [EMAIL PROTECTED]
e> cc: [EMAIL PROTECTED],
[EMAIL PROTECTED],
Sent by: [EMAIL PROTECTED]
[EMAIL PROTECTED] Subject: Re: [pgadmin-support] Cannot
Create Foreign Key
tgresql.org
09/20/2004 10:15 AM
[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 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
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
