Re: Per-database search_path

On Fri, Sep 29, 2006 at 11:55:18PM -0400, Bruce Momjian wrote:
> 
> Added to TODO:
> 
>     * Allow more complex user/database default GUC settings
>     
>       Currently, ALTER USER and ALTER DATABASE support per-user and
>       per-database defaults.  Consider adding per-user-and-database
>       defaults so things like search_path can be defaulted for a
>       specific user connecting to a specific database.

Is anybody claiming this TODO?  Is the design fleshed out enough for
someone to go forward with it?

Cheers,
D

> 
> ---------------------------------------------------------------------------
> 
> Tom Lane wrote:
> > David Fetter <david@fetter.org> writes:
> > > On Fri, Sep 29, 2006 at 05:41:35PM -0400, Tom Lane wrote:
> > >> Yeah.  ISTM the correct generalization is "per-user per-database
> > >> default GUC settings", which has nothing to do with superuserness.
> > 
> > > This sounds like a TODO for 8.3.  What wrinkles might this involve?
> > 
> > Probably rethink the rolconfig/datconfig representation.  Maybe it's
> > time for a separate catalog for the settings.
> > 
> > > Offhand, I'm thinking that it would touch the inheritance stuff that
> > > roles have.
> > 
> > No, it wouldn't, because defaults only apply at the instant of
> > connection, so there's no inheritance or SET ROLE to worry about.
> > Whatever role you log in as is what you get.
> > 
> >             regards, tom lane
> > 
> > ---------------------------(end of broadcast)---------------------------
> > TIP 6: explain analyze is your friend
> 
> -- 
>   Bruce Momjian   bruce@momjian.us
>   EnterpriseDB    http://www.enterprisedb.com
> 
>   + If your life is a hard drive, Christ can be your backup. +

-- 
David Fetter <david@fetter.org> http://fetter.org/
phone: +1 415 235 3778        AIM: dfetter666                             Skype: davidfetter

Remember to vote!