Postgres Pro
Downloads
Home   >   mailing lists

Re: Alter table alter column - Mailing list pgsql-general

From Tom Lane
Subject Re: Alter table alter column
Date
Msg-id 5598.1160166256@sss.pgh.pa.us
Whole thread Raw
In response to Alter table alter column  (Marc Munro <marc@bloodnok.com>)
List pgsql-general
Tree view 
Marc Munro <marc@bloodnok.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

pgsql-general by date:

Previous
From: Casey Duncan
Date:
Subject: Re: how to get number of minutes?
Next
From: "Gregory S. Williamson"
Date:
Subject: Re: Storing images in PostgreSQL databases (again)