Andrew - Supernews <andrew+nonews@xxxxxxxxxxxxx> writes: > Looking at current CVS code the RI check seems to be skipped on update of > the _referred to_ table if the old and new values match, but not on update > of the _referring_ table. No, both sides are supposed to be tested, see lines 3350-3395 in src/backend/commands/trigger.c. Or do you see something broken there? It works for me in a quick test. regards, tom lane