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"));
---------------------------(end of broadcast)---------------------------
TIP 7: You can help support the PostgreSQL project by donating at
http://www.postgresql.org/about/donate
