public inbox for [email protected]  

help / color / mirror / Atom feed

is_nullable column of information_schema.columns table
3+ messages / 3 participants
[nested] [flat]

* is_nullable column of information_schema.columns table
@ 2019-12-28 20:19  PG Doc comments form <[email protected]>
  0 siblings, 2 replies; 3+ messages in thread

From: PG Doc comments form @ 2019-12-28 20:19 UTC (permalink / raw)
  To: [email protected]; +Cc: [email protected]

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.


^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: is_nullable column of information_schema.columns table
@ 2019-12-30 13:19  Bruce Momjian <[email protected]>
  parent: PG Doc comments form <[email protected]>
  1 sibling, 0 replies; 3+ messages in thread

From: Bruce Momjian @ 2019-12-30 13:19 UTC (permalink / raw)
  To: [email protected]; [email protected]

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  <[email protected]>        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 +





^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: is_nullable column of information_schema.columns table
@ 2020-01-07 10:41  Laurenz Albe <[email protected]>
  parent: PG Doc comments form <[email protected]>
  1 sibling, 0 replies; 3+ messages in thread

From: Laurenz Albe @ 2020-01-07 10:41 UTC (permalink / raw)
  To: [email protected]; [email protected]

On Sat, 2019-12-28 at 20:19 +0000, PG Doc comments form wrote:
> 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.

All columns of a view are defined as nullable, whether they can assume
that value or not.  PostgreSQL does not attempt to deduce the nullability
of columns from the view definition.

So the information in information_schema.columns is correct.
Remember that nullability does not imply that there are actually NULL values.

Yours,
Laurenz Albe
-- 
Cybertec | https://www.cybertec-postgresql.com







^ permalink  raw  reply  [nested|flat] 3+ messages in thread

end of thread, other threads:[~2020-01-07 10:41 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2019-12-28 20:19 is_nullable column of information_schema.columns table PG Doc comments form <[email protected]>
2019-12-30 13:19 ` Bruce Momjian <[email protected]>
2020-01-07 10:41 ` Laurenz Albe <[email protected]>

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox