X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 2A4063A4327 for ; Wed, 24 Nov 2004 07:16:43 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 46993-04 for ; Wed, 24 Nov 2004 07:16:34 +0000 (GMT) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id 0AD343A4334 for ; Wed, 24 Nov 2004 07:16:32 +0000 (GMT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.1/8.13.1) with ESMTP id iAO7GFgb005060; Wed, 24 Nov 2004 02:16:15 -0500 (EST) To: Greg Stark Cc: Alexandre Leclerc , pgsql-performance@postgresql.org Subject: Re: Data type to use for primary key In-reply-to: <87hdnfwxff.fsf@stark.xeocode.com> References: <1dc7f0e30411221232603c4617@mail.gmail.com> <200411221654.56673.josh@agliodbs.com> <1dc7f0e30411230829bd1ed@mail.gmail.com> <87hdnfwxff.fsf@stark.xeocode.com> Comments: In-reply-to Greg Stark message dated "24 Nov 2004 01:52:52 -0500" Date: Wed, 24 Nov 2004 02:16:15 -0500 Message-ID: <5059.1101280575@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200411/366 X-Sequence-Number: 9320 Greg Stark writes: > This could hurt if they ever reuse an old previously retired postal code, > which isn't an entirely impossible case. As far as I know it hasn't happened > yet though. One would suppose that the guys who are in charge of this point at Canada Post consider the postal code to be their primary key, and are no more eager to reuse one than you are to see it reused. Basically this comes down to "I'm going to use some externally supplied primary key as my primary key. Do I trust the upstream DBA to know what a primary key is?" regards, tom lane