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

Поиск
Список
Период
Сортировка
От Andrus
Тема column "id" is of type integer but expression is of type character
Дата
Msg-id 550FA46EDB07485183DEF8FAB1CC998C@andrusnotebook
обсуждение исходный текст
Ответы Re: column "id" is of type integer but expression is of type character  (Raymond O'Donnell <rod@iol.ie>)
Re: column "id" is of type integer but expression is of type character  (Alan Hodgson <ahodgson@simkin.ca>)
Re: column "id" is of type integer but expression is of type character  (Richard Huxton <dev@archonet.com>)
Список pgsql-general
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