Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1iluxS-0007qx-ND for pgsql-docs@arkaria.postgresql.org; Mon, 30 Dec 2019 13:19:42 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1iluxR-0007v5-1H for pgsql-docs@arkaria.postgresql.org; Mon, 30 Dec 2019 13:19:41 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1iluxQ-0007ux-Gw for pgsql-docs@lists.postgresql.org; Mon, 30 Dec 2019 13:19:40 +0000 Received: from momjian.us ([72.94.173.45]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1iluxN-0002PG-A1 for pgsql-docs@lists.postgresql.org; Mon, 30 Dec 2019 13:19:39 +0000 Received: from bruce by momjian.us with local (Exim 4.92) (envelope-from ) id 1iluxM-0000kv-EY; Mon, 30 Dec 2019 08:19:36 -0500 Date: Mon, 30 Dec 2019 08:19:36 -0500 From: Bruce Momjian To: mdemir4527@gmail.com, pgsql-docs@lists.postgresql.org Subject: Re: is_nullable column of information_schema.columns table Message-ID: <20191230131936.GA17407@momjian.us> References: <157756439102.1159.4361947883550826524@wrigleys.postgresql.org> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <157756439102.1159.4361947883550826524@wrigleys.postgresql.org> User-Agent: Mutt/1.10.1 (2018-07-13) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On Sat, Dec 28, 2019 at 08:19:51PM +0000, PG Doc comments form wrote: > The following documentation comment has been logged on the website: > > Page: https://www.postgresql.org/docs/12/infoschema-columns.html > Description: > > is_nullable column of information_schema.columns table does not show correct > values for columns of views. For tables that column shows correct values > whether a column is nullable or not. I think the documentation should > include this information although better solution is to correct that error. Can you show us an example query with the output? Thanks. Also, which Postgres version? -- Bruce Momjian http://momjian.us EnterpriseDB http://enterprisedb.com + As you are, so once was I. As I am, so you will be. + + Ancient Roman grave inscription +