Hi, ok - answering myself:
In the Postgis "Log Messages Panel" I get a hint: --------------------- [ERROR: unsupported XML feature DETAIL: This functionality requires the server to be built with libxml support. HINT: You need to rebuild PostgreSQL using --with-libxml. ] ----------------------------------------- So I need to recompile my PG Server and add support for libxml. Andreas On 2016-07-29 08:54, Neumann, Andreas wrote: > Hi, > > Ok - I further investigated. It is not an issue of using services in the PG > connection. Still having troubles saving styles in PG. > > I created new connections with a PG admin user. I dropped the layer_styles > table from the public schema. > > 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: > > "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." > > ---------------- > > I then also made sure that everybody can write to that table and that I don't > use special characters in the style name. > > What else could it be? > > Thanks, > > Andreas > > On 2016-07-28 18:13, Andreas Neumann wrote: 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 <del...@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.neum...@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@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. _______________________________________________ Qgis-user mailing list Qgis-user@lists.osgeo.org List info: http://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user _______________________________________________ Qgis-user mailing list Qgis-user@lists.osgeo.org List info: http://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user
_______________________________________________ Qgis-user mailing list Qgis-user@lists.osgeo.org List info: http://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user