[Tile-serving] [osm2pgsql] Changing a style file after import and then applying diffs (#152)

[Mark Cupitt]

So, here is what I did, in case anyone else needs it. (Using Golf as an example)

1. Stopped Diff Updates
2. Ran the following SQL (in this case it is on planet_osm_polygon but should be run on planet_osm_point as well)

```sql
    ALTER table planet_osm_polygon add column golf varchar;
    UPDATE planet_osm_polygon SET golf=tags->'golf';
    SELECT COUNT(*) FROM planet_osm_polygon WHERE golf is not null and golf <> '';

    alter table planet_osm_line add column golf varchar;
    alter table planet_osm_roads add column golf varchar;
```

3. restarted Diff Updates

I added the column to lines and roads as well, just in case osm2pgsql did not like it. It may not be necessary ..

---
Reply to this email directly or view it on GitHub:
https://github.com/openstreetmap/osm2pgsql/issues/152#issuecomment-46928396
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/tile-serving/attachments/20140623/93ece452/attachment.html>