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.
What would be involved with making this so? So far, I can see:
* Storing this information in pg_catalog somehow
* Setting the search_path when a login role connects
David Fetter <david(at)fetter(dot)org> http://fetter.org/
phone: +1 415 235 3778 AIM: dfetter666
Remember to vote!
pgsql-hackers by date
|Next:||From: Josh Berkus||Date: 2006-09-29 20:06:09|
|Subject: Re: Per-database search_path|
|Previous:||From: Andrew Sullivan||Date: 2006-09-29 19:02:12|
|Subject: Replication hooks discussion|