[Tile-serving] [osm2pgsql] modified relation removes & readds existing way (#559)

TobWen notifications at github.com
Wed Mar 16 16:51:46 UTC 2016


Why is this changefile (a synthethic one derived from original) removing the way with id 47036578 from planet_osm_line and inserting it again without a change?

```
<?xml version='1.0' encoding='UTF-8'?>
<osmChange version="0.6" generator="test">
<modify>
	<relation id="1" version="9999" timestamp="2013-12-07T19:03:20Z" changeset="0" uid="0" user="tobwen">
		<member type="way" ref="47036578" role=""/>
	</relation>
</modify>
</osmChange>
```

I've detected it using a trigger:
```
CREATE or REPLACE FUNCTION before_delete() RETURNS TRIGGER AS $$
BEGIN
    RAISE NOTICE 'Removed: %',  OLD.osm_id;
    RETURN OLD;
END;
$$ LANGUAGE plpgsql;

CREATE TRIGGER trigger_before_delete
BEFORE DELETE ON planet_osm_line
FOR EACH ROW
EXECUTE PROCEDURE before_delete();
```

---
You are receiving this because you are subscribed to this thread.
Reply to this email directly or view it on GitHub:
https://github.com/openstreetmap/osm2pgsql/issues/559
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/tile-serving/attachments/20160316/5eb9fb2f/attachment.html>


More information about the Tile-serving mailing list