Re: [HACKERS] Support for JDBC setQueryTimeout, et al.

Stephen Frost <sfrost@snowman.net> writes:
>> The whole problem with search_path and role is very frustrating.  We've
>> taken to just hacking things to be dynamic SQL whenever it's
>> role-specific, but that's a really poor solution.  I wonder if it would
>> be possible to have the function and prepare'd plan caches be key'd off
>> of the search_path and role too..?  So if you change one of those you
>> end up having to re-plan it, but then that's also cached, etc..

FWIW, I can see the point of making cached plan lookup be
search-path-specific.  But why does the active role need to factor
into it?

            regards, tom lane