Re: [DOCS] Documentation on information_ schema columns that does not exist

2016-08-07 Thread Peter Eisentraut
On 8/3/16 3:27 PM, Tom Lane wrote: > Peter Eisentraut writes: >> On 5/31/15 8:27 PM, Clément Prévost wrote: >>> Here is another patch to fix the name of the column >>> information_schema.routines.result_cast_char_set_name that was >>> mistakenly named result_cast_character_set_name. > >> This o

Re: [DOCS] Documentation on information_ schema columns that does not exist

2016-08-03 Thread Tom Lane
Peter Eisentraut writes: > On 5/31/15 8:27 PM, Clément Prévost wrote: >> Here is another patch to fix the name of the column >> information_schema.routines.result_cast_char_set_name that was >> mistakenly named result_cast_character_set_name. > This one is actually named result_cast_character_s

Re: [DOCS] Documentation on information_ schema columns that does not exist

2016-08-03 Thread Peter Eisentraut
On 5/31/15 8:27 PM, Clément Prévost wrote: > Here is another patch to fix the name of the column > information_schema.routines.result_cast_char_set_name that was > mistakenly named result_cast_character_set_name. This one is actually named result_cast_character_set_name in the standard, although t

Re: [DOCS] Documentation on information_ schema columns that does not exist

2016-08-03 Thread Peter Eisentraut
On 5/31/15 7:25 PM, Clément Prévost wrote: > I attached 2 patches: 1 to fix erroneous documentation and the other to > fix information schema types. I have fixed these two. -- Peter Eisentraut http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & S

Re: [DOCS] Documentation on information_ schema columns that does not exist

2015-05-31 Thread Clément Prévost
Here is another patch to fix the name of the column information_schema.routines.result_cast_char_set_name that was mistakenly named result_cast_character_set_name. regards, clément prévost On 1 June 2015 at 01:25, Clément Prévost wrote: > Well spotted! > > I attached 2 patches: 1 to fix erroneo

Re: [DOCS] Documentation on information_ schema columns that does not exist

2015-05-31 Thread Clément Prévost
Well spotted! I attached 2 patches: 1 to fix erroneous documentation and the other to fix information schema types. regards, clément prévost On 1 June 2015 at 00:14, Tom Lane wrote: > I wrote: > > Another problem in the same area is that the column types of > > foreign_table_schema and foreign

Re: [DOCS] Documentation on information_ schema columns that does not exist

2015-05-31 Thread Tom Lane
I wrote: > Another problem in the same area is that the column types of > foreign_table_schema and foreign_table_name seem to be "name": Further pursuant to that, these are the information_schema columns that don't seem to have been cast to the spec-required type: column_options| col

Re: [DOCS] Documentation on information_ schema columns that does not exist

2015-05-31 Thread Tom Lane
=?UTF-8?B?Q2zDqW1lbnQgUHLDqXZvc3Q=?= 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_op