foreign key is from different tables - what to do?

From: "Cyril Samovskiy" <cyril_s31(at)yahoo(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: foreign key is from different tables - what to do?
Date: 2002-02-20 18:23:27
Message-ID: a50pag$goh$1@news.lucky.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-novice

hi. i'm rookie in postgres, so here is my question:
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

-------------------
Best regards,
Cyril Samovskiy
cyril_s31(at)yahoo(dot)com
cyril(at)somiconline(dot)org

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Jan Wieck 2002-02-20 18:39:41 Re: PL/pgSQL RENAME bug?
Previous Message Stephan Szabo 2002-02-20 17:28:03 Foreign Key work for 7.3+

Browse pgsql-novice by date

  From Date Subject
Next Message Stephen Ingram 2002-02-20 20:03:13 Question about restricting the number of rows returned from a query.
Previous Message Pam Wampler 2002-02-20 15:30:06 Re: inserting a timestamp show wrong timezone