I use PostgreSQL 9.3 and Valentina Studio 5.8.8. It is the great software! But Data Editor has the bug with a json field editing.
For example I have a table with one json field wich contains {"a":1} value.
The error occurs when I changed it(directly or through Content Editor) and try to save:
ERROR: operator does not exist: json=unknown
No operator matches the given name and argument type(s). You might need to add explicit type casts.
Query log:
UPDATE "my_schema"."my_table" SET "json_field" = $1 WHERE ( "json_field" = $2 )
-- $1 : '{"a":2}' instead of '{"a":1}'
-- $2 : '{"a":1}'
It seems a casting of variable is not proper.
Thanx for any comments.