You have to create 2 foreign keys
alter table YourTable
ALTER TABLE "YourTable" ADD CONSTRAINT "my_a_fk" FOREIGN KEY (a) REFERENCES
aaa(a) MATCH FULL;
ALTER TABLE "YourTable" ADD CONSTRAINT "my_b_fk" FOREIGN KEY (b) REFERENCES
bbb(b) MATCH FULL;
Hope this Helps
http://www.pgexplorer.com
Postgres GUI tool
----- Original Message -----
From: "Cyril Samovskiy" <cyril_s31@yahoo.com>
To: "Oliver Elphick" <pgsql-novice@postgresql.org>
Sent: Thursday, February 21, 2002 11:39 AM
Subject: Re: [NOVICE] [HACKERS] foreign key is from different tables - what
to do?
> >> hi. i'm rookie in postgres, so here is my question:
>
> OE> Therefore your question should have gone to pgsql-novice. (Reply-To
set
> OE> there.)
>
> oh, i'm sorry i didn't know that
>
> >> i have foreign key consisting of 2 fields (a and b). a is foreign key
from
> >> table aaa, b is FK from table bbb. how to create table is that complex
> >> foreign key consisiting of fields from different tables?
> >> thank you
>
> OE> You seem to have two foreign keys, not one. I'm guessing that you
> OE> actually have a multi-field primary key, each field of which is a
> OE> foreign key to another table:
>
> no my primary key is only one field, another one. actually i found how
> to make multi-FK from different tables using ALTER TABLE stuff.
> anyway thanks a lot for your support
> and sorry again for disturbing you
> bye
>
>
> -------------------
> Best regards,
> Cyril Samovskiy
> cyril_s31@yahoo.com
> cyril@somiconline.org
>
>
>
> _________________________________________________________
> Do You Yahoo!?
> Get your free @yahoo.com address at http://mail.yahoo.com
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)