[OSM-dev] HEADS UP osmosis pgsql schema users Was: psql osmosis simple shema / smallint out of range

[Brett Henderson]

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.