Обсуждение: BUG #2450: change the type of existing column

Поиск
Список
Период
Сортировка

BUG #2450: change the type of existing column

От
"Anjali"
Дата:
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.

Re: BUG #2450: change the type of existing column

От
Bruce Momjian
Дата:
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. +