id summary reporter owner description type status priority milestone component resolution keywords cc 1187 "pgRouting database load trouble: ""value is out of range for type smallint""" hamish live-demo@… "r105556: maybe related to version upgrade, maybe related to new larger CBD osm file extract (should I shrink the area now that there is more detail?) {{{ Setting up osm2pgrouting (2.0.0-beta-ppa4) ... create pgrouting database with PostGIS and pgRouting CREATE EXTENSION CREATE EXTENSION unpack sample data Run osm2pgrouting converter (this may take a while) NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index ""nodes_pkey"" for table ""nodes"" 2create ways failed: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index ""types_pkey"" for table ""types"" NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index ""classes_pkey"" for table ""classes"" ERROR: value ""45028"" is out of range for type smallint CONTEXT: COPY nodes, line 115830, column numofuse: ""45028"" NOTICE: table ""vertices_tmp"" does not exist, skipping CONTEXT: SQL statement ""DROP TABLE IF EXISTS vertices_tmp"" PL/pgSQL function ""pgr_createtopology"" line 44 at SQL statement NOTICE: CREATE TABLE will create implicit sequence ""vertices_tmp_id_seq"" for serial column ""vertices_tmp.id"" CONTEXT: SQL statement ""CREATE TABLE vertices_tmp (id bigserial)"" PL/pgSQL function ""pgr_createtopology"" line 45 at SQL statement NOTICE: 0 out of 21142 edges processed NOTICE: 10000 out of 21142 edges processed NOTICE: 20000 out of 21142 edges processed VACUUM }}} Hamish" defect closed minor OSGeoLive7.9 OSGeoLive fixed pgrouting