Re: Function return type does not match - Mailing list pgsql-novice

From Heath Tanner
Subject Re: Function return type does not match
Date
Msg-id 7FC72734-EF81-11D7-99A5-0003930C11A0@inligo.com
Whole thread Raw
In response to Function return type does not match  (Juan Francisco Diaz <j-diaz@publicar.com>)
Responses Re: Function return type does not match
List 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 by date:

Previous
From: Gaetano Mendola
Date:
Subject: Re: Function return type does not match
Next
From: Juan Francisco Diaz
Date:
Subject: Re: Function return type does not match