field overflow when saving style

[qgib]

Author Name: Russell Fulton (Russell Fulton)
Original Redmine Issue: 11067
Affected QGIS version: 2.4.0
Redmine category:symbology

---

The layer style table has a field "f_table_name" which is char_varying(256). The idea is clearly to but the table name in here if the style applies to a postgis table. Fine. If the table is something more complicated (like a join) QGIS puts the SQL in the that field. If the text of the sql is over 256 characters the save fails with a misleading message about permission problems.

Firstly I suggest that the message be changed to something along the lines of "QGIS failed to insert this style in public.layer_style table. Most often this is a permission problem. See QGIS log for more details."

I would suggest that either QGIS does not save the sql in the name field or that it checks and truncates it if necessary.

Hmmm... I just changed the field type to text and it works fine now -- so that is another approach.

[qgib]

Author Name: Giovanni Manghi (@gioman)

---

Hi,

it seems to me that in the "f_table_name" is always place the name of the layer you are styling (no SQL), regardless if that layers have joins or not.

Can you provide an example?

---

• priority_id was changed from Normal to Low
• status_id was changed from Open to Feedback
• category_id was configured as Symbology

[qgib]

Author Name: Giovanni Manghi (@gioman)

---

closing for lack of feedback, please reopen if necessary.

---

• resolution was changed from to invalid
• status_id was changed from Feedback to Closed