From: Tom Lane <tgl@sss.pgh.pa.us>
To: Bill Studenmund <wrstuden@netbsd.org>
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 14:57:14 -0500
Message-ID: <5078.1011815834@sss.pgh.pa.us> (raw)
In-Reply-To: <Pine.NEB.4.33.0201221710360.5119-100000@vespasia.home-net.internetconnect.net>
References: <Pine.NEB.4.33.0201221710360.5119-100000@vespasia.home-net.internetconnect.net>
Bill Studenmund <wrstuden@netbsd.org> writes:
> One of the things schemas have to support is essentially a PATH specifier.
Yes, but...
> So all we need to do is have all of the schemas created in a new DB have
> path specifiers pulling in all of the other schemas. Thus we can make a
> schema-savy system act as if it has only one namespace.
When you create a new user, do all those path specifiers for the
existing users magically update themselves? Seems like maintenance
would be a pain.
Fernando's "any" idea is probably a cleaner way to handle it if we
wanted to do things like that. But I still think it'll be safer and
more controllable if we provide a "public" namespace instead; see
followup discussions.
regards, tom lane
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: tgl@sss.pgh.pa.us, wrstuden@netbsd.org, peter_e@gmx.net
Subject: Re: RFD: schemas and different kinds of Postgres objects
In-Reply-To: <5078.1011815834@sss.pgh.pa.us>
* 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