Just adding in my two cents... At my last company we had several hundred stored procedures which all set a search path dynamically based on an input argument prior to running any queries. The current behavior is very alarming and challenging to consistently workaround.
Would be very happy to see a future version without the search path catching issues. Cheers, -- Casey Allen Shobe ca...@shobe.info