X-Original-To: pgsql-sql-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 894939FB1B7 for ; Fri, 7 Jul 2006 10:27:11 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 60337-06 for ; Fri, 7 Jul 2006 10:27:07 -0300 (ADT) X-Greylist: delayed 15:41:31.285248 by SQLgrey- Received: from mail.nederland.net (mail.nederland.net [83.137.20.15]) by postgresql.org (Postfix) with ESMTP id ACF0D9FB1CB for ; Fri, 7 Jul 2006 10:27:07 -0300 (ADT) Received: from localhost (localhost.localdomain [127.0.0.1]) by romeo.computel.nl (Postfix) with ESMTP id 4CCD914123; Fri, 7 Jul 2006 15:27:05 +0200 (CEST) Received: from mail.nederland.net ([127.0.0.1]) by localhost (romeo.computel.nl [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id Qz7HW3POJMMb; Fri, 7 Jul 2006 15:26:50 +0200 (CEST) Received: from pcsast (dsl224-250-100.fastxdsl.nl [80.100.250.224]) by romeo.computel.nl (Postfix) with ESMTP id CE8AC1410E; Fri, 7 Jul 2006 15:26:47 +0200 (CEST) From: "Sander Steffann" To: "'D'Arcy J.M. Cain'" , "'David Clarke'" Cc: Subject: Re: Alternative to serial primary key Date: Fri, 7 Jul 2006 15:26:47 +0200 Organization: Computel | Nederland.net Message-ID: <2B1A983EDCEC3447B22632B64F72646014EB1B@bill.office.computel.nl> MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook, Build 10.0.6626 Importance: Normal In-Reply-To: <20060707073325.926f601f.darcy@druid.net> X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2869 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200607/97 X-Sequence-Number: 25671 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