Re: Bug in RI

At 21:13 21-9-00 -0700, Stephan Szabo wrote:
>This is a one line patch that will throw a notice with
>what relation name it's trying to open and what it
>got back in RI_FKey_keyequal_upd.  It should say
>the name of your table and a number, but I expect
>the number will be 0.

Yes, it is. So I also found the error: I did a rename table and the 
constraint triggers were not updated with the new table name.

Maybe a little check should be built in to check for fkey == 0, like this 
(from the top of my head, no actual checking):
        fk_rel = heap_openr(tgargs[RI_FK_RELNAME_ARGNO], NoLock);
+       if (fk_rel == NULL) {
+           elog(ERROR, "In foreign key constraint, cannot open relname: %s",
+               tgargs[RI_FK_RELNAME_ARGNO]);
+       }        pk_rel = trigdata->tg_relation;        new_row = trigdata->tg_newtuple;        old_row =
trigdata->tg_trigtuple;


Thanks for your help,


Jeroen