From: Bruno Wolff III <bruno@wolff.to>
To: sathish <sathish@ceedees.com>
Cc: pgsql-jdbc@postgresql.org
Subject: Re: [ADMIN] doubt
Date: Mon, 14 Jun 2004 10:22:02 -0500
Message-ID: <20040614152202.GA8883@wolff.to> (raw)
In-Reply-To: <40C97EE7.8030901@ceedees.com>
References: <40C97EE7.8030901@ceedees.com>
On Fri, Jun 11, 2004 at 15:14:07 +0530,
sathish <sathish@ceedees.com> wrote:
> 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.
No. References need to be to keys (columns with a unique index on just
the columns being referenced).
In this case you almost certainly what to have the name table separate
from the skill table and have both the skill table and the other table
refer to the name table.
> 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: bruno@wolff.to, sathish@ceedees.com, pgsql-jdbc@postgresql.org
Subject: Re: [ADMIN] doubt
In-Reply-To: <20040614152202.GA8883@wolff.to>
References: <40C97EE7.8030901@ceedees.com> <20040614152202.GA8883@wolff.to>
* 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