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 CB9049FB282
	for <pgsql-sql-postgresql.org@postgresql.org>;
	Fri, 28 Jul 2006 16:28:30 -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 79395-01-2 for <pgsql-sql-postgresql.org@postgresql.org>;
	Fri, 28 Jul 2006 16:28:17 -0300 (ADT)
X-Greylist: domain auto-whitelisted by SQLgrey-
Received: from nf-out-0910.google.com (nf-out-0910.google.com
 [64.233.182.187])
	by postgresql.org (Postfix) with ESMTP id B2B7B9FB279
	for <pgsql-sql@postgresql.org>; Fri, 28 Jul 2006 16:28:16 -0300 (ADT)
Received: by nf-out-0910.google.com with SMTP id p77so283668nfc
	for <pgsql-sql@postgresql.org>; Fri, 28 Jul 2006 12:28:14 -0700 (PDT)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com;
	h=received:message-id:date:from:sender:to:subject:cc:in-reply-to:mime-version:content-type:references:x-google-sender-auth;
	b=I5ZwPOw6+LmA8c5GNHG5t+GsakwI3hXVlX0cKWwXwiTqdp29Ta+LNcvy8Ok/RoGVIwNpLLryYQ+SPYeRkGMHa4wWhIzZlDwkBWOiUaAEU1/8V5i9U2Vc+q8MAet5rCet/OU74oyxRFv+eeseHFQaDmegcRR+ACiehxOVdTbKVRw=
Received: by 10.78.117.10 with SMTP id p10mr275664huc;
	Fri, 28 Jul 2006 12:28:14 -0700 (PDT)
Received: by 10.78.32.10 with HTTP; Fri, 28 Jul 2006 12:28:14 -0700 (PDT)
Message-ID: <bf05e51c0607281228j34ca70ebi651e0070dfe04b76@mail.gmail.com>
Date: Fri, 28 Jul 2006 14:28:14 -0500
From: "Aaron Bono" <postgresql@aranya.com>
To: "Manlio Perillo" <manlio_perillo@libero.it>
Subject: Re: primary keys as TEXT
Cc: pgsql-sql@postgresql.org
In-Reply-To: <44C9CCC8.8020304@libero.it>
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_13780_2453105.1154114894594"
References: <44C9CCC8.8020304@libero.it>
X-Google-Sender-Auth: 51993a5a8591cc14
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.509 tagged_above=0 required=5 tests=AWL, HTML_40_50,
	HTML_MESSAGE, SPF_PASS
X-Spam-Level: 
X-Archive-Number: 200607/361
X-Sequence-Number: 25935

------=_Part_13780_2453105.1154114894594
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

On 7/28/06, Manlio Perillo <manlio_perillo@libero.it> wrote:
>
> Hi.
>
> There can be performancs problems in having primary keys of type TEXT?
> What about having a primary key of 3 columns (all of type TEXT)?



If you are really worried about it, why not just use surrogate keys?  They
are very easy to use.  Then your problem is solved.

==================================================================
   Aaron Bono
   Aranya Software Technologies, Inc.
   http://www.aranya.com
==================================================================

------=_Part_13780_2453105.1154114894594
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

On 7/28/06, <b class="gmail_sendername">Manlio Perillo</b> &lt;<a href="mailto:manlio_perillo@libero.it">manlio_perillo@libero.it</a>&gt; wrote:<div><span class="gmail_quote"></span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
Hi.<br><br>There can be performancs problems in having primary keys of type TEXT?<br>What about having a primary key of 3 columns (all of type TEXT)?</blockquote><div><br>&nbsp;</div>If you are really worried about it, why not just use surrogate keys?&nbsp; They are very easy to use.&nbsp; Then your problem is solved.
<br></div><br>==================================================================<br>&nbsp;&nbsp; Aaron Bono<br>&nbsp;&nbsp; Aranya Software Technologies, Inc.<br>&nbsp;&nbsp; <a href="http://www.aranya.com">http://www.aranya.com</a><br>==================================================================

------=_Part_13780_2453105.1154114894594--