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
