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

Re: BUG #5753: Existing Functions No Longer Work

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: vince maxey <vamax27(at)yahoo(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #5753: Existing Functions No Longer Work
Date: 2010-11-13 22:13:49
Message-ID: 23279.1289686429@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-bugs
vince maxey <vamax27(at)yahoo(dot)com> writes:
> I am running my test procs from the pgAdminIII GUI. Is my syntax wrong to 
> execute the function? If I run select test_proc1(3), I do get the correct 
> result which is a column header (test_proc1 integer) and a value (2). So why 
> wouldn't I get a 6-column result set when running select test_proc(2) ?

Because those functions return the name of a cursor, not the result of
fetching from the cursor.  The same would have been true in any prior
release too, so I'm not sure why you're having trouble with 9.0 and
not before.  You sure you haven't dropped a level of indirect fetch
from your client code?

			regards, tom lane

In response to

pgsql-bugs by date

Next:From: Yeb HavingaDate: 2010-11-15 10:08:23
Subject: Re: BUG #5748: Invalid oidvector data during binary recv
Previous:From: vince maxeyDate: 2010-11-13 21:44:03
Subject: Re: BUG #5753: Existing Functions No Longer Work

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