<p>at first I upload data into database using this command-<br>
osmosis --read-pbf previous.osm.pbf <br>
--write-apidb host="localhost" database="openstreetmap" <br>
user="postgres" password="postgres" validateSchemaVersion="no"<br>
and its working fine. Next I produce a diff.osc.gz using following command-<br>
osmosis --read-pbf latest.osm.pbf --read-pbf previous.osm.pbf --derive-change --write-xml-change diff.osc.gz<br>
Then I use the following command to append data into database-<br>
osmosis --read-xml-change diff.osc.gz --write-pgsql-change user="postgres" database="openstreetmap" password="postgres" validateSchemaVersion="no"<br>
It shows me following error:<br>
SEVERE: Thread for task 1-read-xml-change failed<br>
org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar [SELECT id, name FROM users WHERE id = ?]; nested exception is org.postgresql.util.PSQLException: ERROR: column "name" does not exist</p>
<p>Am I doing something wrong? what is the right procedure?</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/1638">view it on GitHub</a>, or <a href="https://github.com/notifications/unsubscribe-auth/ABWnLQ_Qfg2IM2ylvHjWsKGTFxzZeOlaks5shRKRgaJpZM4PS_Ix">mute the thread</a>.<img alt="" height="1" src="https://github.com/notifications/beacon/ABWnLUEtzlKixFHmApqekIx4hIJ3jdxnks5shRKRgaJpZM4PS_Ix.gif" width="1" /></p>
<div itemscope itemtype="http://schema.org/EmailMessage">
<div itemprop="action" itemscope itemtype="http://schema.org/ViewAction">
<link itemprop="url" href="https://github.com/openstreetmap/openstreetmap-website/issues/1638"></link>
<meta itemprop="name" content="View Issue"></meta>
</div>
<meta itemprop="description" content="View this Issue on GitHub"></meta>
</div>
<script type="application/json" data-scope="inboxmarkup">{"api_version":"1.0","publisher":{"api_key":"05dde50f1d1a384dd78767c55493e4bb","name":"GitHub"},"entity":{"external_key":"github/openstreetmap/openstreetmap-website","title":"openstreetmap/openstreetmap-website","subtitle":"GitHub repository","main_image_url":"https://cloud.githubusercontent.com/assets/143418/17495839/a5054eac-5d88-11e6-95fc-7290892c7bb5.png","avatar_image_url":"https://cloud.githubusercontent.com/assets/143418/15842166/7c72db34-2c0b-11e6-9aed-b52498112777.png","action":{"name":"Open in GitHub","url":"https://github.com/openstreetmap/openstreetmap-website"}},"updates":{"snippets":[{"icon":"DESCRIPTION","message":"can't append osm data into database (#1638)"}],"action":{"name":"View Issue","url":"https://github.com/openstreetmap/openstreetmap-website/issues/1638"}}}</script>