On 1/10/18 13:53, Vladimir Sitnikov wrote: >> committed > > I'm afraid it causes regressions for pgjdbc. > Here's CI log: https://travis-ci.org/pgjdbc/pgjdbc/jobs/327327402 > > The errors are: > testMetaData[typeName = REF_CURSOR, cursorType = > 2,012](org.postgresql.test.jdbc2.RefCursorTest) Time elapsed: 0.032 sec > <<< ERROR! org.postgresql.util.PSQLException: ERROR: cannot drop pinned > portal "<unnamed portal 1>" > > It looks like "refcursor" expressions are somehow broken.
Hmm, it seems like we are missing some test coverage in core for that. I guess I'll have to revert this patch and go with the first approach of putting it directly into PL/Perl and PL/Python. -- Peter Eisentraut http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services