[Qgis-user] Database Manager and service configuration

[Giuseppe Sucameli]

Hi Andreas,

On Sat, Feb 18, 2012 at 8:37 PM, Andreas Neumann <a.neumann at carto.net> 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 <a.neumann at carto.net> 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