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

Popular posts from this blog

account - Script error login visual studio DefaultLogin_PCore.js -

xcode - CocoaPod Storyboard error: -