Postgres Pro
Downloads
Home   >   mailing lists

Re: Using varchar primary keys. - Mailing list pgsql-general

From Jasen Betts
Subject Re: Using varchar primary keys.
Date
Msg-id 20130401062243.GA24197@gonzo
Whole thread Raw
In response to Re: Using varchar primary keys.  (Tim Uckun <timuckun@gmail.com>)
Responses Re: Using varchar primary keys.
List pgsql-general
Tree view 
On Mon, Apr 01, 2013 at 07:08:15PM +1300, Tim Uckun wrote:
> >
> > how about using an enum instead of this table?
> >
> >
> That's an interesting idea.  Are enums mutable?


since 9.1 you can add values.

  http://www.postgresql.org/docs/9.1/static/sql-altertype.html

--
⚂⚃ 100% natural

pgsql-general by date:

Previous
From: Tim Uckun
Date:
Subject: Re: Using varchar primary keys.
Next
From: Marko Kreen
Date:
Subject: Re: in C trigger function find out if column is part of primary key