X-Original-To: pgsql-performance@postgresql.org Received: from spampd.localdomain (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 115AA4763B1 for ; Tue, 13 May 2003 19:11:36 -0400 (EDT) Received: from jal.clueinc.net (xd84b436b.ip.e-nt.net [216.75.67.107]) by postgresql.org (Postfix) with ESMTP id BD6CD4763BD for ; Tue, 13 May 2003 19:11:34 -0400 (EDT) Received: from jal.clueinc.net (localhost [127.0.0.1]) by jal.clueinc.net (8.12.9/8.12.9/Debian-3) with ESMTP id h4E0BHIE024386 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=FAIL) for ; Tue, 13 May 2003 19:11:17 -0500 Received: (from jal@localhost) by jal.clueinc.net (8.12.9/8.12.9/Debian-3) id h4E0BHPw024384 for pgsql-performance@postgresql.org; Tue, 13 May 2003 19:11:17 -0500 Date: Tue, 13 May 2003 19:11:17 -0500 From: Jamie Lawrence To: pgsql-performance@postgresql.org Subject: Re: Finding filenames for tables Message-ID: <20030514001117.GC4093@jal.clueinc.net> Mail-Followup-To: pgsql-performance@postgresql.org References: <20030513223055.GZ4093@jal.clueinc.net> <3EC1691D.4050604@web.de> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <3EC1691D.4050604@web.de> Organization: clue inc X-URL: http://www.clueinc.net/ User-Agent: Mutt/1.5.4i X-Spam-Status: No, hits=-38.0 required=5.0 tests=BAYES_10,EMAIL_ATTRIBUTION,IN_REP_TO,QUOTED_EMAIL_TEXT, REFERENCES,REPLY_WITH_QUOTES,USER_AGENT_MUTT autolearn=ham version=2.50 X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.50 (1.173-2003-02-20-exp) X-Archive-Number: 200305/155 X-Sequence-Number: 1934 On Tue, 13 May 2003, Andreas Pflug wrote: > you don't need to join since pg_class is specific for a database. You > cannot see any classes from a different database in pg_class. In > contrast, pg_database is server-wide mirrored. Thank you! I had sufficiently confused myself that I didn't even think to wonder if this was the case or not. Thanks again. -j -- Jamie Lawrence jal@jal.org "It only takes 20 years for a liberal to become a conservative without changing a single idea." - Robert Anton Wilson