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.
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