Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

psycopg by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group