Re: [GENERAL] Protocol 2 and query parameters support

Список
Период
Сортировка
От Tatsuo Ishii
Тема Re: [GENERAL] Protocol 2 and query parameters support
Дата
Msg-id 20170424.113309.940779911566232438.t-ishii@sraoss.co.jp
обсуждение исходный текст
Ответ на Re: [GENERAL] Protocol 2 and query parameters support  (Tom Lane)
Ответы Re: [GENERAL] Protocol 2 and query parameters support  ("Rader, David")
Список pgsql-general
Дерево обсуждения
[GENERAL] Protocol 2 and query parameters support  (Konstantin Izmailov, )
 Re: [GENERAL] Protocol 2 and query parameters support  (Adrian Klaver, )
  Re: [GENERAL] Protocol 2 and query parameters support  ("David G. Johnston", )
 Re: [GENERAL] Protocol 2 and query parameters support  (Andres Freund, )
  Re: [GENERAL] Protocol 2 and query parameters support  (Tom Lane, )
   Re: [GENERAL] Protocol 2 and query parameters support  (Tatsuo Ishii, )
    Re: [GENERAL] Protocol 2 and query parameters support  ("Rader, David", )
     Re: [GENERAL] Protocol 2 and query parameters support  (Andres Freund, )
      Re: [GENERAL] Protocol 2 and query parameters support  (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?  A quick
>> search didn't turn anything up.  Presto seems a bit too new to rely on
>> v2, given how long ago v3 has been introduced.
>
> There's been moderately serious discussion about dropping v2 support
> altogether, so I sure hope there isn't anything in the wild that still
> depends on it.
>
> Also, moving from v2 to v3 per se just isn't very hard, if you aren't
> worried about making use of new-in-v3 protocol features.  I wonder whether
> Konstantin is confusing v2 vs v3 with use of simple vs. extended query
> protocol within v3.

It seems Presto uses v3 protocol only when ODBC driver is used. If
JDBC is used, it is required to set "protocolVersion=2" property of
JDBC driver, which means v2 protocol is used I think.

https://github.com/treasure-data/prestogres#limitation

Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp


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

Предыдущее
От: Albe Laurenz
Дата:
Сообщение: Re: [GENERAL] Memory consumption for Query
Следующее
От: "Christofer C. Bell"
Дата:
Сообщение: Re: [GENERAL] Recover PostgreSQL database folder data