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 6AD909FB215 for ; Fri, 7 Jul 2006 17:52:38 -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 88909-04 for ; Fri, 7 Jul 2006 17:52:26 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from ug-out-1314.google.com (ug-out-1314.google.com [66.249.92.171]) by postgresql.org (Postfix) with ESMTP id A44EA9FA612 for ; Fri, 7 Jul 2006 17:52:26 -0300 (ADT) Received: by ug-out-1314.google.com with SMTP id a2so3249952ugf for ; Fri, 07 Jul 2006 13:52:22 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=q5OWVOnf34BUZlIU2zXv1SqfF0JQw79uZjpTVt+d4HvdNOHpnGLD1SPLPqzwfYV2m66/u4KZHJUeujDDSudhcXTOw7NI5U/lGB0kW2vX7T+ucT8tFeOkCRjD13O66gg5vMcAxD+I76VTa1k+kcpk9cMs15LYlxqbfqe+RQx4yqI= Received: by 10.66.221.19 with SMTP id t19mr2439605ugg; Fri, 07 Jul 2006 13:52:22 -0700 (PDT) Received: by 10.67.23.14 with HTTP; Fri, 7 Jul 2006 13:52:22 -0700 (PDT) Message-ID: <12b7ac1e0607071352x1b82c98bx3eb8047d693b4bc0@mail.gmail.com> Date: Sat, 8 Jul 2006 08:52:22 +1200 From: "David Clarke" To: "Andrew Sullivan" Subject: Re: Alternative to serial primary key Cc: pgsql-sql@postgresql.org In-Reply-To: <20060707112113.GH26210@phlogiston.dyndns.org> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <20060706183920.46008.qmail@web33314.mail.mud.yahoo.com> <12b7ac1e0607061330o34adbd6ds9bd624d3889c7fe7@mail.gmail.com> <20060706171816.9f248316.darcy@druid.net> <20060707112113.GH26210@phlogiston.dyndns.org> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200607/120 X-Sequence-Number: 25694 On 7/7/06, 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. > Actually for my purposes it doesn't matter, I'm using a freeform address string to index a lat/long. I fully expect to have multiple unique addresses with a duplicate lat/long, i.e. the location doesn't change - only the name of it. I'm personally hoping not to be around long enough for geological events to change the physical location but living in the shaky isles anything is possible. Thanks again to all who have responded. I guess I'm probably labouring the point but it's been instructive at least. Being fairly new to database design I wanted to have enough info to be confident with my approach. Dave