Syntax error while altering col-type

Поиск
Список
Период
Сортировка
От KÖPFERL Robert
Тема Syntax error while altering col-type
Дата
Msg-id ED4E30DD9C43D5118DFB00508BBBA76EB16540@neptun.sonorys.at
обсуждение исходный текст
Ответы Re: Syntax error while altering col-type  (Michael Fuhr <mike@fuhr.org>)
Re: Syntax error while altering col-type  (Rosser Schwarz <rosser.schwarz@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Szűcs Gábor
Дата:
Сообщение: failed to find conversion function from "unknown" to text
Следующее
От: Michael Fuhr
Дата:
Сообщение: Re: Problems with HAVING