How to get around this limitation (ALTER DATABASE db SET search_path = ...)

From: "David Johnston" <polobo(at)yahoo(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: How to get around this limitation (ALTER DATABASE db SET search_path = ...)
Date: 2011-09-01 19:24:09
Message-ID: 001101cc68dc$b980edb0$2c82c910$@yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

Thanks,

David J.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2011-09-01 20:24:59 Re: Why schema of table is removed from explain?
Previous Message hubert depesz lubaczewski 2011-09-01 18:08:22 Why schema of table is removed from explain?