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 -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
