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
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
