<div dir="ltr">As a quick follow-up - it seems like maybe the first numeric or integer column gets assigned to an FID column, but the original column name stays there with all values from other numeric/integer columns ending up apparently shifted over to the left one, because there's an extra column.<br></div><br><div class="gmail_quote"><div dir="ltr">On Fri, Oct 5, 2018 at 4:01 PM Michael Treglia <<a href="mailto:mtreglia@gmail.com">mtreglia@gmail.com</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr"><div>Whoops! Forgot the key information:</div><div>(Running on Windows 7 Pro x64)<br></div><div><br></div><div>

<table style="margin:0px" width="100%" cellspacing="2" cellpadding="0" border="0" align="center">
<tbody><tr>
<td>
<p style="margin:0px;text-indent:0px;white-space:pre-wrap">QGIS version</p></td>
<td>
<p style="margin:0px;text-indent:0px;white-space:pre-wrap">3.2.3-Bonn</p></td>
<td>
<p style="margin:0px;text-indent:0px;white-space:pre-wrap">QGIS code revision</p></td>
<td>
<p style="margin:0px;text-indent:0px;white-space:pre-wrap"><a href="https://github.com/qgis/QGIS/commit/9b176802e5" target="_blank"><span style="text-decoration:underline;color:rgb(0,0,255)">9b176802e5</span></a></p></td></tr>
<tr>
<td>
<p style="margin:0px;text-indent:0px;white-space:pre-wrap">Compiled against Qt</p></td>
<td>
<p style="margin:0px;text-indent:0px;white-space:pre-wrap">5.9.2</p></td>
<td>
<p style="margin:0px;text-indent:0px;white-space:pre-wrap">Running against Qt</p></td>
<td>
<p style="margin:0px;text-indent:0px;white-space:pre-wrap">5.9.2</p></td></tr>
<tr>
<td>
<p style="margin:0px;text-indent:0px;white-space:pre-wrap">Compiled against GDAL/OGR</p></td>
<td>
<p style="margin:0px;text-indent:0px;white-space:pre-wrap">2.2.4</p></td>
<td>
<p style="margin:0px;text-indent:0px;white-space:pre-wrap">Running against GDAL/OGR</p></td>
<td>
<p style="margin:0px;text-indent:0px;white-space:pre-wrap">2.2.4</p></td></tr>
<tr>
<td>
<p style="margin:0px;text-indent:0px;white-space:pre-wrap">Compiled against GEOS</p></td>
<td>
<p style="margin:0px;text-indent:0px;white-space:pre-wrap">3.6.1-CAPI-1.10.1</p></td>
<td>
<p style="margin:0px;text-indent:0px;white-space:pre-wrap">Running against GEOS</p></td>
<td>
<p style="margin:0px;text-indent:0px;white-space:pre-wrap">3.6.1-CAPI-1.10.1 r0</p></td></tr>
<tr>
<td>
<p style="margin:0px;text-indent:0px;white-space:pre-wrap">PostgreSQL Client Version</p></td>
<td>
<p style="margin:0px;text-indent:0px;white-space:pre-wrap">9.2.4</p></td>
<td>
<p style="margin:0px;text-indent:0px;white-space:pre-wrap">SpatiaLite Version</p></td>
<td>
<p style="margin:0px;text-indent:0px;white-space:pre-wrap">4.3.0</p></td></tr>
<tr>
<td>
<p style="margin:0px;text-indent:0px;white-space:pre-wrap">QWT Version</p></td>
<td>
<p style="margin:0px;text-indent:0px;white-space:pre-wrap">6.1.3</p></td>
<td>
<p style="margin:0px;text-indent:0px;white-space:pre-wrap">QScintilla2 Version</p></td>
<td>
<p style="margin:0px;text-indent:0px;white-space:pre-wrap">2.10.1</p></td></tr>
<tr>
<td>
<p style="margin:0px;text-indent:0px;white-space:pre-wrap">PROJ.4 Version</p></td>
<td colspan="3">
<p style="margin:0px;text-indent:0px;white-space:pre-wrap">493</p></td></tr></tbody></table></div></div><br><div class="gmail_quote"><div dir="ltr">On Fri, Oct 5, 2018 at 4:00 PM Michael Treglia <<a href="mailto:mtreglia@gmail.com" target="_blank">mtreglia@gmail.com</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr"><div>Hi All,</div><div><br></div><div>Just checking if others are observing something similar:</div><div>* I was writing data to gpkg files from a postgis database.from the Database Manager. (e.g., select a layer from the PostGIS database and hit the "export to file" button at the top.</div><div>* The resulting gpkg layer loses data in a column towards the left, but all of the headings are maintained. Thus, data are shifted to the left one column from a certain point on, and the last column has NULLs.</div><div><br></div><div>If writing into an existing gpkg file, dragging and dropping the layer from the PostGIS db into the gpkg file and selecting appropriate options in the dialogue box that pops up does not have that issue.<br></div><div><br></div><div>I'm still trying to see exactly what's going on, but figured I'd see if this is something others are experiencing (or if it's already been reported).</div><div><br></div><div>Mike<br></div><div><br></div></div>
</blockquote></div>
</blockquote></div>