Named Cursors WITH HOLD

From: deavid <deavidsedice(at)gmail(dot)com>
To: psycopg(at)postgresql(dot)org
Subject: Named Cursors WITH HOLD
Date: 2011-07-05 07:07:47
Message-ID: CAFR-75vbcTVTrze4Vyf7P8RoALfvdRTJOPh+kQ9Z_ZoTQff2Zw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: psycopg

Hi, i'm using psycopg and i'm noticing that Named Cursors are being
deleted by PostgreSQL whenever i do a commit. This is the default
behaviour specified in [1], but there is a parameter when creating a
cursor called "WITH HOLD" that allows a cursor outside any
transaction.

But i can't see any way in the psycopg API to do this. Maybe a cursor
factory, but I've no idea on how to do it.

[1]: http://www.postgresql.org/docs/current/static/sql-declare.html

Responses

Browse psycopg by date

  From Date Subject
Next Message Federico Di Gregorio 2011-07-05 07:26:59 Re: Named Cursors WITH HOLD
Previous Message Daniele Varrazzo 2011-07-01 15:17:58 Re: Custom array types converter