From: Joe Conway (wwc) <jconway@cox.net>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Zeugswetter Andreas SB SD <ZeugswetterA@spardat.at>
Cc: Fernando Nasser <fnasser@redhat.com>
Cc: Peter Eisentraut <peter_e@gmx.net>
Cc: pgsql-hackers@postgresql.org
Subject: Re: RFD: schemas and different kinds of Postgres objects
Date: Wed, 23 Jan 2002 08:56:15 -0800
Message-ID: <3C4EEB2F.8040803@cox.net> (raw)
References: <46C15C39FEB2C44BA555E356FBCD6FA41EB4C2@m0114.s-mxs.net>
<2677.1011800674@sss.pgh.pa.us>
Tom Lane wrote:
>
> This would be a *whole* lot simpler if we forgot the notion of "any"
> and made the search order look like
>
> (temp, private, public, system)
>
> where the public namespace is world-writable but the private per-user
> ones are (typically at least) not.
>
> It occurs to me that we can get both backward-compatible and SQL92
> semantics with this same search path; the only thing that needs to
> be different in the two cases is whether the default place to create
> objects is your private schema or the public one. If you don't ever
> use your private schema then it doesn't matter if it's on the search
> path or not. I would still prefer that the search path be a settable
> option, since a paranoid person might well wish to not have public in
> his path at all ... but the default could be as-above.
>
I think it would be desirable to be able to restrict users from
"publishing" objects into the public schema. As an admin, I'd like some
control over the objects in this namespace. Hand-in-hand with this would
be the ability for the superuser to move (or "promote") an object from a
private schema to the public one. This would allow a user to develop
their own objects without interfering with others, but then make it
public with the superuser's assistance.
The search path you suggest above would then lead to the behavior that
unqualified references to objects will see my own objects before the
public ones, and other people's private objects must be explicitly
qualified.
Joe
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-hackers@postgresql.org
Cc: jconway@cox.net, tgl@sss.pgh.pa.us, ZeugswetterA@spardat.at, fnasser@redhat.com, peter_e@gmx.net
Subject: Re: RFD: schemas and different kinds of Postgres objects
In-Reply-To: <3C4EEB2F.8040803@cox.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox