Hi,
I'm getting this error when trying to select from a table:
"8 trigger record(s) not found for relation managements"
Looking into this a little, I found this page
http://www.postgresql.org/docs/8.0/static/catalog-pg-trigger.html that
says:
Note: pg_class.reltriggers needs to agree with the number of triggers
found in this table for the given relation.
And, indeed:
select reltriggers FROM pg_class where relname='managements';
Returns 68
And this (16460 is the managements table oid):
select * from pg_trigger where tgrelid=16460;
Returns 60
Does anyone have an idea about what could cause this or how to fix it?
Thanks,
Reuven
