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
E: abruss@awrcorp.com
W: http://www.awrcorp.com