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