Bug report #6772

Categorized Style: if column is "character" and too long in PostGIS then style takes on null value

Added by Andrew Bell over 11 years ago. Updated over 5 years ago.

Category:Data Provider/PostGIS
Affected QGIS version:1.8.0 Regression?:No
Operating System: Easy fix?:No
Pull Request or Patch supplied:No Resolution:not reproducable
Crashes QGIS or corrupts data:No Copied to github as #:15923


On creating a categorized style on a layer coming out of PostGIS, the column I select is of a 'character' datatype and the character length in PosgreSQL is longer than the number of characters in the data. The result is all features take on a style of the null value. If you store varying length characters in the field it has the same effect.

It may not be good practice store data with less characters than the defined character length in a character field however it can happen and it took me sometime work out the problem, so a fix in QGIS would be ideal.


#1 Updated by Giovanni Manghi almost 7 years ago

  • Easy fix? set to No
  • Regression? set to No

#2 Updated by Giovanni Manghi about 6 years ago

  • Status changed from Open to Feedback

Please test with a recent QGIS release (2.18 or 3), if the issue/request is still valid change the affected version accordingly, if is fixed/implemented then close the ticket. Thanks!

#3 Updated by Giovanni Manghi over 5 years ago

  • Resolution set to not reproducable
  • Status changed from Feedback to Closed
  • Description updated (diff)

Closing for lack of feedback.

Also available in: Atom PDF