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