From: Richard Huxton <dev@archonet.com>
To: Andrew Sullivan <ajs@crankycanuck.ca>
Cc: pgsql-sql@postgresql.org
Subject: Re: Alternative to serial primary key
Date: Fri, 07 Jul 2006 12:54:42 +0100
Message-ID: <44AE4B82.7090804@archonet.com> (raw)
In-Reply-To: <20060707112113.GH26210@phlogiston.dyndns.org>
References: <bf05e51c0607060902vdd8d993u470c128abf127d3d@mail.gmail.com>
<20060706183920.46008.qmail@web33314.mail.mud.yahoo.com>
<12b7ac1e0607061330o34adbd6ds9bd624d3889c7fe7@mail.gmail.com>
<20060706171816.9f248316.darcy@druid.net>
<20060707112113.GH26210@phlogiston.dyndns.org>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: dev@archonet.com, ajs@crankycanuck.ca
Subject: Re: Alternative to serial primary key
In-Reply-To: <44AE4B82.7090804@archonet.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox