[Tile-serving] [openstreetmap/osm2pgsql] 'delete' style entries go to hstore in --hstore-all (#896)

[Darafei Praliaskouski]

I want a super simple schema with only osm_id, osm_user, osm_timestamp, way and tags columns. As a surprise, --hstore-all imports everything that osm2pgsql may turn into column, including --extended-attributes.


```
../osm2pgsql/build/osm2pgsql -C 50000 --flat-nodes nodes.cache --slim --hstore-all --skip-optimizing --skip-indexing --extra-attributes --multi-geometry --style osm/hstore.style data/planet-latest.osm.pbf
```

osm/hstore.style has delete lines:
```

node,way    osm_user            text        linear
node,way    osm_timestamp       timestamptz linear
node,way    osm_version         bigint      linear

node,way    osm_uid             text        delete
node,way    osm_changeset       text        delete
node,way    osm_version         text        delete
node,way    way_area            text        delete
```

Even though explicitly deleted the values are there.

```
 select * from planet_osm_point limit 1; 

   osm_id   | osm_user |     osm_timestamp      | osm_version |                                                                        tags                                                                         |                        way                                                                                                                                                                                                                                          ------------+----------+------------------------+-------------+-----------------------------------------------------------------------------------------------------------------------------------------------------+----------------------------------------------------                                                                                                                                                                                                                  4619972264 | Awo      | 2017-01-20 07:51:55+03 |           1 | "natural"=>"tree", "osm_uid"=>"196556", "osm_user"=>"Awo", "osm_version"=>"1", "osm_changeset"=>"45317667", "osm_timestamp"=>"2017-01-20T04:51:55Z" | 0101000020110F00000B623E9B1DF85DC149D5E5A251514EC1                                                                                                                                                                                                                  (1 row)            


select * from planet_osm_line limit 1;

  osm_id  | osm_user |     osm_timestamp      | osm_version |                                                                              tags                                                                               |                                                                                                                                            way                                                                                                            
----------+----------+------------------------+-------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 30179530 | LSV-map  | 2017-03-06 16:51:45+03 |           6 | "osm_uid"=>"3647004", "osm_user"=>"LSV-map", "aerialway"=>"drag_lift", "osm_version"=>"6", "osm_changeset"=>"46624560", "osm_timestamp"=>"2017-03-06T13:51:45Z" | 0102000020110F000008000000F8D73ACE8B7358410EF068400D185F41481DC5EE8C7358413115CA4AD9175F419253922F8773584164A6D79A97175F415933636286735841D7B9891973175F41F31F3FBE7D7358410FF128F103175F41A4B6EF9F8E7358412B066F4C91165F415D0BED3899735841E58E0EA654165F4154E58A16A3735841BEB30A1A1D165F41
(1 row)
```


-- 
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/896
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/tile-serving/attachments/20190111/89731214/attachment.html>