Re: Using varchar primary keys.

From: Jasen Betts <jasen(at)xnet(dot)co(dot)nz>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Using varchar primary keys.
Date: 2013-04-01 05:58:05
Message-ID: kjb7ld$na8$1@gonzo.reversiblemaps.ath.cx
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 2013-04-01, Tim Uckun <timuckun(at)gmail(dot)com> wrote:
> --14dae93996072d9ff304d945bd3c
> Content-Type: text/plain; charset=UTF-8
>
>>
>>
>> Natural Keys have a purpose but when do they exist in the database?
>>
>>
> In my case it's the tags. Table tags has only two columns id and tag. Each
> one has a unique index. I have many other similar lookup tables. For
> example things like order_status, item_type etc.
>

how about using an enum instead of this table?

--
⚂⚃ 100% natural

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tim Uckun 2013-04-01 06:08:15 Re: Using varchar primary keys.
Previous Message Tim Uckun 2013-04-01 05:17:36 Re: Using varchar primary keys.