Re: Proper query implementation for Postgresql driver

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