On Tue, Nov 16, 2010 at 5:13 PM, Kris Jurka <bo...@ejurka.com> wrote: > 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
This seems likely to be related to the OP's problem, because his code snippet does in fact show him calling getObject()... -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
