On Wed, Sep 14, 2011 at 11:49 AM, Aidan Van Dyk <ai...@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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
