[Qgis-user] Saving/Loading styles in Postgis

[Neumann, Andreas]

Hi Burghardt, 

Thanks for the hint. I will keep an eye on dump and restore regarding
the XMLParser. That sounds like an annoying workaround. Hopefully there
can be a better solution rather than having to edit dump files before
restores. 

This is a completely new, self-compiled PostgresQL/Postgis server with
all the newest libraries and versions. Obviously, when compiling, I
missed the XML bit - because personally I did not need XML support so
far. 

Looking forward to get this working, 

Andreas 

On 2016-07-29 07:52, Burghardt.Scholle at stadt.wolfsburg.de wrote:

> Hi Andreas, 
> 
> To save the layer styles in a PG table is a cool feature J. I have no problems to save the table with a connection based on host/database. 
> 
> A hint from me: QGIS stores the style-information with the data type "xml". For me this made problems when exporting / importing this data. By default, the XMLPARSER from postgresql works with the "CONTENT" option. When importing a dump file from the "layer styles"-table you get an error message: "ERROR: invalid XML content". To prevent this, you need to edit the dump file. Before the insert / copy command to insert the layer styles records you must add the statement "SET xmloption TO DOCUMENT;". 
> 
> Regards 
> 
> Burghardt 
> 
> VON: Qgis-user [mailto:qgis-user-bounces at lists.osgeo.org] IM AUFTRAG VON Andreas Neumann
> GESENDET: Donnerstag, 28. Juli 2016 18:14
> AN: DelazJ
> CC: QGIS User List
> BETREFF: Re: [Qgis-user] Saving/Loading styles in Postgis 
> 
> 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 [1]
> Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user [1] 
> 
> -- 
> Diese Nachricht wurde von meinem Android-Mobiltelefon mit K-9 Mail gesendet.

  

Links:
------
[1] 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/c2255b10/attachment.html>