Re: Foreign key question

Victor Spång Arthursson wrote:
 >
 > The first is, i have a language table with a primary key on the
fields lang and relid:
 >
 > relid | lang |    text
 > -------+------+-------------
 >  11111 | uk   | hello
 >  11111 | dk   | hej
 >  11111 | de   | guten tag
 >  11112 | uk   | world
 >  11112 | dk   | værld
 >
 > In another table, texts, I have the following:
 >
 > id | text
 > -------+------+
 >  4 | 11112   |
 >
   Given what you have shown, there is no way foreign keys can work here.
   Foreign keys are links between the key values of two tables in a sort
of master/slave relationship.

 > What I want to do is to create a foreign key between the two tables.

   What problem does the concept of a foreign key solve for you?


--
jimoe at sohnen-moe dot com