column "id" is of type integer but expression is of type character

Поиск
Список
Период
Сортировка
Commands:

create temp table test ( id int, baas char(10) );
create temp table lisa ( id int, baas char(10) );
alter table lisa drop column id;
INSERT INTO test SELECT * FROM lisa;
drop table lisa;

Cause error

ERROR:  column "id" is of type integer but expression is of type character
HINT:  You will need to rewrite or cast the expression.

********** Error **********

ERROR: column "id" is of type integer but expression is of type character
SQL state: 42804
Hint: You will need to rewrite or cast the expression.

How to fix ?

Andrus.

В списке pgsql-general по дате отправления:

Предыдущее
От: "Dan Armbrust"
Дата:
Сообщение: Re: Slow Vacuum was: vacuum output question
Следующее
От: Raymond O'Donnell
Дата:
Сообщение: Re: column "id" is of type integer but expression is of type character