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 be somewhere in pg_rewrite but where exactly and how do I get this information? Parse rewrite query_tree? How? -- Greg -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general