From: Sander Steffann <s.steffann@computel.nl>
To: 'D'Arcy J.M. Cain' <darcy@druid.net>
To: 'David Clarke' <pigwin32@gmail.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: Alternative to serial primary key
Date: Fri, 7 Jul 2006 15:26:47 +0200
Message-ID: <2B1A983EDCEC3447B22632B64F72646014EB1B@bill.office.computel.nl> (raw)
In-Reply-To: <20060707073325.926f601f.darcy@druid.net>
Hi D'Arcy,
> It's not that I think that the primary key should never have
> meaning in the database (I use the two letter country code as
> the PK in my country table for example) I just think that
> it's dangerous ground and should be tread very carefully.
You are right. I now realize that I have done exactly the same thing in my
database designs :) In 95+% of the cases I would choose a serial, but this
is a good counter-example.
Thanks for making me think :)
Sander
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: s.steffann@computel.nl, darcy@druid.net, pigwin32@gmail.com
Subject: Re: Alternative to serial primary key
In-Reply-To: <2B1A983EDCEC3447B22632B64F72646014EB1B@bill.office.computel.nl>
* 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