datagrip Cannot apply changes This table is read only. Cell editor changes cannot be applied

Question

So simply the problem occurs when I want to edit selected rows and then apply it. I'm sure it worked some time ago. Tried redownload postgres driver in preferences(yeah, I use postgres) Anyone faced same issue? Anyone succeed?

PS. Running on 142.4861.1.

I found read only checkbox in connection preferences, it was not set, toggling didn't help, upgrading, reseting also didn't help.

Answer 1

In my case in version 2020.1 of DataGrip (SQL was run from the opened file, on unique table, so that select just worked as expected, but when I was trying to edit - error appeared: unresolved table reference): specifying schemes in request helped. So that SELECT * FROM users; was changed to SELECT * FROM schemadb.users; and that helped. Probably there is a bug. I've tried all the methods mentioned above.

Answer 2

What actually helped was toggling Auto-commit checkbox in console, after that everything runs flawlessly.

Answer 3

Try synchronize database connection. It helped me in mysql connection.

Answer 4

This can be due to default settings, make it sure your your transaction Mode settings are as below