How to get around this limitation (ALTER DATABASE db SET search_path = ...) - Mailing list pgsql-general

From David Johnston
Subject How to get around this limitation (ALTER DATABASE db SET search_path = ...)
Date
Msg-id 001101cc68dc$b980edb0$2c82c910$@yahoo.com
Whole thread Raw
Responses Re: How to get around this limitation (ALTER DATABASE db SET search_path = ...)  (Scott Marlowe <scott.marlowe@gmail.com>)
List 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.

 

 

 

 

 

 

pgsql-general by date:

Previous
From: hubert depesz lubaczewski
Date:
Subject: Why schema of table is removed from explain?
Next
From: Thom Brown
Date:
Subject: Re: Why schema of table is removed from explain?