Re: Per-database search_path

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