Re: [GENERAL] Protocol 2 and query parameters support - Mailing list pgsql-general

From Andres Freund
Subject Re: [GENERAL] Protocol 2 and query parameters support
Date
Msg-id 20170424201126.lxhphq6f6r6qyozz@alap3.anarazel.de
Whole thread Raw
In response to Re: [GENERAL] Protocol 2 and query parameters support  ("Rader, David" <davidr@openscg.com>)
Responses Re: [GENERAL] Protocol 2 and query parameters support  (Tatsuo Ishii <ishii@sraoss.co.jp>)
List pgsql-general
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 prepares.
>
> https://jdbc.postgresql.org/documentation/publicapi/org/postgresql/PGStatement.html#setPrepareThreshold-int-
>
> "If threshold is zero, server-side prepare will not be used."

Note that you can use the extended protocol without server side
prepares...


pgsql-general by date:

Previous
From: "Rader, David"
Date:
Subject: Re: [GENERAL] Protocol 2 and query parameters support
Next
From: Tatsuo Ishii
Date:
Subject: Re: [GENERAL] Protocol 2 and query parameters support