| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | David Fetter <david(at)fetter(dot)org> |
| Cc: | Josh Berkus <josh(at)agliodbs(dot)com>, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: Per-database search_path |
| Date: | 2006-09-29 22:15:36 |
| Message-ID: | 4399.1159568136@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
David Fetter <david(at)fetter(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Joshua D. Drake | 2006-09-30 02:31:21 | Re: Win32 hard crash problem |
| Previous Message | David Fetter | 2006-09-29 22:11:58 | Re: Per-database search_path |