<p>Ouch, that's a bit of a headache, given that osmosis is unmaintained and any new release is unlikely.</p>
<p>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.</p>
<p>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 <a href="https://github.com/openstreetmap/osmosis/blob/2219470cef1f73f5d1319c57149c84b398e767ce/osmosis-apidb/src/main/java/org/openstreetmap/osmosis/apidb/v0_6/impl/UserManager.java#L26">the relevant line in the code</a> first.</p>
<p>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.</p>

<p style="font-size:small;-webkit-text-size-adjust:none;color:#666;">—<br />You are receiving this because you are subscribed to this thread.<br />Reply to this email directly, <a href="https://github.com/openstreetmap/openstreetmap-website/issues/2449?email_source=notifications&email_token=AAK2OLI3KI7UXGPEIQVNUJLQW55B5A5CNFSM4JVAZWAKYY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOEF4MRWI#issuecomment-561563865">view it on GitHub</a>, or <a href="https://github.com/notifications/unsubscribe-auth/AAK2OLOBWN4L5URGS5YTXCLQW55B5ANCNFSM4JVAZWAA">unsubscribe</a>.<img src="https://github.com/notifications/beacon/AAK2OLM2SV3TQHFTG3UHFX3QW55B5A5CNFSM4JVAZWAKYY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOEF4MRWI.gif" height="1" width="1" alt="" /></p>
<script type="application/ld+json">[
{
"@context": "http://schema.org",
"@type": "EmailMessage",
"potentialAction": {
"@type": "ViewAction",
"target": "https://github.com/openstreetmap/openstreetmap-website/issues/2449?email_source=notifications\u0026email_token=AAK2OLI3KI7UXGPEIQVNUJLQW55B5A5CNFSM4JVAZWAKYY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOEF4MRWI#issuecomment-561563865",
"url": "https://github.com/openstreetmap/openstreetmap-website/issues/2449?email_source=notifications\u0026email_token=AAK2OLI3KI7UXGPEIQVNUJLQW55B5A5CNFSM4JVAZWAKYY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOEF4MRWI#issuecomment-561563865",
"name": "View Issue"
},
"description": "View this Issue on GitHub",
"publisher": {
"@type": "Organization",
"name": "GitHub",
"url": "https://github.com"
}
}
]</script>