datagrip Cannot apply changes This table is read o

2019-01-26 04:59发布

问题:

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.

回答1:

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



回答2:

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



回答3:

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



回答4:

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.



回答5:

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.