Re: Named Cursors WITH HOLD

On 05/07/11 09:07, deavid wrote:
> 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.

I first try at WITH HOLD is available from the devel branch:

git://luna.dndg.it/public/psycopg2

Example code:

curs = conn.cursort("NAME")
curs.withhold = True
curs.execute("SELECT ...");
conn.commit()
curs.fetchXXX()

It should work. If it doesn't work please report any bug so that we can
fix them before the release.

federico

--
Federico Di Gregorio                         federico.digregorio@dndg.it
Studio Associato Di Nunzio e Di Gregorio                  http://dndg.it
 The only thing I see is if you are pumping so much data into the
  database all the time when do you expect to look at it?
                                                        -- Charlie Clark