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

From: "PostgreSQL Bugs List" <pgsql-bugs(at)postgresql(dot)org>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #1305: can't use the type 'number' with alter table
Date: 2004-11-03 18:26:33
Message-ID: 20041103182633.E1D67739A04@www.postgresql.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


The following bug has been logged online:

Bug reference: 1305
Logged by: Kroly Segesdi

Email address: jazzkutya(at)wom(dot)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.

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Stephan Szabo 2004-11-03 18:50:10 Re: BUG #1305: can't use the type 'number' with alter table
Previous Message joaom 2004-11-03 17:30:11 Mensagem...postgres