Re: [GENERAL] Constraints of view attributes

2017-05-11 Thread Tom Lane
<51183...@gmx.at> writes: > create table t1 (f1 text not null); > create table t2 (f2 text); > create view v as (select t1.f1, t2.f2 from t1, t2); > Given v, How can a find out the t1.f1 has a not null constraint. I assume what you actually mean is you want to know whether the view v will alw

Re: [GENERAL] Constraints of view attributes

2017-05-11 Thread Adrian Klaver
On 05/11/2017 12:24 PM, 51183...@gmx.at wrote: Hi, create table t1 (f1 text not null); create table t2 (f2 text); create view v as (select t1.f1, t2.f2 from t1, t2); Given v, How can a find out the t1.f1 has a not null constraint. I can easily find this for t1 in the system catalog, but not for

[GENERAL] Constraints of view attributes

2017-05-11 Thread 51183341
Hi, create table t1 (f1 text not null); create table t2 (f2 text); create view v as (select t1.f1, t2.f2 from t1, t2); Given v, How can a find out the t1.f1 has a not null constraint. I can easily find this for t1 in the system catalog, but not for v. I learned on IRC today that this should b