Impossible to edit results pane in services view Follow
Symptoms
- Impossible to edit data that is shown for just executed query:
- One of the notifications is shown:
Table is read-only. Unresolved table reference
Connection is read-only.
- Tab name in the console output named "Result" instead of the name of a table.
Cause
- DataGrip allows editing data in the results tab only in simple cases like selecting the whole table. Queries with JOIN, static values, functions, and other modifications cannot be edited as columns belonging cannot be 100% identified
OR
- Table is not writable by DataGrip
Resolution
Update table manually via DataGrip or "UPDATE" query:
Please sign in to leave a comment.
Hi i'm having a similar issue but it appears randomly:
Sometimes if i select * from table.... and try updating it allows me, then later re-run the same query and it doesn't allow any more. then a few days later re-run exactly same query and again allows to update, why is that happening?
(note my query doesn't not have any joins or complicated where statements, and sometimes has a reduced column list, but not columns with any functions wrapped around)