[Tile-serving] [openstreetmap/osm2pgsql] Syntax error at create index (#1447)

doskabouter notifications at github.com
Tue Apr 6 08:30:45 UTC 2021


When using --middle-schema myschema, --output-pgsql-schema myschema and --middle-way-node-index-id-shift I get a 
syntax error at
CREATE INDEX myschema.planet_osm_ways_nodes_bucket_idx.

According to the docs schemanames are not allowed at CREATE INDEX

https://github.com/openstreetmap/osm2pgsql/blob/master/src/middle-pgsql.cpp#L710
and
https://github.com/openstreetmap/osm2pgsql/blob/master/src/middle-pgsql.cpp#L720

Also, what am I missing in my current import (don't want to redo it, it takes over 5 days)?
I do have these messages in my log:
All postprocessing on table 'planet_osm_point' done
All postprocessing on table 'planet_osm_line' done
All postprocessing on table 'planet_osm_roads' done
Done postprocessing on table 'planet_osm_rels'
All postprocessing on table 'planet_osm_polygon' done

So it seems those tables are fully completed, is that correct?
What steps do I need to take to finalize the ways table?

osm2pgsql version 1.4.1
Database version: 11.2
PostGIS version: 2.5


-- 
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/1447
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/tile-serving/attachments/20210406/2cdd0cde/attachment.htm>


More information about the Tile-serving mailing list