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