Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1YzAzF-0003eP-Ue for pgsql-docs@arkaria.postgresql.org; Sun, 31 May 2015 21:41:42 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1YzAzE-0007gF-2k for pgsql-docs@arkaria.postgresql.org; Sun, 31 May 2015 21:41:40 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:RSA_AES_256_CBC_SHA256:256) (Exim 4.80) (envelope-from ) id 1YzAzD-0007g8-3g for pgsql-docs@postgresql.org; Sun, 31 May 2015 21:41:39 +0000 Received: from mail-lb0-x232.google.com ([2a00:1450:4010:c04::232]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.84) (envelope-from ) id 1YzAz5-0000mK-NX for pgsql-docs@postgresql.org; Sun, 31 May 2015 21:41:37 +0000 Received: by lbcue7 with SMTP id ue7so74079316lbc.0 for ; Sun, 31 May 2015 14:41:27 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:from:date:message-id:subject:to:content-type; bh=MzwLwklKKb9oUVyTv/AwqluQasrW9nedtJarDaQJ1x0=; b=D/mEWrWTxEMYj0vwWTOhlNuMjT97ocRjEVyQjWiMqaydThgWgybPJvcL04jWa4eTJ/ lytoeO1hUWEF+dRe18NVHf/g5Blf0wx0VVFMCDc5G3218TPPMhWHtFjosqt5/XZORWBn 8b7UH0ed51OWRogbR8BGXH7GzNRjg7SJwszbiBdPFWRSPutA6gMJkFTn81Y909iVyjyI +S8FtXdBoCvGUSwbQarerfIKvorDJUuwosrPQOsw5v5CWgup6K2D2Ci3W3AZc+8owr1S uzyLYSHDjrndEdoPe1fsZl1XhQ//L/BDdD0tPqIanvqch4MhcVG0xdRm6980Y2KPnDHn rxiA== X-Received: by 10.112.199.35 with SMTP id jh3mr17889088lbc.23.1433108487780; Sun, 31 May 2015 14:41:27 -0700 (PDT) MIME-Version: 1.0 Received: by 10.112.3.101 with HTTP; Sun, 31 May 2015 14:40:57 -0700 (PDT) From: =?UTF-8?B?Q2zDqW1lbnQgUHLDqXZvc3Q=?= Date: Sun, 31 May 2015 23:40:57 +0200 Message-ID: Subject: Documentation on information_ schema columns that does not exist To: pgsql-docs@postgresql.org Content-Type: multipart/alternative; boundary=001a11c34a7a56c1fc0517679217 X-Pg-Spam-Score: -2.7 (--) 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 --001a11c34a7a56c1fc0517679217 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Hi, I found out that the following columns are documented (9.1->9.4) but not present in the information_schema table of my 9.4 instance (ubuntu): * information_schema.foreign_table_options.foreign_server_catalog * information_schema.foreign_table_options.foreign_server_name The source code (/src/backend/catalog/information_schema.sql) seems to confirm that those columns shouldn't exist. I'll be happy to help with a patch if it's indeed a documentation typo. regards, cl=C3=A9ment pr=C3=A9vost --001a11c34a7a56c1fc0517679217 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
Hi,

I found out that the following colu= mns are documented (9.1->9.4) but not present in the information_schema = table of my 9.4 instance (ubuntu):
* information_schema.foreign_t= able_options.foreign_server_catalog=C2=A0
* information_schema.fo= reign_table_options.foreign_server_name

The source= code=C2=A0(/src/backend/catalog/information_schema.sql) seems to confirm t= hat those columns shouldn't exist.

I'll be= happy to help with a patch if it's indeed a documentation typo.
<= div>
regards, cl=C3=A9ment pr=C3=A9vost

<= /div> --001a11c34a7a56c1fc0517679217--