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 985A59FA147 for ; Thu, 6 Jul 2006 09:50:50 -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 70436-02 for ; Thu, 6 Jul 2006 09:50:41 -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 152DC9FA0EC for ; Thu, 6 Jul 2006 09:50:41 -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 1FyTR2-0004wR-Fu for pgsql-sql@postgresql.org; Thu, 06 Jul 2006 08:58:24 -0400 Received: by phlogiston.dydns.org (Postfix, from userid 1000) id 5042F4172; Thu, 6 Jul 2006 08:50:35 -0400 (EDT) Date: Thu, 6 Jul 2006 08:50:35 -0400 From: Andrew Sullivan To: pgsql-sql@postgresql.org Subject: Re: Alternative to serial primary key Message-ID: <20060706125035.GD26210@phlogiston.dyndns.org> References: <12b7ac1e0607060316ub7b5e21i5e8e3bef2504e02c@mail.gmail.com> <44ACEA1C.9030804@logix-tt.com> <12b7ac1e0607060406r16d03f74mfa303eec9ab4821f@mail.gmail.com> <44ACEFBF.7030903@logix-tt.com> <20060706111223.GC26210@phlogiston.dyndns.org> <44ACF3FA.5080501@logix-tt.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <44ACF3FA.5080501@logix-tt.com> User-Agent: Mutt/1.5.9i X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200607/61 X-Sequence-Number: 25635 On Thu, Jul 06, 2006 at 01:28:58PM +0200, Markus Schaber wrote: > > Yes, risking collisions. It will work for some time, and then create a > maintainance nightmare for his successors. :-) Well, that plus you can't actually point a foreign key contraint at anything that isn't a unique contraint. A -- Andrew Sullivan | ajs@crankycanuck.ca "The year's penultimate month" is not in truth a good way of saying November. --H.W. Fowler