On Sun, 10 Mar 2002, msn wrote:
> But then when I try to delete one id from t1 I get this error message.
>
> msn=# delete from t1 where id=1;
> ERROR: <unnamed> referential integrity violation - key referenced from t2
> not found in t1
>
> Why this fails to set columns t1_aid and t1_bid in table t2 to null?
Known problem with checking intermediate states of the table. It happens
here because there are two references to the same table. I sent a message
in response to a similar problem on -bugs that contained part of a patch
that may fix this problem for you.