From: Loeke <LoekeDoeLoekeDoe@dontlikespam.hotmail.com>
To: pgsql-sql@postgresql.org
Subject: Re: question : the choice of the primary key.
Date: Wed, 7 Jan 2004 15:17:55 +0100
Message-ID: <1073485069.11869@seven.kulnet.kuleuven.ac.be> (raw)
References: <1073432278.456150@seven.kulnet.kuleuven.ac.be>
> 1.many people make an extra id field and choose this id field to be the
> p-key,
> but then the same person can be present twice in the table (with different
> id fields), the id in itself has no real meaning
> 2.or u can choose the "natural" key for each person, lets say a name and
the
> birthdate of a person make that person unique, so lets make (the whole
name
> en the birthdate) the primary-key; but then if another table X wants to
> refer this table of persons using a foreign key, this foreign key exists
out
> of 3 fields, which smells redundant
i solved it for now
using a p-key (the short id)
and a a-key (the natural key),
so integrity is ok and refences are short.
>
> u have often this choice in determining the primary keys,
>
> plz give me your opinions, options i overlooked or usefull comments.
>
>
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 using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: LoekeDoeLoekeDoe@dontlikespam.hotmail.com
Subject: Re: question : the choice of the primary key.
In-Reply-To: <1073485069.11869@seven.kulnet.kuleuven.ac.be>
* 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