Bug report #2486
Unique value symbology doesn't work in canvas with postgres "character" data type
|Affected QGIS version:||master||Regression?:||No|
|Operating System:||Windows||Easy fix?:||No|
|Pull Request or Patch supplied:||No||Resolution:||end of life|
|Crashes QGIS or corrupts data:||No||Copied to github as #:||12546|
If a unique value symbology is applied to a PostGIS layer with a data type "character", it can be formatted normally in the layer properties dialog with expected results in the "Layers" pane. However, the lines are not formatted in the map canvas as expected, as all lines use the "default" (blank) classification.
A possible cause of the problem is that the data type "character" will pad spaces to the specified width, for example "food" stored in character(5) will actually be "food ", having a trailing space to fit 5 characters.
As a workaround, change the postgres data type in problem columns to "character varying", if possible.
#10 Updated by Giovanni Manghi over 2 years ago
- Status changed from Open to Closed
- Resolution changed from worksforme to end of life
End of life notice: QGIS 2.18 LTR