Syntax error while altering col-type - Mailing list pgsql-sql

From KÖPFERL Robert
Subject Syntax error while altering col-type
Date
Msg-id ED4E30DD9C43D5118DFB00508BBBA76EB16540@neptun.sonorys.at
Whole thread Raw
Responses Re: Syntax error while altering col-type
Re: Syntax error while altering col-type
List pgsql-sql
Hi, I am perplexed.

I tried to change the type of a column using the syntax I found in the
[ALTER TABLE] section:
ALTER TABLE "Mailboxes" ALTER COLUMN "Status" TYPE int4;

This shuld be no problem since the current type acutally is int4 and the
names are copy'n'pasted. The server responds as follows:

ERROR:  syntax error at or near "TYPE" at character 47

It seems like it doesn't like the "type". My compiler-experience tells me
that the column identifier is somehow broken. But it exists!

What went wrong?


pgsql-sql by date:

Previous
From: Szűcs Gábor
Date:
Subject: failed to find conversion function from "unknown" to text
Next
From: Michael Fuhr
Date:
Subject: Re: Problems with HAVING