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?
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 globally? or cached like TEMP TABLE?
Cursor names are global within a
On Wed, Dec 28, 2005 at 10:48:25AM -0500, Tom Lane 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 globally? or
Please, if someone recalls a link, book, piece of code or anything with info about this technique for PL/PgSQL (8.1), please let us know. We've been searching into google, groups.google,
http://archives.postgresql.organd http://www.postgresql.org/docs/8.1/interactivewith no results. Most of the
On Wed, Dec 28, 2005 at 04:37:21PM -0300, Don Croata wrote:
Please, if someone recalls a link, book, piece of code or anything with info
about this technique for PL/PgSQL (8.1), please let us know. We've been
searching into google, groups.google, http://archives.postgresql.org and