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
>
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.
]
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 tabl
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/Loading
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
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 the public schema,