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

From Vick Khera
Subject Re: Pulling data from a constraint def
Date
Msg-id AANLkTilhV6ofYWrbN48w21syrRxWQ_tAMvfzbSKQkz5q@mail.gmail.com
Whole thread Raw
In response to Re: Pulling data from a constraint def  (David Fetter <david@fetter.org>)
List pgsql-general
On Thu, May 13, 2010 at 8:14 PM, David Fetter <david@fetter.org> 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.
>
> It's enough of a foot-gun that I would not even mention it to start
> with, except to discuss its problems.
>
>

I'm with David on this one.  I always define them using an enumeration
table + FK to that table.

pgsql-general by date:

Previous
From: "Igor Neyman"
Date:
Subject: Re: PANIC: corrupted item pointer: 32766
Next
From: Merlin Moncure
Date:
Subject: Re: appending items to record variable