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