QGIS » QGIS Application

Spin off of #13958

Create a simple PostGIS table:

CREATE table my_lines(gid integer primary key, col integer);
SELECT AddGeometryColumn('my_lines', 'geom', 4326, 'MULTILINESTRING', 2);

INSERT INTO my_lines(gid, col, geom)
SELECT -1, 2, 'SRID=4326;MULTILINESTRING((0 0, 1 1))';

Note that the primary key has a negative value -1, which should be completely fine and previous versions of QGIS were OK with this.

This table can be added to QGIS, which shows the simple geometry on the main canvas normally, and the Layer properties correctly describes both gid and col fields as int4.

However, the attribute table shows the values of gid and col as ERROR, and clicking the feature with the Identify Features tool show gid of 4294967295, which is the overflow version of an unsigned integer value -1. Perhaps the primary key was internally cast in QGIS to unsigned long?

Editing the layer, e.g. with the Node tool fail on save, with this message:

src/providers/postgres/qgspostgresprovider.cpp: 2322: (changeGeometryValues) [1279ms] entering.
src/providers/postgres/qgspostgresprovider.cpp: 2395: (changeGeometryValues) [0ms] updating: UPDATE "public"."my_lines" SET "geom"=st_multi(st_geom
fromwkb($1::bytea,4326)) WHERE "gid"=$2
src/providers/postgres/qgspostgresprovider.cpp: 2405: (changeGeometryValues) [1ms] iterating over the map of changed geometries...
src/providers/postgres/qgspostgresprovider.cpp: 2411: (changeGeometryValues) [0ms] iterating over feature id 4294967295
src/core/qgsvectordataprovider.cpp: 560: (pushError) [0ms] PostGIS error while changing geometry values: ERROR:  value "4294967295" is out of range
 for type integer

src/providers/postgres/qgspostgresprovider.cpp: 2501: (changeGeometryValues) [0ms] leaving.
src/core/qgsmessagelog.cpp: 45: (logMessage) [1ms] 2016-02-09T17:20:03 [1] Commit errors:
  ERROR: 1 geometries not changed.

  Provider errors:
      PostGIS error while changing geometry values: ERROR:  value "4294967295" is out of range for type integer

Affected: master branch 2.14.0dev (b9726d7285733c27d42456c115e28d5a37f3e0be)

Note that 2.8.3 crashes on first edit attempt. The crash is fixed in current master.