syntax error at or near "TYPE"

eros

Error: ERROR: syntax error at or near "TYPE";
Error while executing the query (State:42601, Native Code: 7)

I am using WinSQL, Windows XP SP2 Japanese Version, PostgreSQL 8.x.
I want to alter my machi field from varchar(30) to varchar(100) TYPE.

This is my CREATE TABLE script:

Jul 26 '07 #1

michaelb

Expand|Select|Wrap|Line Numbers

1. ALTER TABLE public.postcodes  ALTER COLUMN machi  
2.                      TYPE  varchar(100);
3.  

This looks correct, but changing the column datatype was not supported in the versions prior to 8.x.
My first thought is you are running an earlier version of PostgreSQL.

Jul 30 '07 #2

eros

This looks correct, but changing the column datatype was not supported in the versions prior to 8.x.
My first thought is you are running an earlier version of PostgreSQL.

I am using PostgreSQL 7.4.1. Is there a documentation that the above scripts are not supported?.

Jul 31 '07 #3

michaelb

Of course it is all well documented.
Compare the ALTER TABLE command for 8.2 with that of 7.4 and you'll see the difference.
The commonly used work around is to add a new column, copy the values from the old one, than drop the old column

Aug 1 '07 #4