Bug report #14884
Updated by Regis Haubourg about 7 years ago
I have saved a layer style into my PostgreSQL datasource and selected the 'Use as default style for this layer' checkbox. I save my project and close QGIS. I then change some aspect of the style directly in the database XML- 'layer_styles' table, 'styleqml' field (I edited the 'outline_width' value for a simple renderer as a test). I then save the database record and restart QGIS. The amended style is not loaded from PostGIS and instead the last 'local' copy is loaded - i.e. before the changes I made. The behaviour I expected was that the layer style would be loaded from PostGIS (I verified that the 'useasdefault' field value was 'TRUE').
I have described the issue here: https://gis.stackexchange.com/questions/194607/qgis-not-loading-default-layer-style-from-postgresql-database-on-startup and can confirm that it is still an issue with QGIS 2.14.2. I'd be happy to provide the data that I am using so it can be tested on your systems.
Many thanks
Bruce Steedman
I have described the issue here: https://gis.stackexchange.com/questions/194607/qgis-not-loading-default-layer-style-from-postgresql-database-on-startup and can confirm that it is still an issue with QGIS 2.14.2. I'd be happy to provide the data that I am using so it can be tested on your systems.
Many thanks
Bruce Steedman