Re: Pulling data from a constraint def

From: Vick Khera <vivek(at)khera(dot)org>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Pulling data from a constraint def
Date: 2010-05-14 18:07:25
Message-ID: AANLkTilhV6ofYWrbN48w21syrRxWQ_tAMvfzbSKQkz5q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, May 13, 2010 at 8:14 PM, David Fetter <david(at)fetter(dot)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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Merlin Moncure 2010-05-14 18:07:39 Re: appending items to record variable
Previous Message I. B. 2010-05-14 18:03:44 Re: Persistence problem