Re: [HACKERS] foreign key is from different tables - what to do? - Mailing list pgsql-novice

From Cyril Samovskiy
Subject Re: [HACKERS] foreign key is from different tables - what to do?
Date
Msg-id 86349810.20020221113922@yahoo.com
Whole thread Raw
List pgsql-novice
>> 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


pgsql-novice by date:

Previous
From: Ivan Horvath
Date:
Subject: problem in executing a function
Next
From: AarniRuuhimäki / Megative Tmi / KYMI.com
Date:
Subject: One big table or several smaller tables ?