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
>
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... |