<p dir="auto">Only send one SQL command per exec(). This should fix a problem with the Pgpool-II connection pool server which doesn't support multi-statement queries. It also makes it hopefully a bit more obvious that there are several statements sent to the server. To that end I have also removed the semicolons at the end of the queries in all places, because they should never be needed any more.</p>
<p dir="auto"><span class="issue-keyword tooltipped tooltipped-se" aria-label="This pull request closes pull request #1995.">Fixes</span> <a class="issue-link js-issue-link" data-error-text="Failed to load title" data-id="1797359089" data-permission-text="Title is private" data-url="https://github.com/openstreetmap/osm2pgsql/issues/1995" data-hovercard-type="pull_request" data-hovercard-url="/openstreetmap/osm2pgsql/pull/1995/hovercard" href="https://github.com/openstreetmap/osm2pgsql/pull/1995">#1995</a></p>
<hr>
<h4>You can view, comment on, or merge this pull request online at:</h4>
<p> <a href='https://github.com/openstreetmap/osm2pgsql/pull/2002'>https://github.com/openstreetmap/osm2pgsql/pull/2002</a></p>
<h4>Commit Summary</h4>
<ul>
<li><a href="https://github.com/openstreetmap/osm2pgsql/pull/2002/commits/c6132c80a8fe12d648a40c7860a72b6051e3cf25" class="commit-link">c6132c8</a> Don't do multi-statement queries</li>
</ul>
<h4 style="display: inline-block">File Changes </h4> <p style="display: inline-block">(<a href="https://github.com/openstreetmap/osm2pgsql/pull/2002/files">3 files</a>)</p>
<ul>
<li>
<strong>M</strong>
<a href="https://github.com/openstreetmap/osm2pgsql/pull/2002/files#diff-6237ae72dac71b4b88a541860afdb44f23a47ae252f8236a4522eacd2d6a766f">src/middle-pgsql.cpp</a>
(170)
</li>
<li>
<strong>M</strong>
<a href="https://github.com/openstreetmap/osm2pgsql/pull/2002/files#diff-658c580d094c7d459c656034c1ad794752b5dbe1e440df0fc026e5396743fd78">src/middle-pgsql.hpp</a>
(8)
</li>
<li>
<strong>M</strong>
<a href="https://github.com/openstreetmap/osm2pgsql/pull/2002/files#diff-10e97df69348a578ce413ed39c0d68713777bb2cbc056f481a60610ee447328a">tests/test-middle.cpp</a>
(6)
</li>
</ul>
<h4>Patch Links:</h4>
<ul>
<li><a href='https://github.com/openstreetmap/osm2pgsql/pull/2002.patch'>https://github.com/openstreetmap/osm2pgsql/pull/2002.patch</a></li>
<li><a href='https://github.com/openstreetmap/osm2pgsql/pull/2002.diff'>https://github.com/openstreetmap/osm2pgsql/pull/2002.diff</a></li>
</ul>
<p style="font-size:small;-webkit-text-size-adjust:none;color:#666;">—<br />Reply to this email directly, <a href="https://github.com/openstreetmap/osm2pgsql/pull/2002">view it on GitHub</a>, or <a href="https://github.com/notifications/unsubscribe-auth/AA6353WX5GR6NRXDCIYBIGLXQFM5FANCNFSM6AAAAAA2KOATMY">unsubscribe</a>.<br />You are receiving this because you are subscribed to this thread.<img src="https://github.com/notifications/beacon/AA6353T6VMVHI6NUEI63OADXQFM5FA5CNFSM6AAAAAA2KOATM2WGG33NNVSW45C7OR4XAZNFJFZXG5LFVJRW63LNMVXHIX3JMTHGXFT464.gif" height="1" width="1" alt="" /><span style="color: transparent; font-size: 0; display: none; visibility: hidden; overflow: hidden; opacity: 0; width: 0; height: 0; max-width: 0; max-height: 0; mso-hide: all">Message ID: <span><openstreetmap/osm2pgsql/pull/2002</span><span>@</span><span>github</span><span>.</span><span>com></span></span></p>
<script type="application/ld+json">[
{
"@context": "http://schema.org",
"@type": "EmailMessage",
"potentialAction": {
"@type": "ViewAction",
"target": "https://github.com/openstreetmap/osm2pgsql/pull/2002",
"url": "https://github.com/openstreetmap/osm2pgsql/pull/2002",
"name": "View Pull Request"
},
"description": "View this Pull Request on GitHub",
"publisher": {
"@type": "Organization",
"name": "GitHub",
"url": "https://github.com"
}
}
]</script>