Thread: How to create Foreign Keys??

How can I create a foreing key with pgadmin III. I have postgresql 7.4.3 
in a Linux Box (FC1). I see the option in the create column (new foreign 
key) window, but the referencing field does not accept any entry.

T.I.A.

Soporte U.V. wrote:
> How can I create a foreing key with pgadmin III. I have postgresql 7.4.3 
> in a Linux Box (FC1). I see the option in the create column (new foreign 
> key) window, but the referencing field does not accept any entry.

You probably didn't select a referenced table before.

Regards,
Andreas

Thanks for answering. I select the referenced table, and the referencing 
field is filled, but now the Add buttom is disabled.

TIA
Luis

Andreas Pflug wrote:

> Soporte U.V. wrote:
>
>> How can I create a foreing key with pgadmin III. I have postgresql 
>> 7.4.3 in a Linux Box (FC1). I see the option in the create column 
>> (new foreign key) window, but the referencing field does not accept 
>> any entry.
>
>
> You probably didn't select a referenced table before.
>
> Regards,
> Andreas
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>    (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>