Re: BUG #2450: change the type of existing column - Mailing list pgsql-bugs

Anjali wrote:
>
> The following bug has been logged online:
>
> Bug reference:      2450
> Logged by:          Anjali
> Email address:      anjalia@cdac.in
> PostgreSQL version: 7.4.8
> Operating system:   fedora core3
> Description:        change the type of existing column
> Details:
>
> i am getting difficulty to change the type of the existing table in
> postgresql.
> is this version of postgresql supported change of data type of the existing
> column.
> plz reply me as soon as possible.

ALTER TABLE ALTER COLUMN TYPE was added in 8.0.

--
  Bruce Momjian   http://candle.pha.pa.us
  EnterpriseDB    http://www.enterprisedb.com

  + If your life is a hard drive, Christ can be your backup. +