Re: Documentation on information_ schema columns that does not exist

From: Clément Prévost <prevostclement(at)gmail(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Peter Eisentraut <peter_e(at)gmx(dot)net>, pgsql-docs(at)postgresql(dot)org
Subject: Re: Documentation on information_ schema columns that does not exist
Date: 2015-05-31 23:25:13
Message-ID: CABaKae8UVSGwyQ-QFKxsk9obqyBpYOsCfgO_jNP_Y8iTJOuJxw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs

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 <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> 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 | column_name | name
> column_options | table_name | name
> column_options | table_schema | name
> foreign_table_options | foreign_table_name | name
> foreign_table_options | foreign_table_schema | name
> foreign_tables | foreign_table_name | name
> foreign_tables | foreign_table_schema | name
>
> regards, tom lane
>

Attachment Content-Type Size
conform-information-schema-foreign-table-column-type-to-spec.patch application/octet-stream 1.3 KB
remove-invalid-information-schema-doc.patch application/octet-stream 866 bytes

In response to

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message Clément Prévost 2015-06-01 00:27:16 Re: Documentation on information_ schema columns that does not exist
Previous Message Tom Lane 2015-05-31 22:14:31 Re: Documentation on information_ schema columns that does not exist