[OSM-dev] osm2pgsql does not remove deleted nodes

Stephan Knauss osm at stephans-server.de
Sat Sep 10 11:37:37 BST 2011


Hi,

I have a problem that when applying diffs a deleted node is not removed.

I think in general it worked fine. Now I have a specific node that can 
not be deleted.

I'm using rev 26385
osm2pgsql SVN version 0.70.5

Calling with these options
osm2pgsql -v -S default.style -s -a --hstore-all -b 
"97.3,5.6,109.6,23.4" -U osm -d osm -e 16 -o expire.list change.osc

with this reduced change file:
<?xml version='1.0' encoding='UTF-8'?>
<osmChange version="0.6" generator="Osmosis 0.38">
   <delete>
     <node id="891306598" version="5" timestamp="2011-09-09T22:04:42Z" 
uid="104414" user="Willi2006" changeset="9258444" lat="16.417618" 
lon="102.8032077"/>
   </delete>
</osmChange>


There is no unusual message in the program output. But later there is 
still the node in the database:
echo "SELECT osm_id FROM planet_osm_point WHERE osm_id=891306598" | psql 
-U osm -d osm
   osm_id
-----------
  891306598
(1 row)


Any idea what's wrong here?


Stephan



More information about the dev mailing list