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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Josh Berkus <josh(at)agliodbs(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Suggested TODO: allow ALTERing of typemods without heap/index rebuild
Date: 2009-06-01 22:52:53
Message-ID: 25899.1243896773@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Josh Berkus <josh(at)agliodbs(dot)com> writes:
>> Yeah, this has been discussed before; I think it's even in the TODO
>> list.

> I couldn't find it. At least, not under data types, and also not with
> the keyword "typemod". Anyone see it?

It's the last item under ALTER:

* Don't require table rewrite on ALTER TABLE ... ALTER COLUMN TYPE, when the old and new data types are binary compatible
http://archives.postgresql.org/message-id/200903040137.n241bAUV035002@wwwmaster.postgresql.org
http://archives.postgresql.org/pgsql-patches/2006-10/msg00154.php

regards, tom lane

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Kevin Grittner 2009-06-01 23:34:36 Re: It's June 1; do you know where your release is?
Previous Message Tom Lane 2009-06-01 22:39:05 Re: Suggested TODO: allow ALTERing of typemods without heap/index rebuild