Hi Tom,
thanks for your reply.
> > I was looking for a workaround to this problem, and figured that calling
> > 'discard all', or 'discard plans' should do the trick.
>
> That's not a solution because the plancache module intentionally
> preserves the original search_path value while replanning. This
> may not be what you wished for, but it's operating as intended,
> and changing it would break other use-cases that work today.
>
> regards, tom lane
>
We are weighing our options to deal with this problem.
I'm very interested in the use cases that will break when using the
current search_path instead of the original search_path when replanning.
Can you tell me what will break?
Thanks,
Ingmar