[Qgis-user] Saving/Loading styles in Postgis

[Andreas Neumann]

Strange. I can see the empty layer_styles table in my public schema. But saving fails. Maybe it fails because my PG connection is based on a service definition and not on host/database?

On July 28, 2016 6:08:01 PM CEST, DelazJ <delazj at gmail.com> wrote:
>Hi,
>Andreas,  Styles are indeed saved in the public schema, in a table
>named
>"layer_styles". I had never created such a table so I assume it's
>created
>by QGIS.
>
>Just made a test and rename my current "layer_styles" table. Then I
>successfully save a new layer style in PG from QGIS 2.16: a new table
>"layer_styles" has automatically been created in the public schema.
>
>HTH,
>Harrissou
>
>2016-07-28 17:38 GMT+02:00 Neumann, Andreas <a.neumann at carto.net>:
>
>> Hi,
>>
>> I have never used the Saving/Loading of styles in Postgis (see
>>
>http://docs.qgis.org/2.14/en/docs/user_manual/working_with_vector/vector_properties.html#storing-style-in-a-file-or-a-database
>> )
>>
>> Do I have to create a special styling table for it to enable this?
>>
>> Because when I try to save it (QGIS 2.16) I get an error message
>along the
>> lines that my user may not have permissions to save the style.
>However, I
>> am trying to save the style with a user that has full administrator
>rights
>> in Postgis.
>>
>> In what schema and table are the styles stored? I assume in the
>public
>> schema. Will QGIS automatically create a styling table or do I have
>to
>> create one myself?
>>
>> Thank you for any hints!
>>
>> Andreas
>>
>>
>>
>>
>> _______________________________________________
>> Qgis-user mailing list
>> Qgis-user at lists.osgeo.org
>> List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
>> Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user
>>

-- 
Diese Nachricht wurde von meinem Android-Mobiltelefon mit K-9 Mail gesendet.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20160728/0455a10e/attachment.html>