Re: RelationFlushRelation() or RelationClearRelation() - Mailing list pgsql-hackers

Brent Verner <brent@rcfile.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