On Fri, Sep 27, 2013 at 1:37 AM, Arjen Nienhuis <a.g.nienhuis@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.ru@gmail.com