From: sathish <sathish@ceedees.com>
To: pgsql-jdbc@postgresql.org
Subject: doubt
Date: Fri, 11 Jun 2004 15:14:07 +0530
Message-ID: <40C97EE7.8030901@ceedees.com> (raw)
dear groups,
i have a doubt in sql,
i have a table staff_skills in which i have set a table level
constraint to create a primary key of two fields .
so 'name' and 'skill' combinedly forms a primary key.
now the issue is in another table i have only 'name' field and i want
to create a foreign key constraint which refers the staff_skills table's
'name' field only.
staff_skills (table) - name,skill,ability (columns) --- primary
key(name,skill)
staff_xxxx (table) - name,x,y,z (columns) --- foreign
key(name) references staff_skills(name).
how to do the above?
your immediate reply will be helpful
yours sincerely
SathishKumar.S
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: sathish@ceedees.com, pgsql-jdbc@postgresql.org
Subject: Re: doubt
In-Reply-To: <40C97EE7.8030901@ceedees.com>
References: <40C97EE7.8030901@ceedees.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox