Re: about client-side cursors

Поиск
Список
Период
Сортировка
От Denis Laxalde
Тема Re: about client-side cursors
Дата
Msg-id 20210204163852.5mwvddtr74aw6wrh@dalibo.com
обсуждение исходный текст
Ответ на Re: about client-side cursors  (Christophe Pettus <xof@thebuild.com>)
Ответы Re: about client-side cursors  (Christophe Pettus <xof@thebuild.com>)
Список psycopg
Christophe Pettus a écrit :
> But it's not just CURSORs that have this behavior.  libpq allows the
> client to the send the query, and then make separate requests for each
> row, even without a database cursor; this maps almost exactly to
> .execute() and .fetchone().

Is this related to prepared statements in the extended query protocol?
(Then, I'd argue that both preparation and execution steps would involve
IO. But if it's not a cursor, we should use a different name, as
postgresql doc does.)

> It doesn't seem a good idea to guarantee
> forever that .execute() will *never* do I/O without a database-side
> cursor.

Currently, it seems to me that .execute() always do IO with or without a
database cursor.



В списке psycopg по дате отправления:

Предыдущее
От: Daniele Varrazzo
Дата:
Сообщение: Re: about client-side cursors
Следующее
От: Christophe Pettus
Дата:
Сообщение: Re: about client-side cursors