|
Hello and thanks for this great application named pgql. I’ve setup pg on a windows machine and have installed phppgadmin. The phppgadmin php application comes up correctly in a browser but I get an error message when viewing the databases. The apache log shows this: “[Wed Dec 22 10:27:34 2010] [error] [client 127.0.0.1] PHP Fatal error: Call to a member function recordCount() on a non-object in C:\\Program Files (x86)\\PostgreSQL\\EnterpriseDB-ApachePhp\\apache\\www\\phpPgAdmin\\classes\\Misc.php
on line 1805, referer: http://localhost:81/phpPgAdmin/browser.php” And the webpage shows this: “SQL error: ERROR: could not stat file "base/16396/16397": Permission denied In statement: SELECT pdb.datname AS datname, pr.rolname AS datowner, pg_encoding_to_char(encoding) AS datencoding, (SELECT description FROM pg_catalog.pg_shdescription pd WHERE pdb.oid=pd.objoid) AS datcomment, (SELECT spcname FROM pg_catalog.pg_tablespace pt WHERE pt.oid=pdb.dattablespace) AS tablespace, CASE WHEN pg_catalog.has_database_privilege(current_user, pdb.oid, 'CONNECT')
THEN pg_catalog.pg_database_size(pdb.oid)
ELSE NULL END as dbsize
FROM pg_catalog.pg_database pdb LEFT JOIN pg_catalog.pg_roles pr ON (pdb.datdba = pr.oid) WHERE true
AND NOT pdb.datistemplate
ORDER BY pdb.datname” I’m running on Windows 7 x64. On a side note I’ve been using the pgql command line tool and pgadmin 3 for a few days without any problems. Thanks, Adam Adam Bruss Development Engineer AWR Corporation/Simulation Technology & Applied Research 11520 N. Port Washington Rd., Suite 201 Mequon, WI 53092 USA P: 1.262.240.0291 x104 F: 1.262.240.0294 |
