X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 15C9511F65C5 for ; Sun, 2 Apr 2006 19:28:52 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 74491-01 for ; Sun, 2 Apr 2006 19:28:51 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id EC25711F6029 for ; Sun, 2 Apr 2006 19:28:49 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.6/8.13.6) with ESMTP id k32MSkDl025460; Sun, 2 Apr 2006 18:28:46 -0400 (EDT) To: Peter Eisentraut cc: pgsql-admin@postgresql.org, "Rajesh Kumar Mallah" , andy.shellam@mailnetwork.co.uk, "Christopher Browne" Subject: Re: Show tables query In-reply-to: <200604021938.20644.peter_e@gmx.net> References: <878xqo9m8q.fsf@wolfe.cbbrowne.com> <23723.1143996403@sss.pgh.pa.us> <200604021938.20644.peter_e@gmx.net> Comments: In-reply-to Peter Eisentraut message dated "Sun, 02 Apr 2006 19:38:19 +0200" Date: Sun, 02 Apr 2006 18:28:46 -0400 Message-ID: <25459.1144016926@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.114 required=5 tests=[AWL=0.114] X-Spam-Score: 0.114 X-Spam-Level: X-Archive-Number: 200604/23 X-Sequence-Number: 21192 Peter Eisentraut writes: > Tom Lane wrote: >> Unfortunately, the SQL committee did tremendous damage to that >> argument by changing the definitions of some of those views in >> SQL2003 :-( > The only changes to existing views were one renamed column and two or > three cases with relaxed permission checks so that more objects are now > shown. I do not expect any application to break. I'm sure the committee thinks the same, and they may even be right. I'm just pointing out that they've lost the moral high ground of "this API will never change". regards, tom lane