<p>This is interesting. I had exactly the opposite argument in mind: by setting the search_path centrally when connecting to the database, any subsequent statement would automatically take this into account, be it when creating indices, or adding/deleting tables entries. Having to take care of an explicit schema name everywhere adds more mental load, and there's some chance someone might simply forget about it in the future. So I'd be interested to find out where you see long term issues. Maybe I'm missing something here.</p>
<p>The one thing I find a bit unfortunate is that we need to add the hstore extension schema name during table creation. This might be different from "public" after all, and we might have to provide some parameter to specify the hstore schema name (which is <em>public</em> by default).</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/osm2pgsql/issues/768?email_source=notifications&email_token=AA6353SOMPY6IRSI6LWZLK3QUFMXPA5CNFSM4DQHUB2KYY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOEEIOCSA#issuecomment-554754376">view it on GitHub</a>, or <a href="https://github.com/notifications/unsubscribe-auth/AA6353TYCSURAPFVDW3E6CLQUFMXPANCNFSM4DQHUB2A">unsubscribe</a>.<img src="https://github.com/notifications/beacon/AA6353Q22HQFKCIVFXG2YADQUFMXPA5CNFSM4DQHUB2KYY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOEEIOCSA.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/osm2pgsql/issues/768?email_source=notifications\u0026email_token=AA6353SOMPY6IRSI6LWZLK3QUFMXPA5CNFSM4DQHUB2KYY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOEEIOCSA#issuecomment-554754376",
"url": "https://github.com/openstreetmap/osm2pgsql/issues/768?email_source=notifications\u0026email_token=AA6353SOMPY6IRSI6LWZLK3QUFMXPA5CNFSM4DQHUB2KYY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOEEIOCSA#issuecomment-554754376",
"name": "View Issue"
},
"description": "View this Issue on GitHub",
"publisher": {
"@type": "Organization",
"name": "GitHub",
"url": "https://github.com"
}
}
]</script>