{

char*otherObjDesc;

if (object_address_present(&otherObject,pendingObjects))

if (pendingObjects&&

object_address_present(&otherObject,pendingObjects))

{

systable_endscan(scan);

insert into rule_and_refint_t3 values (1, 12, 12, 'row4');

insert into rule_and_refint_t3 values (1, 11, 13, 'row5');

ERROR: insert or update on table "rule_and_refint_t3" violates foreign key constraint "rule_and_refint_t3_id3a_fkey1"

DETAIL: Key (id3a,id3c)=(1,13) is not present in table "rule_and_refint_t2".

DETAIL: Key (id3a,id3c)=(1,13) is not present in table "rule_and_refint_t2".

insert into rule_and_refint_t3 values (1, 13, 11, 'row6');

ERROR: insert or update on table "rule_and_refint_t3" violates foreign key constraint "rule_and_refint_t3_id3a_fkey"

DETAIL: Key (id3a,id3b)=(1,13) is not present in table "rule_and_refint_t1".

DETAIL: Key (id3a,id3b)=(1,13) is not present in table "rule_and_refint_t1".

create rule rule_and_refint_t3_ins as on insert to rule_and_refint_t3

where (exists (select 1 from rule_and_refint_t3

where (((rule_and_refint_t3.id3a = new.id3a)

and (rule_and_refint_t3.id3c = new.id3c));

insert into rule_and_refint_t3 values (1, 11, 13, 'row7');

ERROR: insert or update on table "rule_and_refint_t3" violates foreign key constraint "rule_and_refint_t3_id3a_fkey1"

DETAIL: Key (id3a,id3c)=(1,13) is not present in table "rule_and_refint_t2".

DETAIL: Key (id3a,id3c)=(1,13) is not present in table "rule_and_refint_t2".

insert into rule_and_refint_t3 values (1, 13, 11, 'row8');

ERROR: insert or update on table "rule_and_refint_t3" violates foreign key constraint "rule_and_refint_t3_id3a_fkey"

DETAIL: Key (id3a,id3b)=(1,13) is not present in table "rule_and_refint_t1".

DETAIL: Key (id3a, id3b)=(1, 13) is not present in table "rule_and_refint_t1".

--

-- disallow dropping a view's rule (bug #5072)

--

create view fooview as select 'foo'::text;

drop rule "_RETURN" on fooview;

ERROR: cannot drop rule _RETURN on view fooview because view fooview requires it

HINT: You can drop view fooview instead.

drop view fooview;

--

-- check for planner problems with complex inherited UPDATES

--

insert into rule_and_refint_t3values (1,11,13,'row7');

insert into rule_and_refint_t3values (1,13,11,'row8');

createviewfooviewasselect'foo'::text;

droprule"_RETURN"on fooview;

dropview fooview;