Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1YzDaC-0000sU-I6 for pgsql-docs@arkaria.postgresql.org; Mon, 01 Jun 2015 00:28:00 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1YzDaB-0003jX-6g for pgsql-docs@arkaria.postgresql.org; Mon, 01 Jun 2015 00:27:59 +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 1YzDa9-0003jO-5J for pgsql-docs@postgresql.org; Mon, 01 Jun 2015 00:27:57 +0000 Received: from mail-la0-x22f.google.com ([2a00:1450:4010:c03::22f]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.84) (envelope-from ) id 1YzDa1-0003q1-Ib for pgsql-docs@postgresql.org; Mon, 01 Jun 2015 00:27:55 +0000 Received: by labko7 with SMTP id ko7so86461041lab.2 for ; Sun, 31 May 2015 17:27:47 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:in-reply-to:references:from:date:message-id:subject:to :cc:content-type; bh=I3ZkmyCHLWo06hDfYy//OHMwz+bhhB0oPvbLXQ8s2YY=; b=TlVQfqwbu1bfRm/9qQjQCINWRW1usXKS/6NFFMTNeDdUtYSRaxCcJ9qwYVymwiKuog MnYRowdgRba4lj7QTawThh2tkWMvaeYMYXUvtLBTRdP1x+rOtPKzgOQHjqntkTyZo56H Y/2MRgIacGaSjx8EnksBuAeTYw9kNl77hdgB/uYETboHIPsuLHaTH8pEqZuCbePC9RSe LjX2PHOKYiginVU1hFWI+7qiU3kmdiUCZCg1mKfA8cKoMXgRwduJB/u/sgDkRouv5goz PrJbiAj8lneWVl6KpvBc+xZ15mPs7FCsUkCZr6ZH5MN5GZ7RaXyj27+7UkLet+ggDU8G Bebg== X-Received: by 10.152.43.37 with SMTP id t5mr18038790lal.96.1433118467438; Sun, 31 May 2015 17:27:47 -0700 (PDT) MIME-Version: 1.0 Received: by 10.112.3.101 with HTTP; Sun, 31 May 2015 17:27:16 -0700 (PDT) In-Reply-To: References: <32009.1433109284@sss.pgh.pa.us> <32511.1433110471@sss.pgh.pa.us> From: =?UTF-8?B?Q2zDqW1lbnQgUHLDqXZvc3Q=?= Date: Mon, 1 Jun 2015 02:27:16 +0200 Message-ID: Subject: Re: Documentation on information_ schema columns that does not exist To: Tom Lane Cc: Peter Eisentraut , pgsql-docs@postgresql.org Content-Type: multipart/mixed; boundary=001a11c34eb42c9f52051769e515 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 --001a11c34eb42c9f52051769e515 Content-Type: multipart/alternative; boundary=001a11c34eb42c9f4c051769e513 --001a11c34eb42c9f4c051769e513 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable 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=C3=A9ment pr=C3=A9vost On 1 June 2015 at 01:25, Cl=C3=A9ment Pr=C3=A9vost wrote: > 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 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 >> > > --001a11c34eb42c9f4c051769e513 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
Here is another patch to fix the name of the column i= nformation_schema.routines.result_cast_char_set_name that was mistakenly na= med=C2=A0result_cast_character_set_name.

regar= ds, cl=C3=A9ment pr=C3=A9vost

On 1 June 2015 at 01:25, Cl=C3=A9ment Pr=C3=A9= vost <prevostclement@gmail.com> wrote:
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> wrot= e:
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:

=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
=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
=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
=C2=A0foreign_table_options=C2=A0 =C2=A0 =C2=A0| foreign_table_name=C2=A0 = =C2=A0| name
=C2=A0foreign_table_options=C2=A0 =C2=A0 =C2=A0| foreign_table_schema | nam= e
=C2=A0foreign_tables=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 | foreign_tab= le_name=C2=A0 =C2=A0| name
=C2=A0foreign_tables=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 | foreign_tab= le_schema | name

=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


--001a11c34eb42c9f4c051769e513-- --001a11c34eb42c9f52051769e515 Content-Type: application/octet-stream; name="conform-information-schema-routines-unused-field-to-spec.patch" Content-Disposition: attachment; filename="conform-information-schema-routines-unused-field-to-spec.patch" Content-Transfer-Encoding: base64 X-Attachment-Id: f_iad5m3uz2 ZGlmZiAtLWdpdCBhL3NyYy9iYWNrZW5kL2NhdGFsb2cvaW5mb3JtYXRpb25f c2NoZW1hLnNxbCBiL3NyYy9iYWNrZW5kL2NhdGFsb2cvaW5mb3JtYXRpb25f c2NoZW1hLnNxbAppbmRleCBiN2FhM2UzLi41ZWZlZDRmIDEwMDY0NAotLS0g YS9zcmMvYmFja2VuZC9jYXRhbG9nL2luZm9ybWF0aW9uX3NjaGVtYS5zcWwK KysrIGIvc3JjL2JhY2tlbmQvY2F0YWxvZy9pbmZvcm1hdGlvbl9zY2hlbWEu c3FsCkBAIC0xNDYzLDcgKzE0NjMsNyBAQCBDUkVBVEUgVklFVyByb3V0aW5l cyBBUwogICAgICAgICAgICBDQVNUKG51bGwgQVMgY2FyZGluYWxfbnVtYmVy KSBBUyByZXN1bHRfY2FzdF9jaGFyX29jdGV0X2xlbmd0aCwKICAgICAgICAg ICAgQ0FTVChudWxsIEFTIHNxbF9pZGVudGlmaWVyKSBBUyByZXN1bHRfY2Fz dF9jaGFyX3NldF9jYXRhbG9nLAogICAgICAgICAgICBDQVNUKG51bGwgQVMg c3FsX2lkZW50aWZpZXIpIEFTIHJlc3VsdF9jYXN0X2NoYXJfc2V0X3NjaGVt YSwKLSAgICAgICAgICAgQ0FTVChudWxsIEFTIHNxbF9pZGVudGlmaWVyKSBB UyByZXN1bHRfY2FzdF9jaGFyYWN0ZXJfc2V0X25hbWUsCisgICAgICAgICAg IENBU1QobnVsbCBBUyBzcWxfaWRlbnRpZmllcikgQVMgcmVzdWx0X2Nhc3Rf Y2hhcl9zZXRfbmFtZSwKICAgICAgICAgICAgQ0FTVChudWxsIEFTIHNxbF9p ZGVudGlmaWVyKSBBUyByZXN1bHRfY2FzdF9jb2xsYXRpb25fY2F0YWxvZywK ICAgICAgICAgICAgQ0FTVChudWxsIEFTIHNxbF9pZGVudGlmaWVyKSBBUyBy ZXN1bHRfY2FzdF9jb2xsYXRpb25fc2NoZW1hLAogICAgICAgICAgICBDQVNU KG51bGwgQVMgc3FsX2lkZW50aWZpZXIpIEFTIHJlc3VsdF9jYXN0X2NvbGxh dGlvbl9uYW1lLAo= --001a11c34eb42c9f52051769e515 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 --001a11c34eb42c9f52051769e515--