Re: referential integrity constraints not checked inside PL/pgSQL functions? - Mailing list pgsql-general

From Christopher Browne
Subject Re: referential integrity constraints not checked inside PL/pgSQL functions?
Date
Msg-id m3ad0cv8p1.fsf@wolfe.cbbrowne.com
Whole thread Raw
In response to referential integrity constraints not checked inside PL/pgSQL functions?  (Christian Rank <christian.rank@rz.uni-passau.de>)
List pgsql-general
Supposing you drop the "delete from b;" from the function, you'll find
that the function fails with much the same error message you had
before.

Evidently that foreign key check gets _deferred_ in the context of the
stored procedure.  It is indeed checked; just not at the point you
expect it to be checked at.
--
select 'cbbrowne' || '@' || 'ntlug.org';
http://www3.sympatico.ca/cbbrowne/advocacy.html
Rules  of  the  Evil  Overlord  #89.  "After  I  captures  the  hero's
superweapon, I  will not immediately  disband my legions and  relax my
guard because I believe whoever holds the weapon is unstoppable. After
all,   the  hero  held   the  weapon   and  I   took  it   from  him."
<http://www.eviloverlord.com/>

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: pg_xlog becomes extremely large during CREATE INDEX
Next
From: Tom Lane
Date:
Subject: Re: referential integrity constraints not checked inside