From: Fernando Nasser <fnasser@redhat.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Peter Eisentraut <peter_e@gmx.net>
Cc: pgsql-hackers@postgresql.org
Subject: Re: RFD: schemas and different kinds of Postgres objects
Date: Tue, 22 Jan 2002 16:02:07 -0500
Message-ID: <3C4DD34F.CC4D8B6@redhat.com> (raw)
References: <Pine.LNX.4.30.0201211840260.687-100000@peter.localdomain>
<12239.1011661590@sss.pgh.pa.us>
<3C4D8A39.FF79CDC4@redhat.com>
<15339.1011716171@sss.pgh.pa.us>
<3C4D96C5.80BBF764@redhat.com>
<15638.1011718290@sss.pgh.pa.us>
<3C4DCBDB.689D7201@redhat.com>
<28199.1011732109@sss.pgh.pa.us>
Tom Lane wrote:
>
> Huh? You seem to be assuming that we need to support both the
> historical Postgres behavior and the SQL-standard behavior with exactly
> the same configuration switches. That's not how I'm seeing it at all.
> The way I'm envisioning it, you could get either the historical
> behavior, or the standard's behavior, depending on how you set up the
> configuration variables.
Then we can live just with the schema being the ownership.
Switches set to standard:
schema search path = ("user's own schema", postgres)
[ default creation schema = user's own schema ] same as below,
we don't need this
switch
Switches set to historical:
schema search path = (user's own schema, "any" schema, postgres)
[ default creation schema = user's own schema ]
The searching in "any" schema (i.e., any owner) will let will find
things that where defined the way they are today, i.e., possibly
by several different users.
P.S.: You can even add the "default" schema in the standard case and
I believe you are still compliant and can handle things easier:
schema search path = ("user's own schema", postgres)
Maybe you could give an example of a case where the schema meaning
ownership breaks things. Or what kind of additional things you have
in mind that would require orthogonal schema and ownership spaces.
Regards,
Fernando
--
Fernando Nasser
Red Hat Canada Ltd. E-Mail: fnasser@redhat.com
2323 Yonge Street, Suite #300
Toronto, Ontario M4P 2C9
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: fnasser@redhat.com, tgl@sss.pgh.pa.us, peter_e@gmx.net
Subject: Re: RFD: schemas and different kinds of Postgres objects
In-Reply-To: <3C4DD34F.CC4D8B6@redhat.com>
* 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