All,
I just realized that even if you do this:
table foo (
id serial,
bar varchar(200)
)
ALTER TABLE foo ALTER COLUMN bar TYPE VARCHAR(1000)
... it triggers a heap & index rebuild, even though it's completely
unnecessary. Is this a special case of VARCHAR, or are there other
types where we should be allowing typemod changes without rebuilding?
--
Josh Berkus
PostgreSQL Experts Inc.
www.pgexperts.com