Received: from sd.tpf.co.jp (sd.tpf.co.jp [210.161.239.34]) by postgresql.org (8.11.3/8.11.4) with SMTP id g0V1v1l07129 for ; Wed, 30 Jan 2002 20:57:01 -0500 (EST) (envelope-from Inoue@tpf.co.jp) Received: (qmail 21526 invoked from network); 31 Jan 2002 01:57:03 -0000 Received: from unknown (HELO viscomail.tpf.co.jp) (100.0.0.108) by sd2.tpf-fw-c.co.jp with SMTP; 31 Jan 2002 01:57:03 -0000 Received: from tpf.co.jp (3dgateway1 [126.0.1.60]) by viscomail.tpf.co.jp (8.8.8+Sun/8.8.8) with ESMTP id KAA10366; Thu, 31 Jan 2002 10:57:02 +0900 (JST) Message-ID: <3C58A472.2E90C21C@tpf.co.jp> Date: Thu, 31 Jan 2002 10:57:06 +0900 From: Hiroshi Inoue X-Mailer: Mozilla 4.73 [ja] (Windows NT 5.0; U) X-Accept-Language: ja MIME-Version: 1.0 To: Tom Lane CC: Bill Studenmund , Peter Eisentraut , PostgreSQL Development Subject: Re: RFD: schemas and different kinds of Postgres objects References: <3C573C5E.F01B48C2@tpf.co.jp> <27527.1012432386@sss.pgh.pa.us> Content-Type: text/plain; charset=iso-2022-jp Content-Transfer-Encoding: 7bit X-Archive-Number: 200201/1358 X-Sequence-Number: 18317 Tom Lane wrote: > > Hiroshi Inoue writes: > > Bill Studenmund wrote: > >> While we may have not been using the terminology of the spec, I think we > >> have been talking about schema paths from SQL99. > >> > >> One difference between our discussions and SQL99 I've noticed is that > >> we've spoken of having the path find functions (and operators and > >> aggregates), types, _and_tables_. > > > My understanding is the same. > > Tom, Peter is it right ? > > SQL99's SQL-path is very clearly stated to be used only for looking up > routines and user-defined type names. Extending it to cover tables, > operators, and so forth makes sense to me, 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*. 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. regards, Hiroshi Inoue