On Wed, Jul 18, 2007 at 11:02:51PM +0100, Richard Huxton wrote:
> Francisco Reyes wrote:
> >As far as I know, currently one can set the search path globally, or on
> >a per role bases.
> >
> >I was wondering if it could be possible to have a per database search_path.
> >I believe this would be not
Francisco Reyes wrote:
Is there a way to unset a role's search_path?
I had set one role with a particular search path. Now want to take that
off so the user can get the database's search_path setting.
ALTER ROLE ... RESET search_path;
--
Richard Huxton
Archonet Ltd
-
Richard Huxton writes:
ALTER DATABASE leia SET search_path = public,lookups;
Seems to work for me on 8.2 - you'll need to disconnect and reconnect to
see it take place though.
Hmm.. I must have typed something wrong when I tried..
For the archives..
If a user has a search path, that takes pr
Francisco Reyes <[EMAIL PROTECTED]> writes:
> As far as I know, currently one can set the search path globally, or on a
> per role bases.
> I was wondering if it could be possible to have a per database search_path.
ALTER DATABASE SET search_path = ...
regards, tom lane
Francisco Reyes wrote:
As far as I know, currently one can set the search path globally, or on
a per role bases.
I was wondering if it could be possible to have a per database search_path.
I believe this would be not only convenient, but will add flexibility.
ALTER DATABASE leia SET search_p
As far as I know, currently one can set the search path globally, or on a
per role bases.
I was wondering if it could be possible to have a per database search_path.
I believe this would be not only convenient, but will add flexibility.
What got me thinking of this was that I manually ste a sea
