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 2FB9E9F94F3 for ; Thu, 6 Jul 2006 18:45:52 -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 02428-03 for ; Thu, 6 Jul 2006 18:45:43 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id 8C9B49FA0EC for ; Thu, 6 Jul 2006 18:45:43 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.3 Received: from mail.nederland.net (mail.nederland.net [83.137.20.15]) by svr4.postgresql.org (Postfix) with ESMTP id A71F35AF073 for ; Thu, 6 Jul 2006 21:45:42 +0000 (GMT) Received: from localhost (localhost.localdomain [127.0.0.1]) by romeo.computel.nl (Postfix) with ESMTP id C871514015; Thu, 6 Jul 2006 23:45:40 +0200 (CEST) Received: from mail.nederland.net ([127.0.0.1]) by localhost (romeo.computel.nl [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id daaIzNd8dQO7; Thu, 6 Jul 2006 23:45:35 +0200 (CEST) Received: from balefirehome (balefire.demon.nl [212.238.240.59]) by romeo.computel.nl (Postfix) with ESMTP id 48CF11403B; Thu, 6 Jul 2006 23:45:34 +0200 (CEST) Message-ID: <001b01c6a145$84e7ffd0$64c8a8c0@balefirehome> From: "Sander Steffann" To: Cc: References: <20060706183920.46008.qmail@web33314.mail.mud.yahoo.com> <12b7ac1e0607061330o34adbd6ds9bd624d3889c7fe7@mail.gmail.com> Subject: Re: Alternative to serial primary key Date: Thu, 6 Jul 2006 23:45:37 +0200 Organization: Computel Standby BV MIME-Version: 1.0 Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=response Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2900.2869 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2869 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200607/73 X-Sequence-Number: 25647 Hi, > But having a hash function over the address > column as the primary key means I can always regenerate my primary key Warning: don't attach a meaning to a primary key, as it might change - Sander