Re: Named Cursors WITH HOLD

From: Federico Di Gregorio <federico(dot)digregorio(at)dndg(dot)it>
To: psycopg(at)postgresql(dot)org
Subject: Re: Named Cursors WITH HOLD
Date: 2011-07-05 08:35:36
Message-ID: 4E12CCD8.6080600@dndg.it
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: psycopg

On 05/07/11 10:29, Federico Di Gregorio wrote:
> 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

"I first try"? Gosh, much work and no play makes fog a dull boy.

federico

--
Federico Di Gregorio federico(dot)digregorio(at)dndg(dot)it
Studio Associato Di Nunzio e Di Gregorio http://dndg.it
Se sai che hai un ***** di file così, lo manovri subito. -- vodka

In response to

Browse psycopg by date

  From Date Subject
Next Message W. Matthew Wilson 2011-07-20 00:24:06 I wish I could pass bound variables as a dictionary not a list
Previous Message Federico Di Gregorio 2011-07-05 08:29:58 Re: Named Cursors WITH HOLD