| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Christian Ferrari | 2012-02-11 17:37:46 | Psycopg2 and LIXA |
| Previous Message | Federico Di Gregorio | 2012-01-30 16:27:52 | Re: Named cursor problem |