Brent Verner <brent(at)rcfile(dot)org> writes:
> After running the above and without (re)starting a new backend yields
> the following error. After getting a new backend, the behavior is as
> desired.
> brent=# insert into child values(1);
> ERROR: constraint <unnamed>: table parent does not have an attribute id
I wonder whether you're looking in the right place. The RI trigger code
caches query plans --- could that caching be the source of the problem?
(See backend/utils/adt/ri_triggers.c)
regards, tom lane