[Tile-serving] [openstreetmap/osm2pgsql] Marking relations when node member changes uses wrong id (#1048)

[Sarah Hoffmann]

middle-pgsql prepares the query for invalidating relations from node members as follows:

```
"PREPARE mark_rels_by_node(" POSTGRES_OSMID_TYPE ") AS select id from %p_ways WHERE nodes && ARRAY[$1];\n"
```

This is obviously wrong. It returns way ids, not relation ids.

Looks like a copy-paste error from the C++ conversion. The original C code has:

```
"PREPARE node_changed_mark(" POSTGRES_OSMID_TYPE ") AS UPDATE %p_rels SET pending = true WHERE parts && ARRAY[$1] AND parts[1:way_off] && ARRAY[$1] AND NOT pending;\n"
```

-- 
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/1048
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/tile-serving/attachments/20200103/75e5f5be/attachment.htm>