[Qgis-user] Database Manager and service configuration

[Andreas Neumann]

 Hi Giuseppe,

 I can confirm that the connection works now much faster. It is now a 
 pleasure to work with.

 I notice that the Preview of some (most?) views does not work. Is this 
 because the plugin does not know which column is the primary key? Should 
 I file a bug on this?

 Thanks a lot for your work!
 Andreas

 On Sun, 26 Feb 2012 18:13:31 +0100, Giuseppe Sucameli wrote:
> 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

-- 
 --
 Andreas Neumann
 Böschacherstrasse 10A
 8624 Grüt (Gossau ZH)
 Switzerland