MIME-Version: 1.0
In-Reply-To: <32511.1433110471@sss.pgh.pa.us>
References: 
 <CABaKae8+p6=zhCM=Qrq_GMN88pFqjb5EgHpy9bjGaKZfvJmzZA@mail.gmail.com>
 <32009.1433109284@sss.pgh.pa.us> <32511.1433110471@sss.pgh.pa.us>
From: =?UTF-8?B?Q2zDqW1lbnQgUHLDqXZvc3Q=?= <prevostclement@gmail.com>
Date: Mon, 1 Jun 2015 01:25:13 +0200
Message-ID: 
 <CABaKae8UVSGwyQ-QFKxsk9obqyBpYOsCfgO_jNP_Y8iTJOuJxw@mail.gmail.com>
Subject: Re: Documentation on information_ schema columns that does not exist
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Peter Eisentraut <peter_e@gmx.net>, pgsql-docs@postgresql.org
Content-Type: multipart/mixed; boundary=001a1134d9103c80060517690736
Precedence: bulk
Sender: pgsql-docs-owner@postgresql.org

--001a1134d9103c80060517690736
Content-Type: multipart/alternative; boundary=001a1134d9103c80000517690734

--001a1134d9103c80000517690734
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

Well spotted!

I attached 2 patches: 1 to fix erroneous documentation and the other to fix
information schema types.

regards, cl=C3=A9ment pr=C3=A9vost

On 1 June 2015 at 00:14, Tom Lane <tgl@sss.pgh.pa.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
>

--001a1134d9103c80000517690734
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div>Well spotted!</div><div><br></div><div>I attached 2 p=
atches: 1 to fix erroneous documentation and the other to fix information s=
chema types.<br></div><div class=3D"gmail_extra"><br></div><div class=3D"gm=
ail_extra">regards, cl=C3=A9ment pr=C3=A9vost</div><div class=3D"gmail_extr=
a"><br><div class=3D"gmail_quote">On 1 June 2015 at 00:14, Tom Lane <span d=
ir=3D"ltr">&lt;<a href=3D"mailto:tgl@sss.pgh.pa.us" target=3D"_blank">tgl@s=
ss.pgh.pa.us</a>&gt;</span> wrote:<br><blockquote class=3D"gmail_quote" sty=
le=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><span>=
I wrote:<br>
&gt; Another problem in the same area is that the column types of<br>
&gt; foreign_table_schema and foreign_table_name seem to be &quot;name&quot=
;:<br>
<br>
</span>Further pursuant to that, these are the information_schema columns<b=
r>
that don&#39;t seem to have been cast to the spec-required type:<br>
<br>
=C2=A0column_options=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 | column_name=
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 | name<br>
=C2=A0column_options=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 | table_name=
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0| name<br>
=C2=A0column_options=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 | table_schem=
a=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0| name<br>
=C2=A0foreign_table_options=C2=A0 =C2=A0 =C2=A0| foreign_table_name=C2=A0 =
=C2=A0| name<br>
=C2=A0foreign_table_options=C2=A0 =C2=A0 =C2=A0| foreign_table_schema | nam=
e<br>
=C2=A0foreign_tables=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 | foreign_tab=
le_name=C2=A0 =C2=A0| name<br>
=C2=A0foreign_tables=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 | foreign_tab=
le_schema | name<br>
<br>
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=
=A0 =C2=A0 regards, tom lane<br>
</blockquote></div><br></div></div>

--001a1134d9103c80000517690734--

--001a1134d9103c80060517690736
Content-Type: application/octet-stream;
 name="conform-information-schema-foreign-table-column-type-to-spec.patch"
Content-Disposition: attachment;
 filename="conform-information-schema-foreign-table-column-type-to-spec.patch"
Content-Transfer-Encoding: base64
X-Attachment-Id: f_iad329uo0

ZGlmZiAtLWdpdCBhL3NyYy9iYWNrZW5kL2NhdGFsb2cvaW5mb3JtYXRpb25f
c2NoZW1hLnNxbCBiL3NyYy9iYWNrZW5kL2NhdGFsb2cvaW5mb3JtYXRpb25f
c2NoZW1hLnNxbAppbmRleCA2ZTFiMjQxLi41ZWZlZDRmIDEwMDY0NAotLS0g
YS9zcmMvYmFja2VuZC9jYXRhbG9nL2luZm9ybWF0aW9uX3NjaGVtYS5zcWwK
KysrIGIvc3JjL2JhY2tlbmQvY2F0YWxvZy9pbmZvcm1hdGlvbl9zY2hlbWEu
c3FsCkBAIC0yNzEzLDkgKzI3MTMsOSBAQCBHUkFOVCBTRUxFQ1QgT04gZWxl
bWVudF90eXBlcyBUTyBQVUJMSUM7CiAKIC8qIEJhc2UgdmlldyBmb3IgZm9y
ZWlnbiB0YWJsZSBjb2x1bW5zICovCiBDUkVBVEUgVklFVyBfcGdfZm9yZWln
bl90YWJsZV9jb2x1bW5zIEFTCi0gICAgU0VMRUNUIG4ubnNwbmFtZSwKLSAg
ICAgICAgICAgYy5yZWxuYW1lLAotICAgICAgICAgICBhLmF0dG5hbWUsCisg
ICAgU0VMRUNUIENBU1Qobi5uc3BuYW1lIEFTIHNxbF9pZGVudGlmaWVyKSBB
UyBuc3BuYW1lLAorICAgICAgICAgICBDQVNUKGMucmVsbmFtZSBBUyBzcWxf
aWRlbnRpZmllcikgQVMgcmVsbmFtZSwKKyAgICAgICAgICAgQ0FTVChhLmF0
dG5hbWUgQVMgc3FsX2lkZW50aWZpZXIpIEFTIGF0dG5hbWUsCiAgICAgICAg
ICAgIGEuYXR0ZmR3b3B0aW9ucwogICAgIEZST00gcGdfZm9yZWlnbl90YWJs
ZSB0LCBwZ19hdXRoaWQgdSwgcGdfbmFtZXNwYWNlIG4sIHBnX2NsYXNzIGMs
CiAgICAgICAgICBwZ19hdHRyaWJ1dGUgYQpAQCAtMjg0MSw4ICsyODQxLDgg
QEAgR1JBTlQgU0VMRUNUIE9OIGZvcmVpZ25fc2VydmVycyBUTyBQVUJMSUM7
CiBDUkVBVEUgVklFVyBfcGdfZm9yZWlnbl90YWJsZXMgQVMKICAgICBTRUxF
Q1QKICAgICAgICAgICAgQ0FTVChjdXJyZW50X2RhdGFiYXNlKCkgQVMgc3Fs
X2lkZW50aWZpZXIpIEFTIGZvcmVpZ25fdGFibGVfY2F0YWxvZywKLSAgICAg
ICAgICAgbi5uc3BuYW1lIEFTIGZvcmVpZ25fdGFibGVfc2NoZW1hLAotICAg
ICAgICAgICBjLnJlbG5hbWUgQVMgZm9yZWlnbl90YWJsZV9uYW1lLAorICAg
ICAgICAgICBDQVNUKG4ubnNwbmFtZSBBUyBzcWxfaWRlbnRpZmllcikgQVMg
Zm9yZWlnbl90YWJsZV9zY2hlbWEsCisgICAgICAgICAgIENBU1QoYy5yZWxu
YW1lIEFTIHNxbF9pZGVudGlmaWVyKSBBUyBmb3JlaWduX3RhYmxlX25hbWUs
CiAgICAgICAgICAgIHQuZnRvcHRpb25zIEFTIGZ0b3B0aW9ucywKICAgICAg
ICAgICAgQ0FTVChjdXJyZW50X2RhdGFiYXNlKCkgQVMgc3FsX2lkZW50aWZp
ZXIpIEFTIGZvcmVpZ25fc2VydmVyX2NhdGFsb2csCiAgICAgICAgICAgIENB
U1Qoc3J2bmFtZSBBUyBzcWxfaWRlbnRpZmllcikgQVMgZm9yZWlnbl9zZXJ2
ZXJfbmFtZSwK

--001a1134d9103c80060517690736
Content-Type: application/octet-stream;
 name="remove-invalid-information-schema-doc.patch"
Content-Disposition: attachment;
 filename="remove-invalid-information-schema-doc.patch"
Content-Transfer-Encoding: base64
X-Attachment-Id: f_iad329vf1

ZGlmZiAtLWdpdCBhL2RvYy9zcmMvc2dtbC9pbmZvcm1hdGlvbl9zY2hlbWEu
c2dtbCBiL2RvYy9zcmMvc2dtbC9pbmZvcm1hdGlvbl9zY2hlbWEuc2dtbApp
bmRleCBjYTFmMjBiLi5jNmU2YzlkIDEwMDY0NAotLS0gYS9kb2Mvc3JjL3Nn
bWwvaW5mb3JtYXRpb25fc2NoZW1hLnNnbWwKKysrIGIvZG9jL3NyYy9zZ21s
L2luZm9ybWF0aW9uX3NjaGVtYS5zZ21sCkBAIC0yODk4LDE4ICsyODk4LDYg
QEAgT1JERVIgQlkgYy5vcmRpbmFsX3Bvc2l0aW9uOwogICAgICA8L3Jvdz4K
IAogICAgICA8cm93PgotICAgICAgPGVudHJ5PjxsaXRlcmFsPmZvcmVpZ25f
c2VydmVyX2NhdGFsb2c8L2xpdGVyYWw+PC9lbnRyeT4KLSAgICAgIDxlbnRy
eT48dHlwZT5zcWxfaWRlbnRpZmllcjwvdHlwZT48L2VudHJ5PgotICAgICAg
PGVudHJ5Pk5hbWUgb2YgdGhlIGRhdGFiYXNlIHRoYXQgdGhlIGZvcmVpZ24g
c2VydmVyIGlzIGRlZmluZWQgaW4gKGFsd2F5cyB0aGUgY3VycmVudCBkYXRh
YmFzZSk8L2VudHJ5PgotICAgICA8L3Jvdz4KLQotICAgICA8cm93PgotICAg
ICAgPGVudHJ5PjxsaXRlcmFsPmZvcmVpZ25fc2VydmVyX25hbWU8L2xpdGVy
YWw+PC9lbnRyeT4KLSAgICAgIDxlbnRyeT48dHlwZT5zcWxfaWRlbnRpZmll
cjwvdHlwZT48L2VudHJ5PgotICAgICAgPGVudHJ5Pk5hbWUgb2YgdGhlIGZv
cmVpZ24gc2VydmVyPC9lbnRyeT4KLSAgICAgPC9yb3c+Ci0KLSAgICAgPHJv
dz4KICAgICAgIDxlbnRyeT48bGl0ZXJhbD5vcHRpb25fbmFtZTwvbGl0ZXJh
bD48L2VudHJ5PgogICAgICAgPGVudHJ5Pjx0eXBlPnNxbF9pZGVudGlmaWVy
PC90eXBlPjwvZW50cnk+CiAgICAgICA8ZW50cnk+TmFtZSBvZiBhbiBvcHRp
b248L2VudHJ5Pgo=

--001a1134d9103c80060517690736
Content-Type: text/plain
Content-Disposition: inline
Content-Transfer-Encoding: 8bit
MIME-Version: 1.0


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

--001a1134d9103c80060517690736--