[Qgis-user] DB Manager:"Load as new layer" query from point data returns invisible poylgon layer

[Bernd Vogelgesang]

Hi,

it seems that my project was somehow broken. After a while zooming out
froze the application. After setting up everything from zero, the "Load
as new layer" button works as expected. Great!

Big "but": When such a layer (is it a virtual layer?) is present in the
project, I can't edit the underlying GeoPackage anymore. Trying to add
an entry to a table (which of course will change the query result of the
new layer), an error is thrown that the database is locked. Afterwards
all layers from the geopackage even disappear from thecanvas and I can't
even reconnect to the database in DB Manager, so I have to restart QGIS.

Removing this virtual layer from the project enables editing of the
tables again.

This is somehow unpleasant, cause I thought that I finally found a way
to easily indicate the points I still have to work on through a query,
but it seems that visualizing and editing the source at the same time is
not possible :(

With sad greetings,,

Bernd

Am 29.04.19 um 15:27 schrieb Bernd Vogelgesang:
>
> Hi Alessandro,
>
> forgot to mention that I'm on 3.6.2 on Linux Mint. At the moment I
> have no running instance of master, so I can't check if it is resolved
> there.
>
> Added sth to https://issues.qgis.org/issues/21675
>
> Cheers,
>
> Bernd
>
> Am 29.04.19 um 14:11 schrieb Alessandro Pasotti:
>>
>> On Mon, Apr 29, 2019 at 2:00 PM Bernd Vogelgesang
>> <bernd.vogelgesang at gmx.de <mailto:bernd.vogelgesang at gmx.de>> wrote:
>>
>>     Hi,
>>
>>     maybe I miss something obvious, but I can't manage to produce a new
>>     point layer from a query in the DB Manager from a point dataset
>>     (First
>>     time going this route, and very old sql-knowledge only).
>>
>>     The query runs fine, I see the results, but when I hit the "Load
>>     as new
>>     layer"-button, it adds a new polygon-layer name"QueryLayer" and of
>>     course nothing is visible.
>>
>>     When I create a new virtual layer and paste my query there, it
>>     works and
>>     adds a new point layer from my query.
>>
>>     But it seems a bit strange that I have to produce a query, and
>>     then copy
>>     it to another section while there is a "load as new layer"-button
>>     available.
>>
>>     Any hints?
>>
>>
>> Several issues like this have been fixed in the past, please check
>> newest releases and if that does not work please file a ticket
>> (attaching test project & data plus the failing queries).
>>
>> Kind regards.
>>
>> --
>> Alessandro Pasotti
>> w3: www.itopen.it <http://www.itopen.it>
>
> _______________________________________________
> 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/20190430/37a0e6cf/attachment.html>