foreach(lc,root->fkey_list)

{

ForeignKeyOptInfo*fkinfo= (ForeignKeyOptInfo*)lfirst(lc);

RelOptInfo*con_rel=find_base_rel(root,fkinfo->con_relid);

RelOptInfo*ref_rel=find_base_rel(root,fkinfo->ref_relid);

RelOptInfo*con_rel;

RelOptInfo*ref_rel;

intcolno;

if (fkinfo->con_relid >=root->simple_rel_array_size||

fkinfo->ref_relid >=root->simple_rel_array_size)

continue;/* just paranoia */

con_rel=root->simple_rel_array[fkinfo->con_relid];

if (con_rel==NULL)

continue;

ref_rel=root->simple_rel_array[fkinfo->ref_relid];

if (ref_rel==NULL)

continue;

ERROR: update or delete on table "pp" violates foreign key constraint "cc_f1_fkey" on table "cc"

DETAIL: Key (f1)=(13) is still referenced from table "cc".

drop table pp, cc;

--

-- Test interaction of foreign-key optimization with rules (bug #14219)

--

create temp table t1 (a integer primary key, b text);

create temp 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;

explain (costs off) delete from t1 where a = 1;

QUERY PLAN

--------------------------------------------

Delete on t2

-> Nested Loop

-> Index Scan using t1_pkey on t1

Index Cond: (a = 1)

-> Seq Scan on t2

Filter: (b = 1)

Delete on t1

-> Index Scan using t1_pkey on t1

Index Cond: (a = 1)

(10 rows)

delete from t1 where a = 1;

insert into ccvalues(13);

update ppset f1=f1+1;-- fail

droptable pp, cc;

create temp table t1 (aintegerprimary key, btext);

create temp table t2 (aintegerprimary key, bintegerreferences t1);

createruler1ason delete to t1 dodeletefrom t2wheret2.b=old.a;

explain (costs off)deletefrom t1where a=1;

deletefrom t1where a=1;