On Thu, 2020-11-05 at 11:23 -0700, David G. Johnston wrote: > > So when i try running alter table table_name alter column column_name type INT; , it is hanging and starts providing a lock on the table. It has to rewrite the table and needs an AccessExclusive lock. You have to suspend all concurrent activity on that table. > I'm not seeing the point of doing this specific conversion at all really Exactly; this exercise is not necessary. The few bytes you are saving are not worth the trouble. Yours, Laurenz Albe -- +43-670-6056265 CYBERTEC PostgreSQL International GmbH Gröhrmühlgasse 26, A-2700 Wiener Neustadt Web: https://www.cybertec-postgresql.com
