Skip site navigation (1) Skip section navigation (2)

Re: thw rewriter and default values, again

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Jaime Casanova <systemguards(at)gmail(dot)com>
Cc: Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: thw rewriter and default values, again
Date: 2005-05-28 15:23:30
Message-ID: 7714.1117293810@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackers
Jaime Casanova <systemguards(at)gmail(dot)com> 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

In response to

Responses

pgsql-hackers by date

Next:From: Jaime CasanovaDate: 2005-05-28 16:36:46
Subject: Re: thw rewriter and default values, again
Previous:From: Greg StarkDate: 2005-05-28 14:25:48
Subject: Re: thw rewriter and default values, again

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group