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 4B03711F7DE4 for ; Sun, 2 Apr 2006 14:38:27 -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 08036-01 for ; Sun, 2 Apr 2006 14:38:25 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from mail.gmx.net (mail.gmx.net [213.165.64.20]) by postgresql.org (Postfix) with SMTP id 80D8611F7DBE for ; Sun, 2 Apr 2006 14:38:23 -0300 (ADT) Received: (qmail invoked by alias); 02 Apr 2006 17:38:22 -0000 Received: from dslb-084-063-054-068.pools.arcor-ip.net (EHLO colt.pezone.net) [84.63.54.68] by mail.gmx.net (mp042) with SMTP; 02 Apr 2006 19:38:22 +0200 X-Authenticated: #495269 From: Peter Eisentraut To: pgsql-admin@postgresql.org Subject: Re: Show tables query Date: Sun, 2 Apr 2006 19:38:19 +0200 User-Agent: KMail/1.8.3 Cc: Tom Lane , "Rajesh Kumar Mallah" , andy.shellam@mailnetwork.co.uk, "Christopher Browne" References: <878xqo9m8q.fsf@wolfe.cbbrowne.com> <23723.1143996403@sss.pgh.pa.us> In-Reply-To: <23723.1143996403@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200604021938.20644.peter_e@gmx.net> X-Y-GMX-Trusted: 0 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.133 required=5 tests=[AWL=0.133] X-Spam-Score: 0.133 X-Spam-Level: X-Archive-Number: 200604/21 X-Sequence-Number: 21190 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. > (We haven't caught up to the SQL2003 behavior yet, but I believe > Peter Eisentraut is working on it for PG 8.2.) I'm committing it now. Thanks for reminding me -- I had almost forgotten about that patch. :) -- Peter Eisentraut http://developer.postgresql.org/~petere/