From: | imad <immaad(at)gmail(dot)com> |
---|---|
To: | "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | "Feng Chen" <fchen(at)covergence(dot)com>, pgsql-odbc(at)postgresql(dot)org |
Subject: | Re: Postgres Stored Procedure Call Function Return Type OID Caching Problem |
Date: | 2007-01-25 07:44:17 |
Message-ID: | 1f30b80c0701242344t1e568d28ya198044159d4865c@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Paul B. Anderson | 2007-01-25 17:23:07 | Basic connection problem |
Previous Message | noreply | 2007-01-25 03:55:47 | [ psqlodbc-Bugs-1001172 ] Problem with ADO.RecordCount |