Impossible to edit database query results pane in services view
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
- Query is complex, e.g contains JOIN, static values, functions, and other modifications. Such results cannot be edited as columns belonging cannot be 100% identified
OR
- Table is not writable by DataGrip
Resolution
Update the appropriate 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)