add support for editing JSON PostgreSQL datatype

[qgib]

Author Name: Felipe Souza (@felkis)
Original Redmine Issue: 21315

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): #29128 (copied_to)
Redmine related issue(s): 21310

---

[qgib]

Author Name: Felipe Souza (@felkis)

---

• copied_from was configured as JSON column from a Postgresql Database is working to read information, but when editing the column and saving it, an error occurs #29128

[qgib]

Author Name: Giovanni Manghi (@gioman)

---

• status_id was changed from Feedback to Open
• subject was changed from JSON column from a Postgresql Database is working to read information, but when editing the column and saving it, an error occurs to add support for editing JSON PostgreSQL datatype

[qgib]

Author Name: Felipe Souza (@felkis)

---

This can be a great tool when you don´t want the user to change the default data from your table, but you let them create filters.
Any news on this?
Thank you.

Felipe Souza wrote:

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.

---

• assigned_to_id was configured as Giovanni Manghi

[qgib]

Author Name: Giovanni Manghi (@gioman)

---

• assigned_to_id removed Giovanni Manghi

[stev-0]

This is likely related to #29361