JSON column from a Postgresql Database is working to read information, but when editing the column and saving it, an error occurs

[qgib]

Author Name: Felipe Souza (@felkis)
Original Redmine Issue: 21310
Affected QGIS version: 3.4.4
Redmine category:data_provider/postgis

---

The error seems to occur when saving from qgis back to Postgresql.

I´m connecting to a Postgresql Database, opening a table that has a json field. I see the data, and I´m trying to add an extra letter to a field. (attachment print).

The way I see, it seems that QGIS is sending back data as "hstore", but the column from my table is json.

ERROR ALERT:
Error PostGIS when changing attributes: ERROR: column "info" is of type jsonb but expression is of type hstore
LINE 1: ...TE "geometria"."plan_perimetro_urbano" SET "info"=E'"bike"=>...
^
HINT: You will need to rewrite or cast the expression.

---

• Screenshot121.png (Felipe Souza)

---

Related issue(s): #29133 (copied_to)
Redmine related issue(s): 21315

---

[qgib]

Author Name: Giovanni Manghi (@gioman)

---

I guess there is no support for this datatype, if confirmed then this would be a feature request (in the meantime please also check on 3.4.4/master so we can adjust the affected version to a recent one).

---

• status_id was changed from Open to Feedback

[qgib]

Author Name: Felipe Souza (@felkis)

---

Giovanni Manghi wrote:

I guess there is no support for this datatype, if confirmed then this would be a feature request (in the meantime please also check on 3.4.4/master so we can adjust the affected version to a recent one).

OK. I have just checked it with 3.4.4 and I got the same error!

[qgib]

Author Name: Giovanni Manghi (@gioman)

---

OK. I have just checked it with 3.4.4 and I got the same error!

that is not surprising. You should ask in the dev mailing list about the support for this data type, as said if this is not supported this must be changed to feature request.

---

• version was changed from 3.4.1 to 3.4.4

[qgib]

Author Name: Felipe Souza (@felkis)

---

• copied_to was configured as add support for editing JSON PostgreSQL datatype #29133

[qgib]

Author Name: Giovanni Manghi (@gioman)

---

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