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 ...
Flo
--
Florian Lohoff [EMAIL PROTECTED] +49-171-2280134
Those who would give up a little freedom to get a little
security shall soon have neither - Benjamin Franklin
signature.asc
Description: Digital signature
_______________________________________________ dev mailing list dev@openstreetmap.org http://lists.openstreetmap.org/listinfo/dev
