<html><head></head><body>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?<br><br><div class="gmail_quote">On July 28, 2016 6:08:01 PM CEST, DelazJ <delazj@gmail.com> wrote:<blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
<div dir="ltr"><div>Hi,<br />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.<br /><br /></div><div>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.<br /><br /></div><div>HTH,<br /></div><div>Harrissou<br /></div><div class="gmail_extra"><br /><div class="gmail_quote">2016-07-28 17:38 GMT+02:00 Neumann, Andreas <span dir="ltr"><<a target="_blank" href="mailto:a.neumann@carto.net">a.neumann@carto.net</a>></span>:<br /><blockquote style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex" class="gmail_quote"><div style="font-size:10pt;font-family:verdana,geneva,sans-serif">
<p>Hi,</p>
<p>I have never used the Saving/Loading of styles in Postgis (see <a target="_blank" href="http://docs.qgis.org/2.14/en/docs/user_manual/working_with_vector/vector_properties.html#storing-style-in-a-file-or-a-database">http://docs.qgis.org/2.14/en/docs/user_manual/working_with_vector/vector_properties.html#storing-style-in-a-file-or-a-database</a>)</p>
<p>Do I have to create a special styling table for it to enable this?</p>
<p>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.</p>
<p>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?</p>
<p>Thank you for any hints!</p><span class="gmail-HOEnZb"><font color="#888888">
</font><p><font color="#888888">Andreas</font></p>
<p> </p>
<div> </div>
</span></div>
<br />_______________________________________________<br />
Qgis-user mailing list<br />
<a href="mailto:Qgis-user@lists.osgeo.org">Qgis-user@lists.osgeo.org</a><br />
List info: <a target="_blank" rel="noreferrer" href="http://lists.osgeo.org/mailman/listinfo/qgis-user">http://lists.osgeo.org/mailman/listinfo/qgis-user</a><br />
Unsubscribe: <a target="_blank" rel="noreferrer" href="http://lists.osgeo.org/mailman/listinfo/qgis-user">http://lists.osgeo.org/mailman/listinfo/qgis-user</a><br /></blockquote></div><br /></div></div>
</blockquote></div><br>
-- <br>
Diese Nachricht wurde von meinem Android-Mobiltelefon mit K-9 Mail gesendet.</body></html>