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.


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]

  + If your life is a hard drive, Christ can be your backup. +

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?


Reply via email to