Impossible to edit results pane in services view

Symptoms 

  • Impossible to edit data that is shown for just executed query: 

    mceclip0.png

  • 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: 

mceclip1.png

Please sign in to leave a comment.

Have more questions?

Submit a request