Re: BUG #5753: Existing Functions No Longer Work

On Tue, 16 Nov 2010, Korry Douglas wrote:

> Vince - is there any chance that you were using a non-standard PostgreSQL
> distribution or driver before?  Like something from EnterpriseDB?  It may be
> that a third-party JDBC driver was doing some behind-the-curtains work on
> your behalf.
>

The stock JDBC driver does have support for refcursors, so that it will do
FETCH ALL FROM it and return a ResultSet object instead of just a string
if you call getObject on a refcursor value.  This thread is too confusing
with random snippets, assertions, and differences between pgadmin, psql,
and other interfaces to tell what's really going on.  The behavior of the
JDBC driver shouldn't have changed between releases either, but this may
explain the differences seen between pgadmin and the user's application.

http://jdbc.postgresql.org/documentation/84/callproc.html#callproc-resultset-refcursor

Kris Jurka