Re: [BUGS] BUG #1305: can't use the type 'number' with alter table

2004-11-07 Thread Segesdi Károly
Stephan Szabo wrote: On Wed, 3 Nov 2004, PostgreSQL Bugs List wrote: 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

Re: [BUGS] BUG #1305: can't use the type 'number' with alter table

2004-11-03 Thread Stephan Szabo
On Wed, 3 Nov 2004, PostgreSQL Bugs List wrote: > > The following bug has been logged online: > > Bug reference: 1305 > Logged by: Károly Segesdi > > Email address: [EMAIL PROTECTED] > > PostgreSQL version: 7.4.5 > > Operating system: slackware 10.0 > > Description:ca

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

2004-11-03 Thread PostgreSQL Bugs List
The following bug has been logged online: Bug reference: 1305 Logged by: Károly Segesdi Email address: [EMAIL PROTECTED] PostgreSQL version: 7.4.5 Operating system: slackware 10.0 Description:can't use the type 'number' with alter table Details: somedb=# alter