Re: [Qgis-user] Saving/Loading styles in Postgis

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-boun...@lists.osgeo.org] IM AUFTRAG VON > Andreas Neumann >

Re: [Qgis-user] Saving/Loading styles in Postgis

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

Re: [Qgis-user] Saving/Loading styles in Postgis

yer styles records you must add the statement “SET xmloption TO DOCUMENT;”. Regards Burghardt Von: Qgis-user [mailto:qgis-user-boun...@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/Load

Re: [Qgis-user] Saving/Loading styles in Postgis

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

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 wrote: >Hi, >Andreas, Styles are indeed saved in

[Qgis-user] Saving/Loading styles in Postgis

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