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

Re: Per-database search_path

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Cc: David Fetter <david(at)fetter(dot)org>
Subject: Re: Per-database search_path
Date: 2006-09-29 20:06:09
Message-ID: 200609291306.09912.josh@agliodbs.com (view raw or flat)
Thread:
Lists: pgsql-hackers
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 ...

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".

-- 
--Josh

Josh Berkus
PostgreSQL @ Sun
San Francisco

In response to

Responses

pgsql-hackers by date

Next:From: Robert TreatDate: 2006-09-29 20:09:36
Subject: Re: The enormous s->childXids problem
Previous:From: David FetterDate: 2006-09-29 19:40:17
Subject: Per-database search_path

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