[QGIS-Developer] bug or feature? layer_styles table created not in the public schema

Paolo Cavallini cavallini at faunalia.it
Sat Sep 5 15:05:33 PDT 2020


This follows the search_path setting.
Cheers.

On 5 September 2020 23:38:03 CEST, Giovanni Manghi <giovanni.manghi at gmail.com> wrote:
>Hi all,
>by chance I noticed the following:
>
>If in a PostgreSQL DB exists a schema that has the same name as a user
>that has full permissions on that schema, then if the user saves a
>style to the DB this is saved in a  "layer_styles" table in this
>schema, not public.
>
>Moreover if the user tries to load a style from the DB it only sees
>the styles in this "secondary" layer_styles table, not the one in
>public.
>
>Feature or bug?
>
>Seems strange it is by chance, anyway if it is implemented so by
>design I think that in the "load style from DB" menu is missing the
>option to choose in what schema look for, like the similar menu for
>loading projects from DB.
>
>Opinions?
>
>cheers
>
>-- G --
>_______________________________________________
>QGIS-Developer mailing list
>QGIS-Developer at lists.osgeo.org
>List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer
>Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer

-- 
Please excuse my brevity.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-developer/attachments/20200906/3def305d/attachment.html>


More information about the QGIS-Developer mailing list