Re: Postgres Stored Procedure Call Function Return Type OID Caching Problem

[imad <immaad(at)gmail(dot)com>]

On 1/25/07, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

"Feng Chen" <fchen(at)covergence(dot)com> writes:
> The problem is that I should not have to and cannot re-load the
> functions every now and then. Why would the type id change and the
> function still references to the old type id thus fails to get the right
> results?

I suspect the problem
is not with the return type at all, but with some table or other type
referenced within the function body.

Although pg_depend handles the dependency of return types of the functions but the weird thing is that his pg_proc entries show invalid type OID for return type. Something wrong with his PG instance probably.

--Imad
www.EnterpriseDB.com