Re: How to modify ENUM datatypes? - Mailing list pgsql-general

From Andrew Sullivan
Subject Re: How to modify ENUM datatypes?
Date
Msg-id 20080424153923.GB12111@crankycanuck.ca
Whole thread Raw
In response to Re: How to modify ENUM datatypes?  (brian <brian@zijn-digital.com>)
Responses Re: How to modify ENUM datatypes?  ("Scott Marlowe" <scott.marlowe@gmail.com>)
Re: How to modify ENUM datatypes?  ("D. Dante Lorenso" <dante@lorenso.com>)
List pgsql-general
On Wed, Apr 23, 2008 at 07:46:07PM -0400, brian wrote:
>
> Absolutely true. Which is odd, because this example is trotted out
> whenever there's a thread about ENUMs.

I don't think it's odd at all.  In my view, the people who think enums are a
good datatype for databases are exactly the sorts who'd think that their
data is as static as this poor understanding of the vagaries of individuals'
sex (gender is a different problem, given its association with social roles)
would suggest.

The world moves around in unexpected ways.  Your data model needs to
accommodate itself to the world, because the alternative is not going to
happen.

A

pgsql-general by date:

Previous
From: "Brendan Jurd"
Date:
Subject: Re: [HACKERS] I think this is a BUG?
Next
From: "Scott Marlowe"
Date:
Subject: Re: How to modify ENUM datatypes?