Suggested TODO: allow ALTERing of typemods without heap/index rebuild

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Suggested TODO: allow ALTERing of typemods without heap/index rebuild
Date: 2009-06-01 20:26:56
Message-ID: 4A243990.9090701@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Zdenek Kotala 2009-06-01 20:27:07 Re: list_head naming conflict gcc 4.2/perl/solaris
Previous Message Kevin Grittner 2009-06-01 20:24:24 Re: User-facing aspects of serializable transactions