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 A31159FA92E for ; Fri, 7 Jul 2006 08:21:24 -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 13344-02 for ; Fri, 7 Jul 2006 08:21:20 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from main2.mycybernet.net (main2.mycybernet.net [209.222.63.140]) by postgresql.org (Postfix) with ESMTP id 7F3C69FA68D for ; Fri, 7 Jul 2006 08:21:20 -0300 (ADT) Received: from 227-54-222-209.mycybernet.net ([209.222.54.227] helo=phlogiston.dydns.org) by main2.mycybernet.net with esmtp (Exim 4.62) (envelope-from ) id 1FyoWD-00012d-UK for pgsql-sql@postgresql.org; Fri, 07 Jul 2006 07:29:10 -0400 Received: by phlogiston.dydns.org (Postfix, from userid 1000) id EAD0B3FAF; Fri, 7 Jul 2006 07:21:13 -0400 (EDT) Date: Fri, 7 Jul 2006 07:21:13 -0400 From: Andrew Sullivan To: pgsql-sql@postgresql.org Subject: Re: Alternative to serial primary key Message-ID: <20060707112113.GH26210@phlogiston.dyndns.org> References: <20060706183920.46008.qmail@web33314.mail.mud.yahoo.com> <12b7ac1e0607061330o34adbd6ds9bd624d3889c7fe7@mail.gmail.com> <20060706171816.9f248316.darcy@druid.net> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20060706171816.9f248316.darcy@druid.net> User-Agent: Mutt/1.5.9i X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200607/89 X-Sequence-Number: 25663 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. A -- Andrew Sullivan | ajs@crankycanuck.ca This work was visionary and imaginative, and goes to show that visionary and imaginative work need not end up well. --Dennis Ritchie