Postgres Pro
Downloads
Home   >   mailing lists

Re: primary keys as TEXT - Mailing list pgsql-sql

From Aaron Bono
Subject Re: primary keys as TEXT
Date
Msg-id bf05e51c0607281228j34ca70ebi651e0070dfe04b76@mail.gmail.com
Whole thread Raw
In response to primary keys as TEXT  (Manlio Perillo <manlio_perillo@libero.it>)
List pgsql-sql
Tree view
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
==================================================================

pgsql-sql by date:

Previous
From: "Aaron Bono"
Date:
Subject: Re: Storing an ordered list
Next
From: Scott Marlowe
Date:
Subject: Re: primary keys as TEXT