Hi. I'm trying to increase the size of items in an array column on a large
production database but it's locking the table. Is it correct than when you
make a field larger, it shouldn't lock because it doesn't have to check the
constraint on every row? For example expanding a VARCHAR column from 255
chars to 2048 chars.
Is the problem here that it is an array field?
ALTER TABLE "msgs_msg" ALTER COLUMN "attachments" TYPE varchar(2048)[]
USING "attachments"::varchar(2048)[];
Thanks
-Rowan
--
*Rowan Seymour* | +593 979099233 | @rowanseymour