<!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
<p>(re-adding list)<br>
</p>
<div class="moz-cite-prefix">Le 14/03/2024 à 18:58, Robin Wilson a
écrit :<br>
</div>
<blockquote type="cite"
cite="mid:etPan.65f33aae.280a1aa4.53d@rtwilson.com">
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
<style>body{font-family:Helvetica,Arial;font-size:13px}</style>
<div style="font-family:Helvetica,Arial;font-size:13px; ">Hi Even,</div>
<div style="font-family:Helvetica,Arial;font-size:13px; "><br>
</div>
<div style="font-family:Helvetica,Arial;font-size:13px; ">Perfect
- adding —config PG_USE_COPY YES solved it. I’ll write a blog
post about this that hopefully will be found by someone with the
same issue in future.</div>
</blockquote>
You may also suggest documentation enhancement to
<a class="moz-txt-link-freetext" href="https://gdal.org/drivers/vector/pg.html">https://gdal.org/drivers/vector/pg.html</a> . There's the convenient
"Edit on GitHub" button at the top right<br>
<blockquote type="cite"
cite="mid:etPan.65f33aae.280a1aa4.53d@rtwilson.com">
<div style="font-family:Helvetica,Arial;font-size:13px; "><br>
</div>
<div style="font-family:Helvetica,Arial;font-size:13px; ">For
context, is there a particular reason why this is only enabled
by default when you’re creating a new table?</div>
</blockquote>
<p>Yes, this is related to unique identifiers. At table creation,
one can make the reasonable expectation that no other process will
concurrently update the table since it didn't exist before. When
updating/appending, that hypothesis is less likely, hence it is
safer to fallback to the slower INSERT mode. I presume in the
Azure context that you have a client->server->client
round-trip at each feature insertion.</p>
<blockquote type="cite"
cite="mid:etPan.65f33aae.280a1aa4.53d@rtwilson.com">
<div style="font-family:Helvetica,Arial;font-size:13px; "><br>
</div>
<div style="font-family:Helvetica,Arial;font-size:13px; ">For what
it’s worth, I was running this on GDAL 3.8.3 - I checked it was
recent, but forgot to include it in my first email.</div>
<div style="font-family:Helvetica,Arial;font-size:13px; "><br>
</div>
<div style="font-family:Helvetica,Arial;font-size:13px; ">Thanks,</div>
<div style="font-family:Helvetica,Arial;font-size:13px; "><br>
</div>
<div style="font-family:Helvetica,Arial;font-size:13px; ">Robin</div>
<br>
</blockquote>
<br>
<pre class="moz-signature" cols="72">--
<a class="moz-txt-link-freetext" href="http://www.spatialys.com">http://www.spatialys.com</a>
My software is free, but my time generally not.</pre>
</body>
</html>