Re: Problem with Altering a table column

Douglas Reed <dougreed765@yahoo.com> writes:
> I have issued and alter column against the following;
>  price_id         | integer                     | not null default nextval('bet.price_price_id_seq'::regclass) |
plain  |              | 
> ALTER TABLE bet.price ALTER COLUMN price_id TYPE bigint;

> The process has taken a very long time, I know that it is rebuilding the table and a lot of temp files have been
created,deleted etc 
> It now seems to have gone quiet (no temp disk files etc), it still seems to be clicking up CPU
> - Is there a final part of the process where it may just be doing validation etc?

Foreign key revalidation maybe ... does this column participate in any
foreign keys?

> - Is it safe to terminate the process?

Yeah, but you'd lose all the work done so far.

            regards, tom lane