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

[Michael Treglia]

I'll file a bug when I can deal with an issue logging into the issue
tracker system, but if somebody else can do it quickly and beats it to me,
just report back. Thanks all!

On Fri, Oct 5, 2018 at 4:29 PM Michael Treglia <mtreglia at gmail.com> wrote:

> 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/1d9c0aac/attachment.html>