From: Aaron Bono <postgresql@aranya.com>
To: Manlio Perillo <manlio_perillo@libero.it>
Cc: pgsql-sql@postgresql.org
Subject: Re: primary keys as TEXT
Date: Fri, 28 Jul 2006 14:28:14 -0500
Message-ID: <bf05e51c0607281228j34ca70ebi651e0070dfe04b76@mail.gmail.com> (raw)
In-Reply-To: <44C9CCC8.8020304@libero.it>
References: <44C9CCC8.8020304@libero.it>
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
==================================================================
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: postgresql@aranya.com, manlio_perillo@libero.it
Subject: Re: primary keys as TEXT
In-Reply-To: <bf05e51c0607281228j34ca70ebi651e0070dfe04b76@mail.gmail.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