[OSM-dev] No more negative ids in osm2pgsql-imported DB?

[yvecai]

Oh sure! I completely forgot I once had this exact same issue too !
Thanks for the reminder :-)

On 02/10/2013 06:21 PM, Jon Burgess wrote:
> On Sun, 2013-02-10 at 17:28 +0100, yvecai wrote:
>> I've just updated osm2pgsql from source (osm2pgsql SVN version 0.81.0
>> (64bit id space))
>>
>> I don't have no negative ids in my DB anymore ???
>>
>> I'm primarily interested in 'route' relations:
>>       select count(*) from planet_osm_line where route is not null; ->
>> 2998 OK
>>       select count(*) from planet_osm_rels; -> 1579 OK
>>
>>       select count(*) from planet_osm_line where osm_id < 0; -> 0 not OK
> Seems to be working on Yevaud. For example, this route relation appeared
> a few minutes ago:
>
> gis=# select osm_id,route from planet_osm_line where osm_id<-2751100 and route is not null;
>    osm_id  | route
> ----------+--------
>   -2751190 | hiking
>   -2751189 | hiking
> (2 rows)
>
> http://www.openstreetmap.org/browse/relation/2751189
>
>
> I remember seeing a similar problem once before which was caused by a
> problem with the Geos libraries. A mismatch between the data structures
> in Geos header files and the linked library caused all relations to be
> silently discarded. Try making sure you only have one set of geos
> libraries & headers installed.
>
>     Jon
>
>
>
>
>