[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