datagrip Cannot apply changes This table is read o

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

The only thing that actually worked for me, after trying everything above multiple times, was deleting each DB connection and remaking a new one from scratch.

Answer 2

Set and clear Read-only in Data Source Properties helps me.

Answer 3

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

Answer 4

Nothing worked. I had to update DataGrip from 2017.2 to 2018.3

I had to open the project by navigating to: /home/user/.DataGrip2017.2/config/projects/my_project/

All my scripts for this project as I did not want to import the config from the old version of Datagrip. So I'll probably need to downgrade, get the scripts and upgrade again.

Answer 5

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