On Wed, Sep 14, 2011 at 11:49 AM, Aidan Van Dyk <aidan@highrise.ca> wrote:
>
> But I found it useful when needing to hand out "seperate" usernames
> for different apps because they all needed to have their own
> search_path and other settings set before login (yes, dumb apps,
> mostly odbc), and be able to have the same "userid" for different
> databases, using different settings...
>
why "before" login? in 9.0+ you can use ALTER ROLE ... IN DATABASE,
doesn't it help?
pre 9.0 need the db_user_namespace GUC for that, though
--
Jaime Casanova www.2ndQuadrant.com
Professional PostgreSQL: Soporte 24x7 y capacitación
