Skip site navigation (1) Skip section navigation (2)

Re: Per-database search_path

From: David Fetter <david(at)fetter(dot)org>
To: Josh Berkus <josh(at)agliodbs(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Per-database search_path
Date: 2006-09-29 20:14:46
Message-ID: 20060929201446.GI2823@fetter.org (view raw or flat)
Thread:
Lists: pgsql-hackers
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, and a login role should be able to do
> > something reasonable just by connecting.
> 
> Yes.  I've been bitten by this more than once ...

Come to think of it, this ties in with the "ON (DIS)CONNECT TRIGGER"
idea that others have brought up in the past.  The trigger idea may be
too big a hammer, and might even be ill-advised from a design point of
view, but I thought I'd bring it up anyhow.

> 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 superuser as it exists
now is the ability to write to the filesystem, which means that
there's no boundary really possible.  Maybe some kind of tiered system
of users with more than 2 tiers...but that sounds pretty byzantine to
me.

Cheers,
D
-- 
David Fetter <david(at)fetter(dot)org> http://fetter.org/
phone: +1 415 235 3778        AIM: dfetter666
                              Skype: davidfetter

Remember to vote!

In response to

Responses

pgsql-hackers by date

Next:From: markDate: 2006-09-29 20:42:39
Subject: Re: Faster StrNCpy
Previous:From: Robert TreatDate: 2006-09-29 20:09:36
Subject: Re: The enormous s->childXids problem

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group