Bug report #2555

QGis show attribute table empty with postgres

Added by aperi2007 - about 14 years ago. Updated about 14 years ago.

Status:Closed
Priority:Low
Assignee:nobody -
Category:Data Provider
Affected QGIS version: Regression?:No
Operating System:Windows Easy fix?:No
Pull Request or Patch supplied: Resolution:fixed
Crashes QGIS or corrupts data: Copied to github as #:12615

Description

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, classe VARCHAR);
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)',3003));

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

Associated revisions

Revision 9d6fe104
Added by Jürgen Fischer about 14 years ago

fix #2555

git-svn-id: http://svn.osgeo.org/qgis/trunk/qgis@13059 c8812cc2-4d05-0410-92ff-de0c093fc19c

Revision 172f28b6
Added by Jürgen Fischer about 14 years ago

fix #2555

git-svn-id: http://svn.osgeo.org/qgis/trunk@13059 c8812cc2-4d05-0410-92ff-de0c093fc19c

History

#1 Updated by Jürgen Fischer about 14 years ago

  • Resolution set to fixed
  • Status changed from Open to Closed

fixed in 172f28b6 (SVN r13060).

Also available in: Atom PDF