Opened 16 years ago

Closed 15 years ago

Last modified 15 years ago

#1372 closed bug (worksforme)

Crash when using postgis layers with symbology "continous colors"

Reported by: sitondorf Owned by: nobody
Priority: critical: causes crash or data corruption Milestone:
Component: Data Provider Version:
Keywords: crash postgis symbology Cc:
Must Fix for Release: No Platform: Windows
Platform Version: Awaiting user input: no

Description

POSTGis-Layer: View in Postgis-Database v_mdat_gem_k_efh

When displaying the data everything works fine. "Save Project" and "Open Project" work as expected.

Layer-Properties->Symbology: Legend type: change to "Continuous Color" Classification Field: wert ... (default values)

[OK]: Map is displayed with continous colors. Saved Project to a new file Closed QGIS Start QGIS Open saved project -> application crash

No difference between 0.11.0-Metis and 1.0.0-Kore-preview1

Postgis-Data: CREATE OR REPLACE VIEW v_mdat_gem_k_efh AS

SELECT g.gid, g.rs, g.ags, g.si_subkey, g.gen, g.des, g.ewz, g.bld_gen, f.wert, f.wert_quelle, d."BEZ" AS wert_quelle_str, f.wert_fix, f.randgebiet, g.the_geom

FROM basis_bkg_gem g, marktdaten_gem_k_efh f JOIN datenquelle d ON d."ID" = f.wert_quelle

WHERE g.rs = f.rs AND g.si_subkey = f.si_subkey;

CREATE TABLE basis_bkg_gem (

gid serial NOT NULL, bld_rs character(12), krs_rs character(12), rs character(12), ags character(8), si_subkey character(2), gen character varying(50), des character varying(50), ewz bigint, bld_gen character varying(25), krs_gen character varying(50), the_geom geometry, CONSTRAINT basis_bkg_gem_gem_pkey PRIMARY KEY (gid), CONSTRAINT enforce_dims_the_geom CHECK (ndims(the_geom) = 2), CONSTRAINT enforce_geotype_the_geom CHECK (geometrytype(the_geom) = 'MULTIPOLYGON'::text OR the_geom IS NULL), CONSTRAINT enforce_srid_the_geom CHECK (srid(the_geom) = 4326)

) WITH (OIDS=FALSE); CREATE TABLE marktdaten_gem_k_efh (

rs character(12) NOT NULL, si_subkey character(2) NOT NULL, wert double precision, wert_quelle integer, wert_fix boolean, randgebiet boolean, CONSTRAINT marktdaten_gem_k_efh_pkey PRIMARY KEY (rs, si_subkey)

) WITH (OIDS=FALSE); CREATE TABLE datenquelle (

"ID" integer NOT NULL, "BEZ" character varying(50) NOT NULL, CONSTRAINT pk_datenquelle PRIMARY KEY ("ID")

) WITH (OIDS=FALSE);

Change History (4)

comment:1 by sitondorf, 16 years ago

Component: Build/InstallData Provider
Version: HEAD

comment:2 by sitondorf, 16 years ago

When using the Ubuntu-Version everything works fine!

comment:3 by pcav, 15 years ago

Resolution: worksforme
Status: newclosed

Does this still apply with a recent version? If so, please reopen the bug

comment:4 by (none), 15 years ago

Milestone: Version 1.0.1

Milestone Version 1.0.1 deleted

Note: See TracTickets for help on using tickets.