Re: Named cursor problem

Поиск
Список
Период
Сортировка
От Vojtěch Rylko
Тема Re: Named cursor problem
Дата
Msg-id 4F26D3D2.2080206@vojtuv.net
обсуждение исходный текст
Ответ на Re: Named cursor problem  (Federico Di Gregorio <fog@dndg.it>)
Список 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 по дате отправления:

Предыдущее
От: Federico Di Gregorio
Дата:
Сообщение: Re: Named cursor problem
Следующее
От: Christian Ferrari
Дата:
Сообщение: Psycopg2 and LIXA