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 C66019FA66C for ; Fri, 7 Jul 2006 09:16:19 -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 49121-04 for ; Fri, 7 Jul 2006 09:16:10 -0300 (ADT) X-Greylist: delayed 00:21:20.346437 by SQLgrey- Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id C9F589FAC9B for ; Fri, 7 Jul 2006 09:16:10 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.3 Received: from mail.metronet.co.uk (mail.metronet.co.uk [213.162.97.75]) by svr4.postgresql.org (Postfix) with ESMTP id 15EDC5AF064 for ; Fri, 7 Jul 2006 11:54:48 +0000 (GMT) Received: from mainbox.archonet.com (84-51-143-99.archon037.adsl.metronet.co.uk [84.51.143.99]) by smtp.metronet.co.uk (MetroNet Mail) with ESMTP id 98FFF73E36; Fri, 7 Jul 2006 12:54:43 +0100 (BST) Received: from [192.168.1.17] (client17.office.archonet.com [192.168.1.17]) by mainbox.archonet.com (Postfix) with ESMTP id 35C571DE30; Fri, 7 Jul 2006 12:54:43 +0100 (BST) Message-ID: <44AE4B82.7090804@archonet.com> Date: Fri, 07 Jul 2006 12:54:42 +0100 From: Richard Huxton User-Agent: Thunderbird 1.5.0.4 (X11/20060516) MIME-Version: 1.0 To: Andrew Sullivan Cc: pgsql-sql@postgresql.org Subject: Re: Alternative to serial primary key References: <20060706183920.46008.qmail@web33314.mail.mud.yahoo.com> <12b7ac1e0607061330o34adbd6ds9bd624d3889c7fe7@mail.gmail.com> <20060706171816.9f248316.darcy@druid.net> <20060707112113.GH26210@phlogiston.dyndns.org> In-Reply-To: <20060707112113.GH26210@phlogiston.dyndns.org> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200607/95 X-Sequence-Number: 25669 Andrew Sullivan wrote: > On Thu, Jul 06, 2006 at 05:18:16PM -0400, D'Arcy J.M. Cain wrote: >> owns/resides there in a situation where the address can never be >> changed, e.g. "521 Main" splitting into "521A Main" and "521B Main." > > And anyone who has looked at an even moderately old city map will > tell you that even this "impossible case" is by no means impossible. I seem to remember that there used to be a street in the UK that not only wasn't numbered in any apparent order, but had duplicate house-numbers too. All in a length of a few hundred yards too, so all in the same postal code. -- Richard Huxton Archonet Ltd