Re: alter table type from double precision to real

From: ssoo(at)siliconfile(dot)com
To: Michael Fuhr <mike(at)fuhr(dot)org>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: alter table type from double precision to real
Date: 2007-06-25 07:35:52
Message-ID: 20070625163552.1npn7tlg4k44088s@mail
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Michael Fuhr <mike(at)fuhr(dot)org> wrote:
> Altering a column's type rewrites the table so vacuuming afterward
> shouldn't be necessary.

I'm gonna alter another table type from double precision to real.
This table size is lager than disk free space.
Can it be possible?
Previsouly, I saw continuous increasing in disk usage until
alter complete.
I'm afraid of disk full and aftereffects.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Gregory Stark 2007-06-25 08:23:55 Re: alter table type from double precision to real
Previous Message ssoo 2007-06-25 07:21:23 Re: alter table type from double precision to real