Re: Per-database search_path

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