Thanks guys, that makes perfect sense to me... Am Sonntag, 28. September 2014 schrieb Tom Lane :
> Marko Tiikkaja <ma...@joh.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 >
