Search Postgresql Archives

8 trigger record(s) not found for relation managements

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux