Re: Set search_path + server-prepared statements = cached plan must not change result type

Vladimir Sitnikov <sitnikov.vladimir@gmail.com> writes:
> Here's my question: why change in search_path does NOT generate
> ParameterStatus message from the backend?

The protocol specification includes a list of the small number of GUCs
for which ParameterStatus messages are generated, and that is not one
of them.

This has been discussed before, I believe, and the conclusion was that
if you think you need this, you're doing it wrong.  More robust solutions
involve having individual functions use SET clauses to locally force
search_path to be what they want.  If we had search_path marked as
GUC_REPORT, that would both lead to a storm of useless client messages
when such techniques were in use, and encourage people to use methods
that won't really work reliably.
        regards, tom lane