[openstreetmap/openstreetmap-website] ERROR: column "nearby" of relation "users" (#2449)

[Andy Allan]

Ouch, that's a bit of a headache, given that osmosis is unmaintained and any new release is unlikely.

Arguably osmosis shouldn't have been trying to fill in that column anyway, since it had a default and so the insert could have ignored it.

I think a workaround would be for the user to re-add the column, run the osmosis command, and then drop the column again. Alternatively, if you can compile osmosis from source, then edit [the relevant line in the code](https://github.com/openstreetmap/osmosis/blob/2219470cef1f73f5d1319c57149c84b398e767ce/osmosis-apidb/src/main/java/org/openstreetmap/osmosis/apidb/v0_6/impl/UserManager.java#L26) first.

Does anyone know of any other mechanism for loading an osm file into the database? I imagine it's a fairly common task for small deployments.

-- 
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/openstreetmap-website/issues/2449#issuecomment-561563865
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/rails-dev/attachments/20191204/255c83f3/attachment.html>