Hi,
I downloaded the last snapshot on Dave page (svn rev 6606).
This version don't work with postgres 8.1 and 8.0.
I think that error is caused by a modification in pgDatabase.c
I try to find an equivalent query but I not sure if this is correct,
please see if this will work fine.
Hope this can help.
Regards
--
Luiz K. Matsumura
Plan IT Tecnologia Informática Ltda.
Index: H:/svn/pgadmin3/pgadmin3/pgadmin/schema/pgDatabase.cpp
===================================================================
--- H:/svn/pgadmin3/pgadmin3/pgadmin/schema/pgDatabase.cpp (revision 6607)
+++ H:/svn/pgadmin3/pgadmin3/pgadmin/schema/pgDatabase.cpp (working copy)
@@ -492,8 +492,8 @@
wxT("SELECT db.oid, datname, spcname, datallowconn, datconfig, datacl, ")
wxT("pg_encoding_to_char(encoding) AS serverencoding, pg_get_userbyid(datdba) AS datowner,")
wxT("has_database_privilege(db.oid, 'CREATE') as cancreate, \n")
- wxT("(select setting AS default_tablespace from pg_show_all_settings() x(name text, setting text, unit
text,category text, short_desc text, extra_desc text, context text, vartype text, source text, min_val text, max_val
text)where name = 'default_tablespace') AS default_tablespace\n")
- wxT(" FROM pg_database db\n")
+ wxT("select current_setting('default_tablespace') AS default_tablespace\n")
+ wxT(" FROM pg_database db\n")
wxT(" LEFT OUTER JOIN pg_tablespace ta ON db.dattablespace=ta.OID\n")
+ restr +
wxT(" ORDER BY datname"));