Re: [SQL] problem referencing an attrib which is not unique

Thanks a lot Patrick and Richard for the help! Especially about the details that I hadnt even asked for, like 2 chars for language and I guess it makes very much sense in considering these for situations like EN-US or EN-UK. It was really insightful. On 2/7/06, Patrick JACQUOT <[EMAIL PROTECTED]> w

Re: [SQL] problem referencing an attrib which is not unique

Vic Rowan wrote: -- Forwarded message -- From: *Vic Rowan* <[EMAIL PROTECTED] > Date: Feb 7, 2006 2:31 PM Subject: problem referencing an attrib which is not unique To: pgsql-sql@postgresql.org hello everybody, I ne

Re: [SQL] problem referencing an attrib which is not unique

Vic Rowan wrote: CREATE TABLE event_msg ( event_id varchar(30) NOT NULL, language char(2) NOT NULL, predefined_msg varchar(250) NOT NULL, PRIMARY KEY (event_id, language) ); CREATE TABLE logs ( id int NOT NULL, event_id varchar(30) REFERENCES event_msg (event_id) NOT NULL, placehol

[SQL] problem referencing an attrib which is not unique

-- Forwarded message --From: Vic Rowan <[EMAIL PROTECTED]>Date: Feb 7, 2006 2:31 PM Subject: problem referencing an attrib which is not uniqueTo: pgsql-sql@postgresql.orghello everybody,I need some thing like this below for an application which stores log messages in multiple langua