Re: Cursor Not Found - Mailing list pgsql-general

Lynn.Tilby@asu.edu writes:
> I have an embedded sql program with a while loop. I declare
> and open a cursor before the while. The fetch forward next
> is inside the while.  The first time through the while
> the cursor works perfectly the second time I get the error:

> sql error PerformPortalFetch: portal "foo_crsr" not found

Sounds like you need to hold a transaction open (BEGIN/END block)
around your use of the cursor.

            regards, tom lane