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

postgresql datagrip
jnowak picture jnowak · Sep 22, 2015 · Viewed 14.9k times · Source

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

jnowak picture jnowak · Sep 22, 2015

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

Related questions

PostgreSQL: Show tables in PostgreSQL

What's the equivalent to show tables (from MySQL) in PostgreSQL?

Read More
PostgreSQL: How to change PostgreSQL user password?

How do I change the password for PostgreSQL user?

Read More
PostgreSQL "DESCRIBE TABLE"

How do you perform the equivalent of Oracle's DESCRIBE TABLE in PostgreSQL (using the psql command)?

Read More