[Qgis-user] Problem with "add postgis layers" in qgis 1.80

[Jürgen E. Fischer]

Hi Siegfried,

On Thu, 19. Jul 2012 at 07:14:31 +0200, Siegfried.Blank at lazbw.bwl.de wrote:
>    'add postgis layers" is very, very slowly in qgis 1.80 when I have many
>    tables. It needs several (up to 10) minutes until all tables where
>    "detecting" every time when I want add a postgis layer.

Check if your tables are in geometry_columns.  If not QGIS needs to determine
which geometry types are in table.  You can also use the "use estimated
metadata" in the connection settings to let qgis check only a few rows in the
tables which are not listed geometry_columns instead of all rows.

Jürgen

-- 
Jürgen E. Fischer         norBIT GmbH               Tel. +49-4931-918175-31
Dipl.-Inf. (FH)           Rheinstraße 13            Fax. +49-4931-918175-50
Software Engineer         D-26506 Norden               http://www.norbit.de
committ(ed|ing) to Quantum GIS                         IRC: jef on FreeNode                         

-- 
norBIT Gesellschaft fuer Unternehmensberatung und Informationssysteme mbH
Rheinstrasse 13, 26506 Norden
GF: Jelto Buurman, HR: Amtsgericht Emden, HRB 5502