8 trigger record(s) not found for relation managements
От
rh
Тема
8 trigger record(s) not found for relation managements
Дата
Msg-id
229682d2-4e18-4d8c-ba77-caa287a2efa9@t2g2000yqe.googlegroups.com
Список
Дерево обсуждения
8 trigger record(s) not found for relation managements rh <reuvenharrison@gmail.com>
Re: 8 trigger record(s) not found for relation managements Alvaro Herrera <alvherre@commandprompt.com>
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
В списке pgsql-general по дате отправления