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

Re: Named cursor problem

From: Vojtěch Rylko <rylko(at)vojtuv(dot)net>
To: Federico Di Gregorio <fog(at)dndg(dot)it>
Cc: psycopg(at)postgresql(dot)org
Subject: Re: Named cursor problem
Date: 2012-01-30 17:30:58
Message-ID: 4F26D3D2.2080206@vojtuv.net (view raw or flat)
Thread:
Lists: psycopg
Dne 30.1.2012 17:27, Federico Di Gregorio napsal(a):
> On 30/01/12 17:16, Vojtěch Rylko wrote:
>> Dne 30.1.2012 17:13, Federico Di Gregorio napsal(a):
>>> Did you commit or rollback the connection?
>>>
>>> federico
>>>
>> Yes!, I commit the connection on another table. So solution may be
>> second connection?
>
> Yes. If you commit the current transaction is lost and the server-side 
> cursor isn't valid anymore. You can use a different connection to 
> fetch the results or create a "withhold" cursor.
> Hope this helps,
> federico

Different connection solved my problem, thank you for your help. Vojtěch R.

In response to

psycopg by date

Next:From: Christian FerrariDate: 2012-02-11 17:37:46
Subject: Psycopg2 and LIXA
Previous:From: Federico Di GregorioDate: 2012-01-30 16:27:52
Subject: Re: Named cursor problem

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