Bug report #14007
Can't create new features from Postgis Table with Z component
|Affected QGIS version:||2.12.0||Regression?:||No|
|Operating System:||Easy fix?:||No|
|Pull Request or Patch supplied:||No||Resolution:||fixed/implemented|
|Crashes QGIS or corrupts data:||No||Copied to github as #:||22020|
In QGIS 2.12, having a Postgis table with Z component. It's not possible to add a new features, as it fails to save. Yet, It's possible to edit or copy/paste existing features.
The issue can be replicated by doing the following:
Creating a table in Postgis:
CREATE TABLE test
gid serial primary key,
name character varying(100),
Insert a record:
INSERT INTO test (name,geom) VALUES
('polygon 1 single flat', ST_GeomFromText('MultiPolygonZ (((-30.0 42.0 0, -30.0 41.0 0, -29.0 41.0 0, -29.0 42.0 0, -30.0 42.0 0)))',4326));
Open the table in QGIS, start editing and create a new feature.
Trying to save the edits you will get the following error:
Could not commit changes to layer test
Errors: ERROR: 1 feature(s) not added.
PostGIS error while adding features: ERRO: Column has Z dimension but geometry does not
If you copy paste the features to notepad, you notice that the geometry of the created feature lacks the Z component.
Also, it's impossible to edit the Z component with the new node editor.
This was already happening in QGIS 2.8.
#1 Updated by Pedro Venâncio over 4 years ago
I can confirm this issue. Some information about it with sample data:
#4 Updated by Giovanni Manghi almost 3 years ago
- Resolution set to fixed/implemented
- Description updated (diff)
- Status changed from Open to Closed
This particular problem (adding a new feature) seems solved in 2.18.13 and master. There are others anyway in 2.18 that are not there in 2.14 and master:
existing line/polygon features cannot be moved, the node tool is not able to move vertexes and the Z value of nodes cannot be changed.
Will file a new ticket.