[Tile-serving] [osm2pgsql] Similar tables do not function the same with multi-backend (#267)

Paul Norman notifications at github.com
Tue Jan 27 00:20:38 UTC 2015


cc @kevinkreiser 

if I define
```json
  {
    "name": "osm_address_number_point",
    "type": "point",
    "tagtransform": "address_number.lua",
    "tagtransform-node-function": "address_nodes",
    "tagtransform-way-function": "drop_all",
    "tagtransform-relation-function": "drop_all",
    "tagtransform-relation-member-function": "drop_all",
    "tags": [
      {"name": "housenumber", "type": "text"}
    ]
  },
  {
    "name": "bar",
    "type": "point",
    "tagtransform": "address_number.lua",
    "tagtransform-node-function": "address_nodes",
    "tagtransform-way-function": "drop_all",
    "tagtransform-relation-function": "drop_all",
    "tagtransform-relation-member-function": "drop_all",
    "tags": [
      {"name": "housenumber", "type": "text"}
    ]
  }
```

where address_nodes is a function that returns `0, {housenumber = something}` for nodes with `addr:housenumber` I get surprising results

```
gis=# select count(*) from osm_address_number_point;
 count
-------
 81639
(1 row)

gis=# select count(*) from bar;
 count
-------
     0
(1 row)
```

If I reverse the two definitions in the JSON, which gets the rows also reverses.

I tried duplicating address_number and renaming the functions but it didn't help.

It looks like I can't add the same point twice into different tables?

---
Reply to this email directly or view it on GitHub:
https://github.com/openstreetmap/osm2pgsql/issues/267
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/tile-serving/attachments/20150126/cbc3c75d/attachment-0001.html>


More information about the Tile-serving mailing list