Re: Function return type does not match

Поиск
Список
Период
Сортировка
От Heath Tanner
Тема Re: Function return type does not match
Дата
Msg-id 7FC72734-EF81-11D7-99A5-0003930C11A0@inligo.com
обсуждение исходный текст
Ответ на Function return type does not match  (Juan Francisco Diaz <j-diaz@publicar.com>)
Ответы Re: Function return type does not match  (Juan Francisco Diaz <j-diaz@publicar.com>)
Список pgsql-novice
On Thursday, September 25, 2003, at 11:55  AM, Juan Francisco Diaz
wrote:

> As i see it, the return types are the same (cabezalista) whic is a
> table in
> my database... I think something went wrong when i dropped and re
> created
> the table in order to add a column and do some other minor changes
> (like
> changing char(6) to char (7) in some columns)

Because of how functions caches database information, dropping the
table and/or columns results in an error.

You just need to re-create the function in question and all should be
fine.

-heath


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

Предыдущее
От: Gaetano Mendola
Дата:
Сообщение: Re: Function return type does not match
Следующее
От: Juan Francisco Diaz
Дата:
Сообщение: Re: Function return type does not match