TimSC / pycrocosm

OSM API v0.6 implemented in Django/Python
7 stars 4 forks source link

Index generated on wrong table #23

Closed TimSC closed 5 years ago

TimSC commented 5 years ago

While generating indicies:

CREATE INDEX IF NOT EXISTS "planet2_static_oldnodes_ts" ON "planet2_static_livenodes" (timestamp);
CREATE INDEX IF NOT EXISTS "planet2_static_oldways_ts" ON "planet2_static_liveways" (timestamp);
CREATE INDEX IF NOT EXISTS "planet2_static_oldrelations_ts" ON "planet2_static_liverelations" (timestamp);
CREATE INDEX IF NOT EXISTS "planet2_static_livenodes_ts" ON "planet2_static_livenodes" (timestamp);
CREATE INDEX IF NOT EXISTS "planet2_static_liveways_ts" ON "planet2_static_liveways" (timestamp);
CREATE INDEX IF NOT EXISTS "planet2_static_liverelations_ts" ON "planet2_static_liverelations" (timestamp);

That doesn't look right. oldnodes index should be oldnodes table?

TimSC commented 5 years ago

Attempted fix in https://github.com/TimSC/pgmap/commit/665ae1958c35f4470ee80626d00cfed69ab2119f