Re: Using PQexecQuery in pipeline mode produces unexpected Close messages

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: Using PQexecQuery in pipeline mode produces unexpected Close messages
Дата
Msg-id 202206081508.pwq4ne3df2si@alvherre.pgsql
обсуждение исходный текст
Ответ на Using PQexecQuery in pipeline mode produces unexpected Close messages  (Daniele Varrazzo <daniele.varrazzo@gmail.com>)
Список pgsql-bugs
On 2022-Jun-08, Daniele Varrazzo wrote:

> Is this a problem with PQexecQuery which should not send the Close, or
> with receiving in IDLE mode which should expect a CloseComplete?

Interesting.

What that Close message is doing is closing the unnamed portal, which
is otherwise closed implicitly when the next one is opened.  That's how
single-query mode works: if you run a single portal, it'll be kept open.

I believe that the right fix is to not send that Close message in
PQsendQuery.

-- 
Álvaro Herrera               48°01'N 7°57'E  —  https://www.EnterpriseDB.com/
"Para tener más hay que desear menos"



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

Предыдущее
От: Christoph Berg
Дата:
Сообщение: Re: Fallout from 'Make type "name" collation-aware' and tg_table_name
Следующее
От: PG Bug reporting form
Дата:
Сообщение: BUG #17513: recompressing already-compressed data via VACUUM FULL or CLUSTER does not work