On Fri, Sep 27, 2013 at 1:37 AM, Arjen Nienhuis <a.g.nienh...@gmail.com> wrote: >> Are there any caveats of this solution and may be there is a better one? > > Why don't you just create a new ENUM with fewer values? You can use: > ALTER TABLE ... SET DATA TYPE ... USING col1::text::new_enum_type; > You might need to recreate some foreign keys.
We will have a lot of big tables with such fields and we couldn't afford downtime on the ALTERs and other things. -- Kind regards, Sergey Konoplev PostgreSQL Consultant and DBA http://www.linkedin.com/in/grayhemp +1 (415) 867-9984, +7 (901) 903-0499, +7 (988) 888-1979 gray...@gmail.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
