Modifying ENUM Type - Mailing list pgsql-general

From APseudoUtopia
Subject Modifying ENUM Type
Date
Msg-id 27ade5280905300055r20bbf1daybed6f22df2cc7f17@mail.gmail.com
Whole thread Raw
Responses Re: Modifying ENUM Type
List pgsql-general
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 those tables again (which would be the case if I have
to drop the type).

Can I just edit the pg_enum table manually? Will this mess anything up?

Thanks.

pgsql-general by date:

Previous
From: Scott Bailey
Date:
Subject: Re: Switching databases over JDBC/ODBC
Next
From: Stefan Kaltenbrunner
Date:
Subject: Re: Switching databases over JDBC/ODBC