BUG #1305: can't use the type 'number' with alter table

Поиск
Список
Период
Сортировка
От PostgreSQL Bugs List
Тема BUG #1305: can't use the type 'number' with alter table
Дата
Msg-id 20041103182633.E1D67739A04@www.postgresql.com
обсуждение исходный текст
Ответы Re: BUG #1305: can't use the type 'number' with alter table  (Stephan Szabo <sszabo@megazone.bigpanda.com>)
Список pgsql-bugs
The following bug has been logged online:

Bug reference:      1305
Logged by:          Károly Segesdi

Email address:      jazzkutya@wom.hu

PostgreSQL version: 7.4.5

Operating system:   slackware 10.0

Description:        can't use the type 'number' with alter table

Details:

somedb=# alter table sometbl add column msisdn number(11);
ERROR:  syntax error at or near "(" at character 43

you can use the type identifier 'decimal' instead:
somedb=# alter table sometbl add column msisdn decimal(11);
ALTER TABLE

The documentation says theese two types are the same, but it's annoying that
you can't use the one that is mentioned more frequently in the docs.

postgresql version is 7.4.6, your bugreport form's version field misses this
version.

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Josh Berkus
Дата:
Сообщение: Re: [pgsql-bugs] Daily digest v1.1282 (5 messages)
Следующее
От: Stephan Szabo
Дата:
Сообщение: Re: BUG #1305: can't use the type 'number' with alter table