X-Original-To: pgsql-hackers@postgresql.org Received: from spampd.localdomain (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id E84BD475F1B for ; Thu, 24 Apr 2003 01:49:30 -0400 (EDT) Received: from datafix.CS.Berkeley.EDU (datafix.CS.Berkeley.EDU [128.32.37.185]) by postgresql.org (Postfix) with ESMTP id 40580475F0D for ; Thu, 24 Apr 2003 01:49:30 -0400 (EDT) Received: (from sailesh@localhost) by datafix.CS.Berkeley.EDU (8.11.6/8.11.6) id h3O5nKR07247; Wed, 23 Apr 2003 22:49:20 -0700 X-Authentication-Warning: datafix.CS.Berkeley.EDU: sailesh set sender to sailesh@cs.berkeley.edu using -f Reply-To: sailesh@cs.berkeley.edu X-URL: http://www.cs.berkeley.edu/~sailesh X-Attribution: Sailesh To: "scott.marlowe" Cc: Shridhar Daithankar , PostgreSQL Hackers Subject: Re: Are we losing momentum? References: From: Sailesh Krishnamurthy Date: 23 Apr 2003 22:49:20 -0700 In-Reply-To: Message-ID: Lines: 19 User-Agent: Gnus/5.0808 (Gnus v5.8.8) XEmacs/21.1 (Cuyahoga Valley) MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Spam-Status: No, hits=-24.0 required=5.0 tests=BAYES_01,IN_REP_TO,REFERENCES,USER_AGENT_GNUS_UA, X_AUTH_WARNING autolearn=ham version=2.50 X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.50 (1.173-2003-02-20-exp) X-Archive-Number: 200304/831 X-Sequence-Number: 38321 >>>>> "scott" == scott marlowe writes: scott> Plus the fact that the underlying pg_ tables are stable scott> from release to release makes it a bit awkward to upgrade scott> the servers they play on. Most of them have gone ahead and scott> created views that give them a consistent view of the parts scott> of the database they need. This is exactly the reason why in db2 _no_ guarantees are made regarding the constancy of the system catalogs (that are in the SYSIBM schema). Instead, the equivalent views (in the SYSCAT schema) are _never_ broken (whether in a point release or a new version). In fact, the SYSCAT views correspond to the ISO SQL standard. -- Pip-pip Sailesh http://www.cs.berkeley.edu/~sailesh