Re: [GENERAL] Protocol 2 and query parameters support

2017-04-24 Thread Tatsuo Ishii
> On 2017-04-24 16:07:01 -0400, Rader, David wrote: >> As Tom mentioned, it sounds like the issue is that Presto expects to only >> use simple query, not extended query (no server-side prepared statements). >> The JDBC driver supports setting the prepare threshold to 0 to disable >> using server-si

Re: [GENERAL] Protocol 2 and query parameters support

2017-04-24 Thread Andres Freund
On 2017-04-24 16:07:01 -0400, Rader, David wrote: > As Tom mentioned, it sounds like the issue is that Presto expects to only > use simple query, not extended query (no server-side prepared statements). > The JDBC driver supports setting the prepare threshold to 0 to disable > using server-side pre

Re: [GENERAL] Protocol 2 and query parameters support

2017-04-24 Thread Rader, David
On Sun, Apr 23, 2017 at 10:33 PM, Tatsuo Ishii wrote: > > Andres Freund writes: > >> On 2017-04-23 12:08:51 -0700, Konstantin Izmailov wrote: > >>> Some systems (Presto) are still using protocol 2, and I need to > understand > >>> the scope of changes in the middleware to support protocol 2. > >

Re: [GENERAL] Protocol 2 and query parameters support

2017-04-23 Thread Tatsuo Ishii
> Andres Freund writes: >> On 2017-04-23 12:08:51 -0700, Konstantin Izmailov wrote: >>> Some systems (Presto) are still using protocol 2, and I need to understand >>> the scope of changes in the middleware to support protocol 2. > >> Could you provide a reference about presto using v2 protocol?

Re: [GENERAL] Protocol 2 and query parameters support

2017-04-23 Thread Tom Lane
Andres Freund writes: > On 2017-04-23 12:08:51 -0700, Konstantin Izmailov wrote: >> Some systems (Presto) are still using protocol 2, and I need to understand >> the scope of changes in the middleware to support protocol 2. > Could you provide a reference about presto using v2 protocol? A quick

Re: [GENERAL] Protocol 2 and query parameters support

2017-04-23 Thread Andres Freund
On 2017-04-23 12:08:51 -0700, Konstantin Izmailov wrote: > Does Postgres protocol 2 support query parameters? e.g.: > SELECT colA FROM tbl WHERE colB=$1 > > Some systems (Presto) are still using protocol 2, and I need to understand > the scope of changes in the middleware to support protocol 2.

Re: [GENERAL] Protocol 2 and query parameters support

2017-04-23 Thread David G. Johnston
On Sunday, April 23, 2017, Adrian Klaver wrote: > On 04/23/2017 12:08 PM, Konstantin Izmailov wrote: > >> Does Postgres protocol 2 support query parameters? e.g.: >> SELECT colA FROM tbl WHERE colB=$1 >> >> Some systems (Presto) are still using protocol 2, and I need to >> understand the scope

Re: [GENERAL] Protocol 2 and query parameters support

2017-04-23 Thread Adrian Klaver
On 04/23/2017 12:08 PM, Konstantin Izmailov wrote: Does Postgres protocol 2 support query parameters? e.g.: SELECT colA FROM tbl WHERE colB=$1 Some systems (Presto) are still using protocol 2, and I need to understand the scope of changes in the middleware to support protocol 2. ? https://www