The following bug has been logged on the website:
Bug reference: 14219
Logged by: Andrew Gierth
Email address: andrew(at)tao11(dot)riddles(dot)org(dot)uk
PostgreSQL version: 9.6beta2
Operating system: any
Description:
(My analysis of a bug originally reported on IRC; please CC david.clymer at
vistashare.com)
I constructed this test case based on the original report:
create table t1 (a integer primary key, b text);
create table t2 (a integer primary key, b integer references t1);
create rule r1 as on delete to t1 do delete from t2 where t2.b=old.a;
delete from t1 where a=1;
ERROR: no relation entry for relid 2
The error is coming from match_foreign_keys_to_quals, but I haven't yet
investigated further.