Re: Database views metadata always nullable columns

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: basuraspam - <basuraspam0(at)gmail(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Database views metadata always nullable columns
Date: 2017-06-02 16:07:17
Message-ID: 23126.1496419637@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

basuraspam - <basuraspam0(at)gmail(dot)com> writes:
> I agree, it would be better including an example. The "issue" I reported
> is with database views not with tables. Taking your example as base:

> create table foo (f1 int, f2 int not null);
> create view foo_view as select * from foo;

Ah, gotcha. No, sorry, we do not track nullability of view columns as
such.

regards, tom lane

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message anand086 2017-06-02 17:29:22 Re: Using bind variable within BEGIN END
Previous Message David G. Johnston 2017-06-02 15:59:12 Re: Database views metadata always nullable columns