Re: "Cached plan must not change result type" error when switching search_path via explicit execution of SET SEARCH_PATH = ...

From: Vladimir Sitnikov <sitnikov(dot)vladimir(at)gmail(dot)com>
To: Al Presseller <apresseller(at)commoninf(dot)com>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: "Cached plan must not change result type" error when switching search_path via explicit execution of SET SEARCH_PATH = ...
Date: 2017-01-24 22:34:23
Message-ID: CAB=Je-ESngGfwRVw-LN7-C27UjBv7tNSPM+3cTtgMVzOnCVARg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

That's unfortunate.

Would you please report that ustream? (I mean to the postgresql developers)

The thing is it would be so much easier if pgjdbc would not have to parse
SQL in order to identify if the statement was "set search_path".

In the mean time: is lowercase style fine for you?

Vladimir

ср, 25 янв. 2017 г. в 1:27, Al Presseller <apresseller(at)commoninf(dot)com>:

> The fix for issue #496 ("Cached plan must not change result type" when
> using PreparedStatement cache across schemas) doesn’t work when the default
> schema is being assigned via explicit execution of a SET statement that
> renders the search_path keyword in UPPER CASE.
>
>
>

In response to

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Al Presseller 2017-01-25 19:09:24 Re: "Cached plan must not change result type" error when switching search_path via explicit execution of SET SEARCH_PATH = ...
Previous Message Al Presseller 2017-01-24 22:27:20 "Cached plan must not change result type" error when switching search_path via explicit execution of SET SEARCH_PATH = ...