Re: Alternative to serial primary key - Mailing list pgsql-sql

From Sander Steffann
Subject Re: Alternative to serial primary key
Date
Msg-id 2B1A983EDCEC3447B22632B64F72646014EB1B@bill.office.computel.nl
Whole thread Raw
In response to Re: Alternative to serial primary key  ("D'Arcy J.M. Cain" <darcy@druid.net>)
List pgsql-sql
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



pgsql-sql by date:

Previous
From: Michael Glaesemann
Date:
Subject: Re: Atomar SQL Statement
Next
From: Michael Glaesemann
Date:
Subject: Re: How to get list of days between two dates?