<html><head><meta http-equiv="Content-Type" content="text/html; charset=UTF-8" /></head><body style='font-size: 10pt; font-family: Verdana,Geneva,sans-serif'>
<p>Hi,</p>
<p>ok - answering myself:</p>
<p>In the Postgis "Log Messages Panel" I get a hint:</p>
<p>---------------------</p>
<p>[ERROR: unsupported XML feature</p>
<p>DETAIL: This functionality requires the server to be built with libxml support.</p>
<p>HINT: You need to rebuild PostgreSQL using --with-libxml.</p>
<p>]</p>
<p>-----------------------------------------</p>
<p>So I need to recompile my PG Server and add support for libxml.</p>
<p>Andreas</p>
<p>On 2016-07-29 08:54, Neumann, Andreas wrote:</p>
<blockquote type="cite" style="padding: 0 0.4em; border-left: #1010ff 2px solid; margin: 0"><!-- html ignored --><!-- head ignored --><!-- meta ignored -->
<p>Hi,</p>
<p>Ok - I further investigated. It is not an issue of using services in the PG connection. Still having troubles saving styles in PG.</p>
<p>I created new connections with a PG admin user. I dropped the layer_styles table from the public schema.</p>
<p>When I save a style in PostgreSQL, the new empty table is created (so it can't be a permission thing because the user can create new tables) but then again the I get the error message:</p>
<p>"Unabe to save layer style. It's not possible to insert a new record in to the style table. Maybe this is due to table permissions (user=xxx). Please contact your database administrator."</p>
<p>----------------</p>
<p>I then also made sure that everybody can write to that table and that I don't use special characters in the style name.</p>
<p>What else could it be?</p>
<p>Thanks,</p>
<p>Andreas</p>
<p>On 2016-07-28 18:13, Andreas Neumann wrote:</p>
<blockquote style="padding: 0 0.4em; border-left: #1010ff 2px solid; margin: 0;">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 #cccccc; 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,</div>
<div>Harrissou</div>
<div class="gmail_extra"><br />
<div class="gmail_quote">2016-07-28 17:38 GMT+02:00 Neumann, Andreas <span><<a href="mailto:a.neumann@carto.net">a.neumann@carto.net</a>></span>:<br />
<blockquote class="gmail_quote" style="margin: 0px 0px 0px 0.8ex; border-left: 1px solid #cccccc; padding-left: 1ex;">
<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 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>
<p><span style="color: #888888;">Andreas</span></p>
<p> </p>
<div> </div>
</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 href="http://lists.osgeo.org/mailman/listinfo/qgis-user">http://lists.osgeo.org/mailman/listinfo/qgis-user</a><br /> Unsubscribe: <a href="http://lists.osgeo.org/mailman/listinfo/qgis-user">http://lists.osgeo.org/mailman/listinfo/qgis-user</a></blockquote>
</div>
</div>
</div>
</blockquote>
</div>
<br /> -- <br /> Diese Nachricht wurde von meinem Android-Mobiltelefon mit K-9 Mail gesendet.<br />
<div class="pre" style="margin: 0; padding: 0; font-family: monospace;">_______________________________________________<br /> Qgis-user mailing list<br /><a href="mailto:Qgis-user@lists.osgeo.org">Qgis-user@lists.osgeo.org</a><br /> List info: <a href="http://lists.osgeo.org/mailman/listinfo/qgis-user">http://lists.osgeo.org/mailman/listinfo/qgis-user</a><br /> Unsubscribe: <a href="http://lists.osgeo.org/mailman/listinfo/qgis-user">http://lists.osgeo.org/mailman/listinfo/qgis-user</a></div>
</blockquote>
<p> </p>
<div> </div>
<!-- html ignored --><br />
<div class="pre" style="margin: 0; padding: 0; font-family: monospace">_______________________________________________<br /> Qgis-user mailing list<br /><a href="mailto:Qgis-user@lists.osgeo.org">Qgis-user@lists.osgeo.org</a><br /> List info: <a href="http://lists.osgeo.org/mailman/listinfo/qgis-user">http://lists.osgeo.org/mailman/listinfo/qgis-user</a><br /> Unsubscribe: <a href="http://lists.osgeo.org/mailman/listinfo/qgis-user">http://lists.osgeo.org/mailman/listinfo/qgis-user</a></div>
</blockquote>
<p> </p>
<div> </div>
</body></html>