On Thu, Sep 1, 2011 at 1:24 PM, David Johnston <polobo(at)yahoo(dot)com> wrote:
> Hi,
>
>
>
> From the documentation:
>
> “Whenever a new session is subsequently started in that database, the
> specified value becomes the session default value.”
>
> Is there some way to get existing sessions to see the new search_path
> without forcing them to reconnect.
Think about what you're asking. Imagine you're in the middle of a
transaction using one search path, and suddenly, mid transaction it
just changes. I don't think you can force it without killing off the
backend the other user's are attached to and forcing them to
reconnect.