[Qgis-developer] Requirement for int4 column on PostGIS access

Jochen Topf jochen at remote.org
Sat Aug 30 10:42:42 EDT 2008

Currently QGIS requires a int4 column with unique IDs for accessing data
in a PostGIS database. I routinely work with OpenStreetMap data which
uses int8 for its IDs. Currently the OSM IDs still fit into an int4, but
this will not work forever. At the moment its a bit of a hassle that I
always have to keep this limitation in mind.

Is the limitation on int4 columns something hardcoded deep in the code
or is it something that could be changed reasonably easy? I understand
the need for a unique ID column, but it would be nice if the data type
was more flexible. I think at least int2, int4, and int8 should be

Jochen Topf  jochen at remote.org  http://www.remote.org/jochen/  +49-721-388298

More information about the Qgis-developer mailing list