I have fields in my DB (PostgreSQL 9.5) with type JSON.
Often (but not always) attempt to update/insert (or just copy from another row) value in JSON field (from table view) leads to:
INSERT INTO "document"."types" ("id", "resultset", "name", "template", "for") VALUES (?, ?, ?, ?, ?);
 ERROR: column "for" is of type json but expression is of type character varying
Hint: You will need to rewrite or cast the expression.
Am I doing wrong or missing something?
Any way to see how exactly DataGrip sending values to DB?
Build #DB-172.4155.28, built on September 6, 2017