Re: Function return type does not match

From: Juan Francisco Diaz <j-diaz(at)publicar(dot)com>
To: Heath Tanner <heath(at)inligo(dot)com>
Cc: <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Function return type does not match
Date: 2003-09-25 19:09:39
Message-ID: BB98A7A3.C7E%j-diaz@publicar.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Thanks heat for your help but I did that and it still ives me the same
error... I restarted the srver and the computer and nothing seems to work...

Do you know any other reason for this to happen?

Thanks a lot

JuanF
El 9/25/03 12:55 PM, "Heath Tanner" <heath(at)inligo(dot)com> escribió:

> 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 Tom Lane 2003-09-25 20:10:13 Re: Calling a function within a function - plpsql
Previous Message Ron Johnson 2003-09-25 18:13:36 Re: Backing Up a Postgres database...