database - Postgresql: ERROR: cannot cast type <custom_enumeration> to <custom_enumeration2> -
i have 2 types declared in postgresql database. change order of enumeration, doesn't allow me. in case create new enumeration type , try change type of column error: error: cannot cast type "<custom_enumeration>" <custom_enumeration2>
.
the command alter column is:
alter table public.funky alter column bajinga type <custom_enumeration2> using (bajinga::<custom_enumeration2>);
which best practice match types?
posgresql v9.6
Comments
Post a Comment