[Tile-serving] [openstreetmap/osm2pgsql] Does the -G option support MultiPoint and MultiLineString geometries? (#609)

[Paul Norman]

> ALTER TABLE buildings ADD PRIMARY KEY (osm_id);

Don't do this. `osm_id` is not designed to be a primary key. You can use it like a primary key in many cases - any rows with the same osm_id will have the same tag columns, but it is not guaranteed to be unique. You can create a btree index on osm_id, just not unique.

If you require a primary key, add a serial column with postgres to make your own.

If you're designing something new, creating tables for specific features is what the [multi backend](https://github.com/openstreetmap/osm2pgsql/blob/master/docs/multi.md) is designed for, and this is a better approach than a` CREATE TABLE ... AS ... approach`

---
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/609#issuecomment-234189163
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/tile-serving/attachments/20160721/68f6b489/attachment-0001.html>