Bruce Momjian <[EMAIL PROTECTED]> writes:
> David Fetter wrote:
>> 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.
... and the catalog representation.
regards
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. Consid
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-datab
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 fo
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 thi
On Fri, Sep 29, 2006 at 05:41:35PM -0400, Tom Lane wrote:
> David Fetter <[EMAIL PROTECTED]> writes:
> > On Fri, Sep 29, 2006 at 01:06:09PM -0700, Josh Berkus wrote:
> >> However, it almost seems like this would become a piece of the
> >> other per-database-user stuff we'd like to do, like "local
>
David Fetter <[EMAIL PROTECTED]> writes:
> On Fri, Sep 29, 2006 at 01:06:09PM -0700, Josh Berkus wrote:
>> However, it almost seems like this would become a piece of the other
>> per-database-user stuff we'd like to do, like "local superuser".
> I'm not sure that's the same. The thing about super
On Fri, Sep 29, 2006 at 01:06:09PM -0700, Josh Berkus wrote:
> DF,
>
> > I'd like to propose a feature for 8.3, which would let login roles
> > have a default search_path both globally, as it is now, and
> > per-database. This is because in general no two databases have
> > any schemas in common,
DF,
> I'd like to propose a feature for 8.3, which would let login roles
> have a default search_path both globally, as it is now, and
> per-database. This is because in general no two databases have
> any schemas in common, and a login role should be able to do something
> reasonable just by con
