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

-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Reply via email to