Postgres Pro
Downloads
Home   >   mailing lists

[JDBC] "Cached plan must not change result type" error when switching search_path via explicit execution of SET SEARCH_PATH = ... - Mailing list pgsql-jdbc

From Al Presseller
Subject [JDBC] "Cached plan must not change result type" error when switching search_path via explicit execution of SET SEARCH_PATH = ...
Date
Msg-id 020201d27691$072841e0$1578c5a0$@commoninf.com
Whole thread Raw
Responses Re: [JDBC] "Cached plan must not change result type" error whenswitching search_path via explicit execution of SET SEARCH_PATH = ...
Re: "Cached plan must not change result type" error whenswitching search_path via explicit execution of SET SEARCH_PATH = ...
List pgsql-jdbc
Tree view

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.   

 

pgsql-jdbc by date:

Previous
From: Jorge Solórzano
Date:
Subject: Re: [HACKERS] [JDBC] SEGFAULT in HEAD with replication
Next
From: Vladimir Sitnikov
Date:
Subject: Re: "Cached plan must not change result type" error whenswitching search_path via explicit execution of SET SEARCH_PATH = ...