Re: Pulling data from a constraint def - Mailing list pgsql-general

From Josh Kupershmidt
Subject Re: Pulling data from a constraint def
Date
Msg-id AANLkTilL0epQ69gi6bLwaj34apauaWYyfhcWkLUnemHv@mail.gmail.com
Whole thread Raw
In response to Re: Pulling data from a constraint def  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Pulling data from a constraint def  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
On Thu, May 13, 2010 at 8:08 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Well, the inability to change the list of values is certainly an
> unpleasant limitation, but is it so fatal that we should hide the
> feature from people who could possibly use it?  I think not.

I happened upon this article relevant to the subject after googling a bit:
http://www.justatheory.com/computers/databases/postgresql/enforce-set-of-values.html

One of the comments suggests adding an entry to pg_enum to expand the
legal values of an existing ENUM type. How safe is this idea?

Josh

pgsql-general by date:

Previous
From:
Date:
Subject: Re: Unpivot / uncrosstab support?
Next
From: Tom Lane
Date:
Subject: Re: Pulling data from a constraint def