Re: What is the good equivalent for ENUM ? - Mailing list pgsql-general

From Ron Johnson
Subject Re: What is the good equivalent for ENUM ?
Date
Msg-id 1062633477.7340.439.camel@haggis
Whole thread Raw
In response to Re: What is the good equivalent for ENUM ?  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-general
On Wed, 2003-09-03 at 18:05, Bruce Momjian wrote:
> Ron Johnson wrote:
> > On Wed, 2003-09-03 at 09:50, Vivek Khera wrote:
> > > >>>>> "SD" == Shridhar Daithankar <shridhar_daithankar@persistent.co.in> writes:
> > >
> > > SD> On 3 Sep 2003 at 14:30, Bruno BAGUETTE wrote:
> > > >> The problem is that this MySQL database uses ENUM, do you see what can I
> > > >> do to migrate ENUM into PostgreSQL ?
> > >
> > > SD> varchar with check constraints. Add constraits to allow only
> > > SD> certain values of varchar string.
> > >
> > > I used to do this.  It turns out to be horribly inflexible when you
> > > need to alter the enum values since the constraints cannot easily be
> > > changed.
> >
> > It'll be better when domains have alterable constraints.  Your
> > way is the traditional (and best, IMO) way, though.
>
> In 7.4 we have:
>
>     Add DOMAIN CHECK constraints (Rod)
>     Add ALTER DOMAIN .. SET / DROP NOT NULL, SET / DROP DEFAULT, ADD / DROP
>       CONSTRAINT (Rod)

"Rod"??

--
-----------------------------------------------------------------
Ron Johnson, Jr. ron.l.johnson@cox.net
Jefferson, LA USA

Regarding war zones: "There's nothing sacrosanct about a hotel
with a bunch of journalists in it."
Marine Lt. Gen. Bernard E. Trainor (Retired)


pgsql-general by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Localization (for dates) Oracle vs. Postgresql
Next
From: darren@crystalballinc.com
Date:
Subject: Re: TCL trigger doesn't work after deleting a column