Re: Smartest way to resize a column? - Mailing list pgsql-general

From Ow Mun Heng
Subject Re: Smartest way to resize a column?
Date
Msg-id 1236159616.3941.0.camel@localhost.localdomain
Whole thread Raw
In response to Re: Smartest way to resize a column?  ("Phoenix Kiula" <phoenix.kiula@gmail.com>)
List pgsql-general
On Mon, 2009-01-12 at 14:42 +0800, Phoenix Kiula wrote:
> > ALTER COLUMN TYPE is intended for cases where actual transformation of
> > the data is involved.  Obviously varchar(20) to varchar(35) doesn't
> > really require any per-row effort, but there's no operation in the
> > system that handles that case.  But if you're brave, you can do it
> > via manipulation of the system catalogs.  Observe:
>
> ...snip....
>
>
> Thanks Tom. Yes, no data change is required. But I don't think I have
> the understanding to try what you suggested. Running the alter table
> on my home database (almost same data) took an hour and it wasn't
> complete. I had even dropped the index. So I guess altering it that
> way is a pain in PGSQL. Bummer.
>

Actually, I did the same thing on a live database and it worked!

pgsql-general by date:

Previous
From: Glen Parker
Date:
Subject: Re: Unable to drop sequence due to dependency?
Next
From: Liraz Siri
Date:
Subject: New version of TurnKey PostgreSQL appliance