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 ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq