Bug report #13395

Load style from database

Added by Kristyna Maresova about 9 years ago. Updated almost 9 years ago.

Status:Closed
Priority:High
Assignee:-
Category:Symbology
Affected QGIS version:2.10.1 Regression?:No
Operating System:Windows Easy fix?:No
Pull Request or Patch supplied:No Resolution:worksforme
Crashes QGIS or corrupts data:No Copied to github as #:21447

Description

When I save the style to postgres database in QGIS, it automatically saves the style in the table layer_styles in public scheme.

But when I want to reconnect it to the layer, it shows only all other layer styles without required one and in the window 'styles related to the layer' there is a message "No styles found in the database". Maybe there is a problem with connecting to the table's name.

Just for info: When I change the name of the table (f_table_name) manually in PGAdmin, the style can be opened from window 'other styles on the database'.

style3.JPG (321 KB) Kristyna Maresova, 2015-09-22 04:11 AM

History

#1 Updated by Anita Graser about 9 years ago

Can you please post a list of steps to reproduce the issue?

I wasn't able to reproduce the issue when I tried with today's OSGeo4W nightly.

#2 Updated by Jürgen Fischer about 9 years ago

  • Status changed from Open to Feedback

#3 Updated by Kristyna Maresova about 9 years ago

Anita Graser wrote:

Can you please post a list of steps to reproduce the issue?

I wasn't able to reproduce the issue when I tried with today's OSGeo4W nightly.

(1)I loaded layer from PostGIS database, (2) then I styled the layer, (3) saved it into the database(4)and make it default) and then (5)removed the layer from project. (6) When I loaded the layer again from database, the required style doesn't appear in the window 'styles related to this table'.

When I open different layer, the style for previous layer appears in window 'other styles on database'. Now I am working with todays OsGeo4W and it still doesn't work for me.

#4 Updated by Jérôme Guélat about 9 years ago

Same problem here using QGIS 2.12 on Windows.

#5 Updated by Giovanni Manghi almost 9 years ago

just tested on 2.12 on Win7 and QGIS master, and it works as expected.

#6 Updated by Giovanni Manghi almost 9 years ago

  • Resolution set to worksforme
  • Status changed from Feedback to Closed

closing for lack of feedback, please reopen of necessary.

Also available in: Atom PDF