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 <[EMAIL PROTECTED]> 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 [EMAIL PROTECTED] > > EnterpriseDB http://www.enterprisedb.com > > > > + If your life is a hard drive, Christ can be your backup. + > > -- > David Fetter <[EMAIL PROTECTED]> http://fetter.org/ > phone: +1 415 235 3778 AIM: dfetter666 > Skype: davidfetter > > Remember to vote! -- Bruce Momjian [EMAIL PROTECTED] EnterpriseDB http://www.enterprisedb.com + If your life is a hard drive, Christ can be your backup. + ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org