[check_postgres] bug in 2.18.0 ?

[Cindy Wise]

Hi,
I downloaded and installed check_postgres for the first time yesterday.
I kept getting this error:
./check_postgres_same_schema --dbname=template_us,cnuapp_dev
ERROR:  relation "contact_history_id_seq" does not exist


But, when I added this option, it finally worked: --filter=nosequence

In looking at the db logs, it queries the pg_type several times, then 
queries pg_class a few times, then this is the problem stmt:

2011-10-06 11:11:31 CDT LOG:  statement: BEGIN;SET 
statement_timeout=30000;COMMIT;SELECT * FROM contact_history_id_seq
2011-10-06 11:11:31 CDT ERROR:  relation "contact_history_id_seq" does 
not exist


I think the problem is that it needs the schemaname since the schema it 
is in is not in the user's search_path.


Thanks,

Cindy Wise
Database Developer
cwise at enovafinancial.com
im: cin319