Skip site navigation (1) Skip section navigation (2)

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

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 (view raw or flat)
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

In response to

pgsql-odbc by date

Next:From: Paul B. AndersonDate: 2007-01-25 17:23:07
Subject: Basic connection problem
Previous:From: noreplyDate: 2007-01-25 03:55:47
Subject: [ psqlodbc-Bugs-1001172 ] Problem with ADO.RecordCount

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group