Florian Lohoff wrote: > On Fri, Oct 31, 2008 at 11:17:16AM +0100, Florian Lohoff wrote: > >> Hi, >> i just discovered that osmosis was not able to apply the hourly osc file >> starting 2008-10-29T20:00:00Z - It failed with: >> >> 2008-10-31 11:09:52 CET ERROR: smallint out of range >> 2008-10-31 11:09:52 CET STATEMENT: INSERT INTO way_nodes (way_id, node_id, >> sequence_id) VALUES ($1, $2, $3) >> >> Is there a way with >2^16 aka 65536 nodes? >> >> Or did someone manage to enter a completely broken sequence number? >> > > Its 2^15 because it signed - and yes - somebody managed to get abovE: > > osm=> select max(sequence_id) from way_nodes; > max > ------- > 39767 > (1 row) > > osm=> select * from way_nodes where sequence_id = 39767; > way_id | node_id | sequence_id > ----------+-----------+------------- > 28098452 | 308532457 | 39767 > > I converted the smallint to int ... > So, should update the schema script included with osmosis as well? It's easy enough for me to change, but will increase the size of the database somewhat.
_______________________________________________ dev mailing list [email protected] http://lists.openstreetmap.org/listinfo/dev
