Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1Tt671-0002lE-Cs for pgsql-docs@arkaria.postgresql.org; Thu, 10 Jan 2013 00:35:15 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.72) (envelope-from ) id 1Tt670-0001Iq-Oz for pgsql-docs@arkaria.postgresql.org; Thu, 10 Jan 2013 00:35:14 +0000 Received: from makus.postgresql.org ([98.129.198.125]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1Tt670-0001IX-3Y for pgsql-docs@postgresql.org; Thu, 10 Jan 2013 00:35:14 +0000 Received: from mail-we0-f181.google.com ([74.125.82.181]) by makus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1Tt66y-0005bD-Af for pgsql-docs@postgresql.org; Thu, 10 Jan 2013 00:35:13 +0000 Received: by mail-we0-f181.google.com with SMTP id t11so1348497wey.26 for ; Wed, 09 Jan 2013 16:35:11 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:date:message-id:subject:from:to:content-type; bh=nXOGlCW+KoBT48iwPOqOBkpIyu84WZnyzEawH0BSqbM=; b=qtDvV/9StbuAUyeDkrvCcCt4aa95HHz/oChq9HiuB3w4lsTd9xTOKxlaEpxrbYQamH GZK6CnXiMW6Gdm+p8ZkYUHWhx6Cne+17IMn3hu/bdkEW3BlZekp/Z9PCWqr3eAmHY+9L ZN/mXcNheRz63CudldsDNXW6n5swlxtiLwSCdA4cA3oiNbANacw4bAa7InrztrMRPKgt cthWY6c/u9TG9qwqzQ5b75c0bP7tviml/z6vkQua9dCUqL7KhGJY/fBqYUU1TarcUgMn 3s1GuVl9UkeM473p2u1h8SGRoPOkLz6gCI92MQzJos+7+6dAEHyL7a6mChOrQsBhat71 Aoiw== MIME-Version: 1.0 Received: by 10.180.93.41 with SMTP id cr9mr5618540wib.19.1357778111011; Wed, 09 Jan 2013 16:35:11 -0800 (PST) Received: by 10.227.13.66 with HTTP; Wed, 9 Jan 2013 16:35:10 -0800 (PST) Date: Thu, 10 Jan 2013 09:35:10 +0900 Message-ID: Subject: Small clarification in "34.41. schemata" From: Ian Lawrence Barwick To: pgsql-docs@postgresql.org Content-Type: text/plain; charset=UTF-8 X-Pg-Spam-Score: -2.6 (--) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-docs Precedence: bulk Sender: pgsql-docs-owner@postgresql.org The documentation says: The view schemata contains all schemas in the current database that are owned by a currently enabled role. ( http://www.postgresql.org/docs/9.2/static/infoschema-schemata.html ) However it shows all schemas if the user is a superuser, regardless of whether the schema is owned by the superuser. Does the documentation need clarifying? I'd suggest something like: The view schemata contains all schemas in the current database that are owned by a currently enabled role, or all schemas if the currently enabled role is a superuser. Regards Ian Lawrence Barwick -- Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-docs