| From: | "Aaron Bono" <postgresql(at)aranya(dot)com> |
|---|---|
| To: | "Manlio Perillo" <manlio_perillo(at)libero(dot)it> |
| Cc: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: primary keys as TEXT |
| Date: | 2006-07-28 19:28:14 |
| Message-ID: | bf05e51c0607281228j34ca70ebi651e0070dfe04b76@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
On 7/28/06, Manlio Perillo <manlio_perillo(at)libero(dot)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
==================================================================
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Scott Marlowe | 2006-07-28 19:34:34 | Re: primary keys as TEXT |
| Previous Message | Aaron Bono | 2006-07-28 19:06:21 | Re: Storing an ordered list |