Bug report #1372
Crash when using postgis layers with symbology "continous colors"
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: | worksforme | |
Crashes QGIS or corrupts data: | Copied to github as #: | 11432 |
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);
History
#1 Updated by sitondorf - about 16 years ago
When using the Ubuntu-Version everything works fine!
#2 Updated by Paolo Cavallini almost 16 years ago
- Resolution set to worksforme
- Status changed from Open to Closed
Does this still apply with a recent version? If so, please reopen the bug
#3 Updated by Anonymous about 15 years ago
Milestone Version 1.0.1 deleted