X-Original-To: pgsql-hackers@postgresql.org Received: from spampd.localdomain (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 81636475E91 for ; Tue, 6 May 2003 21:51:31 -0400 (EDT) Received: from houston.familyhealth.com.au (unknown [203.59.48.253]) by postgresql.org (Postfix) with ESMTP id 29B42475B8E for ; Tue, 6 May 2003 21:51:01 -0400 (EDT) Received: (from root@localhost) by houston.familyhealth.com.au (8.11.6p2/8.11.6) id h471p4x33856 for pgsql-hackers@postgresql.org; Wed, 7 May 2003 09:51:04 +0800 (WST) (envelope-from chriskl@familyhealth.com.au) Received: from mariner (mariner.internal [192.168.0.101]) by houston.familyhealth.com.au (8.11.6p2/8.9.3) with SMTP id h471p2J33766; Wed, 7 May 2003 09:51:02 +0800 (WST) Message-ID: <074701c3143b$235dc640$6500a8c0@fhp.internal> From: "Christopher Kings-Lynne" To: "Andreas Pflug" , References: <3EB80C87.106@web.de> Subject: Re: information_schema OID Date: Wed, 7 May 2003 09:51:12 +0800 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1158 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 X-scanner: scanned by Inflex 0.1.5c - (http://www.inflex.co.za/) X-Spam-Status: No, hits=-12.8 required=5.0 tests=BAYES_20,QUOTED_EMAIL_TEXT,REFERENCES 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/126 X-Sequence-Number: 38633 > As information_schema has found its way into the initdb script, it can > be considered a system schema. Unfortunately, it has an arbitrary OID, > so pgadmin3 will not detect it as system schema. > How should pgadmin3 handle this? Will information_schema eventually get > a dedicated OID or should we check for the name? Also, should the information_schema be pinned so that it cannot be dropped? This would help db admin projects such as phpPgAdmin be able to rely on information_schema being there... Chris