From: Tom Lane <tgl@sss.pgh.pa.us>
To: =?UTF-8?B?Q2zDqW1lbnQgUHLDqXZvc3Q=?= <prevostclement@gmail.com>
cc: pgsql-docs@postgresql.org, Peter Eisentraut <peter_e@gmx.net>
Subject: Re: Documentation on information_ schema columns that does not exist
In-reply-to: 
 <CABaKae8+p6=zhCM=Qrq_GMN88pFqjb5EgHpy9bjGaKZfvJmzZA@mail.gmail.com>
References: 
 <CABaKae8+p6=zhCM=Qrq_GMN88pFqjb5EgHpy9bjGaKZfvJmzZA@mail.gmail.com>
Comments: In-reply-to =?UTF-8?B?Q2zDqW1lbnQgUHLDqXZvc3Q=?=
 <prevostclement@gmail.com>
 message dated "Sun, 31 May 2015 23:40:57 +0200"
Date: Sun, 31 May 2015 17:54:44 -0400
Message-ID: <32009.1433109284@sss.pgh.pa.us>
Precedence: bulk
Sender: pgsql-docs-owner@postgresql.org

=?UTF-8?B?Q2zDqW1lbnQgUHLDqXZvc3Q=?= <prevostclement@gmail.com> writes:
> 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

Yeah, that does seem like a copy-and-pasteo; there should only be 5
columns in the view according to the SQL standard and our code.

Another problem in the same area is that the column types of
foreign_table_schema and foreign_table_name seem to be "name":

# \d *.foreign_table_options
            View "information_schema.foreign_table_options"
        Column         |               Type                | Modifiers 
-----------------------+-----------------------------------+-----------
 foreign_table_catalog | information_schema.sql_identifier | 
 foreign_table_schema  | name                              | 
 foreign_table_name    | name                              | 
 option_name           | information_schema.sql_identifier | 
 option_value          | information_schema.character_data | 

The documentation claims these should be sql_identifier, and that's
what I'd expect in a SQL-standard view ...

			regards, tom lane


-- 
Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-docs