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@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Reply via email to