<div dir="ltr"><div class="gmail_extra">Marc,</div><div class="gmail_extra"><br /></div><div class="gmail_extra">I have
changedthe table C:</div><div class="gmail_extra"><br /></div><div class="gmail_extra"><p class=""><span
class="">createtable C ( </span><p class=""><span class=""> "id" SERIAL PRIMARY
KEY,</span><pclass=""><span class=""> name varchar(40)</span><p class=""><span class=""> , b_id integer references
B(id)DEFERRABLE INITIALLY DEFERRED NOT NULL);</span><p class=""><span class=""><br /></span><p class=""><span
class="">Istill get the same error:</span><p class=""><span class="">insert into A (var1, var2) values ('Hello1',
'World1');</span><pclass=""><span class="">ERROR: null value in column "b_id" violates not-null constraint</span><p
class=""><spanclass="">DETAIL: Failing row contains (2, World1, null).</span><p class=""><span class="">CONTEXT: SQL
statement"INSERT INTO C (name, b_id) VALUES (NEW.var2, b_id)"</span><p class=""><p class=""><span class="">PL/pgSQL
functionfn_test() line 17 at SQL statement</span></div></div>