Alternative to nested transactions - Mailing list pgsql-general

Hello all,

I'm trying to port a program from MS SQL Server which does the
following:

declare a cursor with a query for possibly update;
fetch and lock rows one by one;
release the lock in case where no update is necessary;

But, to release the lock I need to commit the transaction and if I
commit the transaction I lost the cursor.

How can I simulate nested transactions??
Or how can I simulate persistent cursors??

Any ideias??

Thanks in advance.

--
João Alfredo <joaoalf@dotx.com.br>
dotX Consultoria Serviços e Conectividade