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

From: "Al Presseller" <apresseller(at)commoninf(dot)com>
To: <pgsql-jdbc(at)postgresql(dot)org>
Subject: "Cached plan must not change result type" error when switching search_path via explicit execution of SET SEARCH_PATH = ...
Date: 2017-01-24 22:27:20
Message-ID: 020201d27691$072841e0$1578c5a0$@commoninf.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

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.

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Vladimir Sitnikov 2017-01-24 22:34:23 Re: "Cached plan must not change result type" error when switching search_path via explicit execution of SET SEARCH_PATH = ...
Previous Message Jorge Solórzano 2017-01-20 13:53:05 Re: [JDBC] SEGFAULT in HEAD with replication