Hi Andreas, On Sat, Feb 18, 2012 at 8:37 PM, Andreas Neumann <[email protected]> wrote: > Let me know when I can test something.
the first problem (slow connection) should be fixed [1], just use DBManager v0.1.17. I understand it was very annoying waiting for minutes before seeing something... I hope you can confirm it works now. I'm trying to fix also the other problem, the error displayed retrieving database privileges when a service is used to connect to the db. Regards. [1] http://hub.qgis.org/issues/5045 > On 02/18/2012 04:51 PM, Giuseppe Sucameli wrote: >> Hi Andreas, >> >> On Thu, Feb 16, 2012 at 5:59 PM, Andreas Neumann <[email protected]> wrote: >>> 1. >>> One issue I have is that opening db-manager takes 1-2 minutes (on a >>> rather fast machine). Why is it taking so long to open the connnection? >>> In main QGIS the connection opens quickly. My db has hundreds of spatial >>> tables and views in about 50 schemas. Is it scanning all schemas and >>> tables at the initial connection? >> >> I'm noticing the same, it's slow when the db has a lot of tables. >> I'm going deep inside the problem, I hope to fix it soon. >> >>> 2. >>> I get an error message after the connection: >>> ------------------- >>> Error: >>> database "an" does not exist >>> Query: >>> SELECT has_database_privilege('an', 'CREATE'), >>> has_database_privilege('an', 'TEMP') >>> ------------------- >>> >>> Why is it looking for a database named after the user connecting to the db? >> >> Because DBManager is trying to display information about the database >> (permissions), but you have no dbname as you're using a service to >> connect to it. >> >> Tickets opened for both the problems ([1] and [2]), >> Regards. >> >> [1] http://hub.qgis.org/issues/5044 >> [2] http://hub.qgis.org/issues/5045 -- Giuseppe Sucameli _______________________________________________ Qgis-user mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/qgis-user
