Re: Alter table alter column

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Marc Munro <marc(at)bloodnok(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Alter table alter column
Date: 2006-10-06 20:24:16
Message-ID: 5598.1160166256@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Marc Munro <marc(at)bloodnok(dot)com> writes:
> Am I right in thinking that altering a column from varchar(n) to
> varchar(n+m) requires each tuple to be visited?

Yes. Doing otherwise would require an unreasonable amount of
data-type-specific knowledge hardwired into ALTER COLUMN TYPE.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Gregory S. Williamson 2006-10-06 20:57:17 Re: Storing images in PostgreSQL databases (again)
Previous Message Casey Duncan 2006-10-06 20:16:55 Re: how to get number of minutes?