Re: Proper query implementation for Postgresql driver

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Proper query implementation for Postgresql driver
Дата
Msg-id 1843.1411914908@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Proper query implementation for Postgresql driver  (Marko Tiikkaja <marko@joh.to>)
Ответы Re: Proper query implementation for Postgresql driver  (Shay Rojansky <roji@roji.org>)
Список pgsql-hackers
Marko Tiikkaja <marko@joh.to> writes:
> On 9/28/14, 11:53 AM, Shay Rojansky wrote:
>> [ complaint about multiple round trips in extended protocol ]

> You don't have to do multiple round-trips for that; you can just send 
> all the messages in one go.  See how e.g. libpq does it in PQexecParams().

Right.  The key thing to understand is that after an error, the server
skips messages until it sees a Sync.  So you can send out Parse, Bind,
Execute, Sync in one packet and not have to worry that the server will
attempt to execute a query that failed parsing or whatever.
        regards, tom lane



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

Предыдущее
От: Andres Freund
Дата:
Сообщение: Re: Patch to support SEMI and ANTI join removal
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Patch to support SEMI and ANTI join removal