[QGIS-trac] [Quantum GIS] #1855: Postgis View Layers with OID as
primary key are loading very slow
Quantum GIS
qgis at qgis.org
Mon Aug 3 09:33:55 EDT 2009
#1855: Postgis View Layers with OID as primary key are loading very slow
--------------------------------+-------------------------------------------
Reporter: hdus | Owner: nobody
Type: bug | Status: new
Priority: minor: annoyance | Milestone: Version 1.2.0
Component: Data Provider | Version: HEAD
Keywords: | Platform_version:
Platform: All | Must_fix: Yes
Status_info: 0 |
--------------------------------+-------------------------------------------
I want to load a postgis view layer defined in a way that the OID
represents the primary key of the view query result. No real primary key
is defined in the source tables. When I query this view from psql it gives
me the query result very fast. When I load this layer into QGIS it needs a
very long time, more than 1 minute, to load this layer.
--
Ticket URL: <https://trac.osgeo.org/qgis/ticket/1855>
Quantum GIS <http://qgis.org>
Quantum GIS is an Open Source GIS viewer/editor supporting OGR, PostGIS, and GRASS formats
More information about the QGIS-trac
mailing list