Re: Proper query implementation for Postgresql driver

Thanks guys, that makes perfect sense to me...

Am Sonntag, 28. September 2014 schrieb Tom Lane :

> Marko Tiikkaja <marko(at)joh(dot)to <javascript:;>> 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
>