[Qgis-user] Potential Bug in writing gpkg from database manager?

[Michael Treglia]

Alright - I get the exact same issue in the nightly dev version.  I thought
it might have been because I didn't have a primary key in the postgis
table, but had the same issue for a table that did have a primary key.

On Fri, Oct 5, 2018 at 4:16 PM Luigi Pirelli <luipir at gmail.com> wrote:

> exactly
>
> Luigi Pirelli
>
>
> **************************************************************************************************
> * LinkedIn: https://www.linkedin.com/in/luigipirelli
> * Stackexchange: http://gis.stackexchange.com/users/19667/luigi-pirelli
> * GitHub: https://github.com/luipir
> * Mastering QGIS 2nd Edition:
> *
> https://www.packtpub.com/big-data-and-business-intelligence/mastering-qgis-second-edition
> * Hire me: http://goo.gl/BYRQKg
>
> **************************************************************************************************
>
>
> On Fri, 5 Oct 2018 at 22:12, Michael Treglia <mtreglia at gmail.com> wrote:
>
>> Just to clarify, if installing via OSGeo4w, use QGIS-Dev: QGIS Nightly
>> build of the development branch (3.3.0-88)?
>>
>>
>>
>> On Fri, Oct 5, 2018 at 4:08 PM Luigi Pirelli <luipir at gmail.com> wrote:
>>
>>> may you check with master? 3.2 is at end of life.
>>>
>>> tnx
>>>
>>> Luigi Pirelli
>>>
>>>
>>> **************************************************************************************************
>>> * LinkedIn: https://www.linkedin.com/in/luigipirelli
>>> * Stackexchange: http://gis.stackexchange.com/users/19667/luigi-pirelli
>>> * GitHub: https://github.com/luipir
>>> * Mastering QGIS 2nd Edition:
>>> *
>>> https://www.packtpub.com/big-data-and-business-intelligence/mastering-qgis-second-edition
>>> * Hire me: http://goo.gl/BYRQKg
>>>
>>> **************************************************************************************************
>>>
>>>
>>> On Fri, 5 Oct 2018 at 21:59, Michael Treglia <mtreglia at gmail.com> wrote:
>>>
>>>> Whoops! Forgot the key information:
>>>> (Running on Windows 7 Pro x64)
>>>>
>>>> QGIS version
>>>>
>>>> 3.2.3-Bonn
>>>>
>>>> QGIS code revision
>>>>
>>>> 9b176802e5 <https://github.com/qgis/QGIS/commit/9b176802e5>
>>>>
>>>> Compiled against Qt
>>>>
>>>> 5.9.2
>>>>
>>>> Running against Qt
>>>>
>>>> 5.9.2
>>>>
>>>> Compiled against GDAL/OGR
>>>>
>>>> 2.2.4
>>>>
>>>> Running against GDAL/OGR
>>>>
>>>> 2.2.4
>>>>
>>>> Compiled against GEOS
>>>>
>>>> 3.6.1-CAPI-1.10.1
>>>>
>>>> Running against GEOS
>>>>
>>>> 3.6.1-CAPI-1.10.1 r0
>>>>
>>>> PostgreSQL Client Version
>>>>
>>>> 9.2.4
>>>>
>>>> SpatiaLite Version
>>>>
>>>> 4.3.0
>>>>
>>>> QWT Version
>>>>
>>>> 6.1.3
>>>>
>>>> QScintilla2 Version
>>>>
>>>> 2.10.1
>>>>
>>>> PROJ.4 Version
>>>>
>>>> 493
>>>>
>>>> On Fri, Oct 5, 2018 at 4:00 PM Michael Treglia <mtreglia at gmail.com>
>>>> wrote:
>>>>
>>>>> Hi All,
>>>>>
>>>>> Just checking if others are observing something similar:
>>>>> * 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.
>>>>> * 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.
>>>>>
>>>>> 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.
>>>>>
>>>>> 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).
>>>>>
>>>>> Mike
>>>>>
>>>>> _______________________________________________
>>>> Qgis-user mailing list
>>>> Qgis-user at lists.osgeo.org
>>>> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
>>>> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
>>>
>>>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20181005/d3c1a125/attachment.html>