I tried to reproduce it with DDL but no luck. I even tried to backup with the state before crash and then restore but there wasn't error in such case too.
I`m using windows, so i cant really follow your instruction for taking dump.
I guess the easiest would be to recreate it via that python .
> I just checked with that statement and pgadmin and it still crash the db. > Its not related to my pc, since i initially encountered it on CI with > totally different os and setup, and then reproduced it locally. > https://i.imgur.com/qn1cyOz.png here what happen if i execute that alter > query in pgadmin
It probably depends on other things in the table -- maybe indexes, or foreign keys, or something else. If you can reproduce in psql or pgadmin starting from an empty database and some DDL, please submit that.