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 19:03:46
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-bugs
"Vince Maxey" <vamax27(at)yahoo(dot)com> writes:
> Recently I upgraded a personal application built a number of years ago,
> including java, eclipse, struts and postgresql and now face an issue with
> postgresql in that application functions no longer work, specfically as
> related to refcursors.  The original application was based on postgresql 8.4
> I believe.
> ...
> But when I try to call the function: select test_proc(2); I get a column
> header: test_proc refcursor and the value in this column is simply: <unnamed
> portal n>, where n seems to indicate how many times I have run a cursor from
> the SQL window.

The example you give acts exactly as I would expect, ie, it returns the
generated name of a cursor.  And it does so in every release back to at
least 8.0, not just 9.0.  So I think you've simplified your example to
the point that it no longer demonstrates whatever problem you're
actually having.

			regards, tom lane

In response to


pgsql-bugs by date

Next:From: vince maxeyDate: 2010-11-13 21:44:03
Subject: Re: BUG #5753: Existing Functions No Longer Work
Previous:From: Vince MaxeyDate: 2010-11-13 18:50:49
Subject: BUG #5753: Existing Functions No Longer Work

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