Home > mailing lists

Named Cursors WITH HOLD - Mailing list psycopg

From	deavid
Subject	Named Cursors WITH HOLD
Date	July 5, 2011 07:08:14
Msg-id	CAFR-75vbcTVTrze4Vyf7P8RoALfvdRTJOPh+kQ9Z_ZoTQff2Zw@mail.gmail.com Whole thread Raw
Responses	Re: Named Cursors WITH HOLD (Federico Di Gregorio <federico.digregorio@dndg.it>) Re: Named Cursors WITH HOLD (Federico Di Gregorio <federico.digregorio@dndg.it>)
List	psycopg

Tree view

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

psycopg by date:

From: Daniele Varrazzo
Date: 01 July 2011, 15:18:05
Subject: Re: Custom array types converter

From: Federico Di Gregorio
Date: 05 July 2011, 07:27:43
Subject: Re: Named Cursors WITH HOLD

Named Cursors WITH HOLD - Mailing list psycopg

Previous

Next