Thread: alter column problem

Dear All,
I am trying to change the column type:
alter table knoten_alt alter column knoten type varchar(100);
I am gettin Error message:
syntax error at or near "type" at character 44
Postgresql version 7.4.6
What am I doing wrong?
Oleg

On Mon, Oct 10, 2005 at 05:53:47PM +0200, Oleg wrote:
> I am trying to change the column type:
> alter table knoten_alt alter column knoten type varchar(100);
> I am gettin Error message:
> syntax error at or near "type" at character 44
> Postgresql version 7.4.6
> What am I doing wrong?

You're trying to use an 8.0 feature in a version that didn't have
it.  Either upgrade or use the method described in the FAQ item
"How do you change a column's data type?":

http://www.postgresql.org/docs/faqs.FAQ.html#4.3

--
Michael Fuhr

Oleg <evdakov@iwk.uka.de> writes:
> I am trying to change the column type:
> alter table knoten_alt alter column knoten type varchar(100);
> I am gettin Error message:
> syntax error at or near "type" at character 44
> Postgresql version 7.4.6

7.4 doesn't have ALTER COLUMN TYPE.  Sorry.

            regards, tom lane