Robert>Are you really seeing the same behavior in all versions? I do not have "pre 9.1" at hand, however all 9.1, 9.2, 9.3, 9.4, and 9.5 are affected.
9.1 just silently executes "old statement" as if search_path was not modified at all. 9.2, 9.3, 9.4, and 9.5 all fail with "cached plan must not change result type" error. See java-based test in [1], and build logs for 9.1-9.4 in [2] I do not have "brand new 9.5", however I think 9.5rc1 is good enough: "PostgreSQL 9.5rc1 on x86_64-apple-darwin15.2.0, compiled by Apple LLVM version 7.0.0 (clang-700.1.76), 64-bit" Here's my test case: select version(); create schema customer1; create table customer1.test(i int4); create schema customer2; create table customer2.test(i varchar); set search_path to customer1,public; prepare stmt as select * from test; set search_path to customer2,public; execute stmt; --ERROR: cached plan must not change result type --SQL state: 0A000 [1]: https://github.com/pgjdbc/pgjdbc/commit/8fcd07a24666de308419d54e49e2f65f40661e2a#diff-526a72847ed4c9f31f699515d06e508bR188 [2]: https://travis-ci.org/pgjdbc/pgjdbc/builds/103940843 Vladimir -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
