Re: [GENERAL] Modifying ENUM Type

2009-05-30 Thread Merlin Moncure
On Sat, May 30, 2009 at 3:55 AM, APseudoUtopia wrote: > Hey, > > I created an ENUM type. However, I accidentally typoed in one of the > enum values. It is "apps" and it should be "app". What's the best way > to modify this without dropping the type? I have many tables which > have columns that dep

[GENERAL] Modifying ENUM Type

2009-05-30 Thread APseudoUtopia
Hey, I created an ENUM type. However, I accidentally typoed in one of the enum values. It is "apps" and it should be "app". What's the best way to modify this without dropping the type? I have many tables which have columns that depend on the type, and I'm trying to avoid having to recreate all th