Re: [GENERAL] Alter table alter column

2006-10-06 Thread Tom Lane
Marc Munro <[EMAIL PROTECTED]> 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.

[GENERAL] Alter table alter column

2006-10-06 Thread Marc Munro
Am I right in thinking that altering a column from varchar(n) to varchar(n+m) requires each tuple to be visited? Recent experience suggests this is the case but my reading of the docs has left me uncertain why this should be so. We are not changing the fundamental type of the column, nor are we a