Syntax error while altering col-type

From: KÖPFERL Robert <robert(dot)koepferl(at)sonorys(dot)at>
To: "'pgsql-sql(at)postgresql(dot)org'" <pgsql-sql(at)postgresql(dot)org>
Subject: Syntax error while altering col-type
Date: 2005-01-12 17:02:10
Message-ID: ED4E30DD9C43D5118DFB00508BBBA76EB16540@neptun.sonorys.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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?

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Michael Fuhr 2005-01-12 17:11:21 Re: Problems with HAVING
Previous Message Szűcs Gábor 2005-01-12 16:52:42 failed to find conversion function from "unknown" to text