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

1 comment
Comment actions Permalink

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)

0

Please sign in to leave a comment.

Have more questions?

Submit a request