Re: Per-database search_path - Mailing list pgsql-hackers

From Josh Berkus
Subject Re: Per-database search_path
Date
Msg-id 200609291306.09912.josh@agliodbs.com
Whole thread Raw
In response to Per-database search_path  (David Fetter <david@fetter.org>)
Responses Re: Per-database search_path  (David Fetter <david@fetter.org>)
List pgsql-hackers
DF,

> I'd like to propose a feature for 8.3, which would let login roles
> have a default search_path both globally, as it is now, and
> per-database.  This is because in general no two databases have
> any schemas in common, and a login role should be able to do something
> reasonable just by connecting.

Yes.  I've been bitten by this more than once ...

However, it almost seems like this would become a piece of the other 
per-database-user stuff we'd like to do, like "local superuser".

-- 
--Josh

Josh Berkus
PostgreSQL @ Sun
San Francisco


pgsql-hackers by date:

Previous
From: David Fetter
Date:
Subject: Per-database search_path
Next
From: David Fetter
Date:
Subject: Re: Per-database search_path