Re: alter column problem

Поиск
Список
Период
Сортировка
Искать

Re: alter column problem

От:
Michael Fuhr <mike@fuhr.org>
Дата:
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

Re: alter column problem

От:
Tom Lane <tgl@sss.pgh.pa.us>
Дата:
Oleg  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

alter column problem

От:
Oleg <evdakov@iwk.uka.de>
Дата:
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
FAQ