Jaime Casanova <[EMAIL PROTECTED]> writes: > create rule ins_rule as on insert to v_foo do instead > insert into foo(col1, col2) values (new.col1, new.col2);
> insert into v_foo(col2) values (1); > this give an error like: > psql:f:/views.sql:13: ERROR: null value in column "col1" violates > not-null constraint That's not a bug, and "fixing" it isn't acceptable. The correct solution to the problem you are looking at is to attach default expressions to the view itself. Adding alter table v_foo alter col1 set default nextval('public.foo_col1_seq'); to your example makes it work as you wish. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq