Re: Database views metadata always nullable columns

Thanks guys for your feedback... I'll try to dig a bit more about how to
setup the EXPLAIN view "trick" scenario...
Regards,

2017-06-02 18:07 GMT+02:00 Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>:

> 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
>