[Qgis-user] Saving/Loading styles in Postgis

[Neumann, Andreas]

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 <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.
_______________________________________________
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 

_______________________________________________
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 

  
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20160729/320937bb/attachment.html>