[QGIS-trac] [Quantum GIS] #2555: QGis show attribute table empty with postgres

Quantum GIS qgis at qgis.org
Mon Mar 15 14:58:00 EDT 2010


#2555: QGis show attribute table empty with postgres
------------------------------------------------+---------------------------
   Reporter:  aperi2007                         |              Owner:  nobody       
       Type:  bug                               |             Status:  new          
   Priority:  major: does not work as expected  |          Milestone:  Version 1.5.0
  Component:  Data Provider                     |            Version:  HEAD         
   Keywords:                                    |   Platform_version:  7            
   Platform:  Windows                           |           Must_fix:  No           
Status_info:  0                                 |  
------------------------------------------------+---------------------------
 Using this code to create and fill a table on postgres:

 DROP TABLE IF EXISTS public.a_multilines;
 CREATE TABLE public.a_multilines ( id serial PRIMARY KEY, codice
 VARCHAR(50), classe VARCHAR(50));
 SELECT AddGeometryColumn( 'public','a_multilines', 'geom', 3003,
 'MULTILINESTRING', 2 );

 DROP INDEX IF EXISTS public.idx_geom_gist_a_multilines;
 CREATE INDEX idx_geom_gist_a_multilines ON public.a_multilines using gist
 ("geom" gist_geometry_ops);

 DROP INDEX IF EXISTS public.idx_codice_a_multilines;
 CREATE INDEX idx_codice_a_multilines ON public.a_multilines(codice);

 DROP INDEX IF EXISTS public.idx_classe_a_multilines;
 CREATE INDEX idx_classe_a_multilines ON public.a_multilines(classe);

 insert into public.a_multilines (codice,classe,geom)
 values('pippo','pippo2',ST_GeomFromText('MULTILINESTRING((1513486.95
 4864040.34,1713484.69 4864040.41))',3003));

 Then
 QGis (r13054) show the attribute table empty.
 Instead an identify on the line show the rights values.

-- 
Ticket URL: <https://trac.osgeo.org/qgis/ticket/2555>
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