On 5/28/05, Tom Lane <[EMAIL PROTECTED]> wrote:
> 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.
> 
I know you're right, but -when dealing with updateable views- doing
that implies to add a lot of time altering views when base table
change, and of course we maybe don't want all views get that values.

-- 
regards,
Jaime Casanova
(DBA: DataBase Aniquilator ;)

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
      subscribe-nomail command to [EMAIL PROTECTED] so that your
      message can get through to the mailing list cleanly

Reply via email to