#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 , 16 years ago
Component: | Build/Install → Data Provider |
---|---|
Version: | HEAD |
comment:2 by , 16 years ago
comment:3 by , 15 years ago
Resolution: | → worksforme |
---|---|
Status: | new → closed |
Does this still apply with a recent version? If so, please reopen the bug
When using the Ubuntu-Version everything works fine!