Re: Function return type does not match

From: Heath Tanner <heath(at)inligo(dot)com>
To: Juan Francisco Diaz <j-diaz(at)publicar(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Function return type does not match
Date: 2003-09-25 17:55:50
Message-ID: 7FC72734-EF81-11D7-99A5-0003930C11A0@inligo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Ron Johnson 2003-09-25 18:13:36 Re: Backing Up a Postgres database...
Previous Message Gaetano Mendola 2003-09-25 17:54:42 Re: Function return type does not match