Bug report #4783
PostGIS provider assumes tables have OIDs
|Affected QGIS version:||master||Regression?:||No|
|Operating System:||Easy fix?:||No|
|Pull Request or Patch supplied:||No||Resolution:|
|Crashes QGIS or corrupts data:||No||Copied to github as #:||14638|
commit 0498c955469effadc6691032b65d663821cf5bf1 Author: VKa <[email protected]> Date: Wed Jan 4 11:28:27 2012 +0100
The postgis provider assumes spatial tables have OIDs, and also always start selects with a comma (SELECT ,asbinary).
#1 Updated by Sandro Santilli about 8 years ago
I would add that the user has no feedback of the problem and simply doesn't see the geometries on stage.
1.7.4 opens the same table just fine.
17:36 < strk> Result: 7 (ERROR: column "oid" does not exist 17:36 < strk> LINE 1: ...isf0 BINARY CURSOR FOR SELECT asbinary("g",'NDR'),oid FROM "... 17:37 < strk> pgis 1.4, table structure: 17:37 < strk> id | integer | not null default nextval('zm_id_seq'::regclass) 17:37 < strk> g | geometry | 17:37 < strk> no primary keys 17:37 < strk> no user feedback warning about that 17:37 < strk> same table can be opened with 1.7