Re: alter column problem - Mailing list pgsql-novice

From Michael Fuhr
Subject Re: alter column problem
Date
Msg-id 20051010160230.GA99265@winnie.fuhr.org
Whole thread Raw
In response to alter column problem  (Oleg <evdakov@iwk.uka.de>)
List pgsql-novice
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

pgsql-novice by date:

Previous
From: Tom Lane
Date:
Subject: Re: unexpected EOF on client connection errors
Next
From: Tom Lane
Date:
Subject: Re: alter column problem