Re: Protocol 2 and query parameters support

From: Andres Freund <andres(at)anarazel(dot)de>
To: "Rader, David" <davidr(at)openscg(dot)com>
Cc: Tatsuo Ishii <ishii(at)sraoss(dot)co(dot)jp>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgfizm(at)gmail(dot)com, pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Protocol 2 and query parameters support
Date: 2017-04-24 20:11:26
Message-ID: 20170424201126.lxhphq6f6r6qyozz@alap3.anarazel.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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...

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tatsuo Ishii 2017-04-24 23:11:46 Re: Protocol 2 and query parameters support
Previous Message Rader, David 2017-04-24 20:07:01 Re: Protocol 2 and query parameters support