PgAdmin3 1.8.0 Beta 3 r 6606 bug
От | Luiz K. Matsumura |
---|---|
Тема | PgAdmin3 1.8.0 Beta 3 r 6606 bug |
Дата | |
Msg-id | 46DD003A.2080604@planit.com.br обсуждение исходный текст |
Ответы |
Re: PgAdmin3 1.8.0 Beta 3 r 6606 bug
|
Список | pgadmin-support |
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"));
В списке pgadmin-support по дате отправления: