<div dir="ltr"><div class="gmail_default" style="font-family:arial,helvetica,sans-serif"><br /></div><div
class="gmail_extra"><br/><div class="gmail_quote">On Tue, May 26, 2015 at 10:40 AM, Shekar Tippur <span
dir="ltr"><<ahref="mailto:ctippur@gmail.com" target="_blank">ctippur@gmail.com</a>></span> wrote:<br
/><blockquoteclass="gmail_quote" style="margin:0px 0px 0px
0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex"><div
dir="ltr"><divclass="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"><span class=""><p><span>create
tableC ( </span><p><span> "id" SERIAL PRIMARY KEY,</span><p><span> name
varchar(40)</span></span><p><span> ,b_id integer references B(id) DEFERRABLE INITIALLY DEFERRED NOT
NULL);</span><p><span><br/></span><p><span>I still get the same error:</span><p><span>insert into A (var1, var2) values
('Hello1','World1');</span><span class=""><p><span>ERROR: null value in column "b_id" violates not-null
constraint</span></span><p><span>DETAIL: Failing row contains (2, World1, null).</span><span
class=""><p><span>CONTEXT: SQL statement "INSERT INTO C (name, b_id) VALUES (NEW.var2,
b_id)"</span><p><p><span>PL/pgSQLfunction fn_test() line 17 at SQL
statement</span></span></div></div></blockquote></div><br/></div><div class="gmail_extra"><div class="gmail_default"
style="font-family:arial,helvetica,sans-serif">Becauseyou cannot defer a NOT NULL constraint.</div><div
class="gmail_default"style="font-family:arial,helvetica,sans-serif"><br /></div><div class="gmail_default"
style="font-family:arial,helvetica,sans-serif"><a
href="http://www.postgresql.org/docs/9.4/static/sql-set-constraints.html">http://www.postgresql.org/docs/9.4/static/sql-set-constraints.html</a></div><div
class="gmail_default"style="font-family:arial,helvetica,sans-serif"><br /></div><div class="gmail_default"
style="font-family:arial,helvetica,sans-serif">DavidJ.</div><br /></div></div>