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: (view raw, whole thread or download thread mbox)
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 Di Gregorio                         federico(dot)digregorio(at)dndg(dot)it
Studio Associato Di Nunzio e Di Gregorio        
       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-2017 The PostgreSQL Global Development Group