Hi,
I've been trying to do recursion and cursors in PL/PgSQL (PostgreSQL 8.1). It's a function who has a cursor and calls itself, but the problem raises after the first recursion, when PgSQL complains:
ERROR: cursor "cur" already in use
Are the cursors kept globally? or cached like TEMP TABLE?
There's an example code available in
http://www.croata.cl/cur.sql . In fact, it is an abstraction of the real stored procedure where the problem occurs.
--
Thanks in advance,
Cro