From: Tom Lane <tgl@sss.pgh.pa.us>
To: Hiroshi Inoue <Inoue@tpf.co.jp>
Cc: Bill Studenmund <wrstuden@netbsd.org>
Cc: Peter Eisentraut <peter_e@gmx.net>
Cc: PostgreSQL Development <pgsql-hackers@postgresql.org>
Subject: Re: RFD: schemas and different kinds of Postgres objects
Date: Wed, 30 Jan 2002 21:32:10 -0500
Message-ID: <29268.1012444330@sss.pgh.pa.us> (raw)
In-Reply-To: <3C58A472.2E90C21C@tpf.co.jp>
References: <Pine.NEB.4.33.0201290939350.24201-100000@vespasia.home-net.internetconnect.net>
<3C573C5E.F01B48C2@tpf.co.jp>
<27527.1012432386@sss.pgh.pa.us>
<3C58A472.2E90C21C@tpf.co.jp>
Hiroshi Inoue <Inoue@tpf.co.jp> writes:
> I have no objection to the point it makes sense to use
> such *path*s internally but I think it also has a siginificance
> for SQL-path to not look up _tables_like objects.
> I think they are different from the first and we should(need)
> not manage the system with one *path*.
I'm unconvinced. We must search for datatypes and tables on the same
path because tables have associated datatypes; it will definitely not
do to look for a table's datatype and get the wrong type. And I think
that functions and operators should be looked for on the same path
as datatypes, because a type should be pretty closely associated with
the functions/operators for it. So it seems to me that the apparent
flexibility of having more than one path is just a way to shoot yourself
in the foot. Why are you concerned that we keep them separate?
> BTW I see few references to *catalog*. Would the concept
> of catalog be introduced together. If so what would be
> contained in the current database.
My thought is that we will consider catalog == database. As far as
I can tell, that is a legitimate implementation-defined way of
interpreting the spec. (It's not clear to me what the value is of
having more than one level of schema hierarchy; or at least, if you want
hierarchical namespaces, there's no argument for stopping at depth two.
But I digress.) To satisfy the spec we must allow a (purely decorative)
specification of the current database name as the catalog level of a
qualified name, but that's as far as I want to go. In this round,
anyway. Cross-database access is not something to tackle for 7.3.
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, Inoue@tpf.co.jp, wrstuden@netbsd.org, peter_e@gmx.net
Subject: Re: RFD: schemas and different kinds of Postgres objects
In-Reply-To: <29268.1012444330@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