Re: Per-database search_path - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: Per-database search_path
Date
Msg-id 200612272208.kBRM81N13962@momjian.us
Whole thread Raw
In response to Re: Per-database search_path  (David Fetter <david@fetter.org>)
Responses Re: Per-database search_path
List pgsql-hackers
David Fetter wrote:
> 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?

I think we just need to decide on the user API for this.

---------------------------------------------------------------------------


> 
> 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!

--  Bruce Momjian   bruce@momjian.us EnterpriseDB    http://www.enterprisedb.com
 + If your life is a hard drive, Christ can be your backup. +


pgsql-hackers by date:

Previous
From: David Fetter
Date:
Subject: (SETOF) RECORD AS complex_type
Next
From: "Simon Riggs"
Date:
Subject: Re: Load distributed checkpoint