Re: Named cursor problem - Mailing list psycopg

From Vojtěch Rylko
Subject Re: Named cursor problem
Date
Msg-id 4F26D3D2.2080206@vojtuv.net
Whole thread Raw
In response to Re: Named cursor problem  (Federico Di Gregorio <fog@dndg.it>)
List 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.

psycopg by date:

Previous
From: Federico Di Gregorio
Date:
Subject: Re: Named cursor problem
Next
From: Christian Ferrari
Date:
Subject: Psycopg2 and LIXA