05, Tom Lane <[EMAIL PROTECTED]> wrote:
Don Croata <[EMAIL PROTECTED]> writes:> 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
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 TABL
