Finally solved the problem. I am using suhosin hardening patch and my complex reports are based on some long sql queries. My 'gets' were being limited to 512 characters, so once I increased this limit for suhosin, everything worked fine.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I get the following message when I try and run my reports:
<
SQL error:
ERROR: relation "<REPORT NAME>" does not exist
In statement:
SELECT COUNT(*) AS total FROM (SELECT "oid", * FROM "<REPORT NAME>") AS sub
>
If I run the report sql manually in psql I get no error messages at all, some of my reports work, some of them do not.
I am using V 4.1.1 against postgres 8.1.
I have been playing around with permissions.
Finally solved the problem. I am using suhosin hardening patch and my complex reports are based on some long sql queries. My 'gets' were being limited to 512 characters, so once I increased this limit for suhosin, everything worked fine.