[Qgis-user] Handle local layers in resources folder when project saved in PostgreSQL

[Alessandro Pasotti]

On Thu, Dec 5, 2019 at 11:58 AM Yann Voté <ygversil at lilo.org> wrote:

> Hi all,
>
> I can't find a solution to the following issue, or a way to work around
> it: I have created a project with some PostgreSQL layers to edit and
> some raster layers on local filesystem. I work on a Linux computer and
> have put the local layers into the pkg data path resources folder
> (/usr/share/qgis/resources/local/raster.gpkg).
>
>
Sorry but this is not a good idea, that path is usually not user-writeable
and should not be used to store any user related information.

But if I understand correctly what you were trying to do I'm afraid there
is not a solution: the concept of "relative path" means relative to the
project's storage path but that path does not make any sense in case of a
POSTGRES storage (because POSTGRES is not a local filesystem-based DB in
the same sense as GPKG or SPATIALITE are), so your file-system based asset
paths are not (and cannot be) converted to relative paths because there is
no project path we can relate to.

This makes portability an issue if the project has filesystem-based layers
(rasters in your case).

There is no solution I'm aware of, storing rasters into PG is also not a
viable option at the moment because support is currently buggy (see:
https://github.com/qgis/QGIS/issues/30392).

Cheers

I have also saved the project into PostgreSQL so that it can be shared
> easily. Other users work on Windows computers and have the same rasters
> under pkg data path resources folder
> (C:/PROGRAM~1/QGIS3~1.8/apps/qgis/resources/local/raster.gpkg). But when
> they open the project, Postgis layers are loaded fine, but QGIS says
> that raster.gpkg cannot be found under the /usr/share/... path.
>
> I would expect that layers in the pkg data path resources folder are
> saved with the inbuilt: prefix, but in fact they are not. Moreover, it
> seems that one cannot select "Relative" for saving layer paths, in
> project properties, when project is saved to PostgreSQL. Looks sensible
> (what is the relative path to a PostgreSQL table ?), but then what can I
> do to share a PostgreSQL project with local layers ?
>
> We all use QGIS 3.8.3.
>
> Thank you for any advice !
>
> Cheers
>
> Yann
> _______________________________________________
> 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



-- 
Alessandro Pasotti
w3:   www.itopen.it
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20191205/38c30c35/attachment.html>