[Tile-serving] [openstreetmap/osm2pgsql] Flex tables without geometry end up unlogged (#1141)

[Paul Norman]

I defined a table with no geometry column and the result was
```
\d planet_osm_route
          Unlogged table "public.planet_osm_route"
     Column      │  Type   │ Collation │ Nullable │ Default
─────────────────┼─────────┼───────────┼──────────┼─────────
 osm_id          │ bigint  │           │ not null │
 member_id       │ bigint  │           │          │
 member_position │ integer │           │          │
 tags            │ hstore  │           │          │
 route           │ text    │           │          │
 ref             │ text    │           │          │
 network         │ text    │           │          │
```

The table should end up as a normal logged table.

We create the tables as unlogged on import and then the `CREATE TABLE AS ... ORDER BY ...` operation turns them into a normal table. Because this table has no geometry it doesn't get that operation, so stays unlogged.

-- 
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/1141
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/tile-serving/attachments/20200426/36e2c426/attachment.htm>