Create new row (PostgreSQL)

I am using DataGrip to connect to a PostgreSQL database and everything works fine except for when I want to add a new row to any table. Everytime I enter a value in a column a red bar pops up saying '0 rows updated' and when I click on the 'details' link it also just says '0 rows updated'. When I completely fill all the columns and then commit the new row, it is correctly inserted. Do you have any idea why this might occur?

4 comments
Comment actions Permalink

Hello Raf,

"0 rows updated" messages indicate that no update statement was issues after the action. To submit a row update/insert please use Ctrl+Enter.

We have related usability issue about such a message, please vote for https://youtrack.jetbrains.com/issue/DBE-2051

0
Comment actions Permalink

I am having the same problem as Raf and it is very irritating. Not only does the error display, it covers up the row that I'm adding and I have to scroll after entering every field to see my work. It doesn't matter if you use the mouse, the arrow keys or tab, you get the error on every single field as you populate the row.

The link provided by Andrey for the issue results in a 404.

0
Comment actions Permalink

Hello Lori,

Please vote and follow the https://youtrack.jetbrains.com/issue/DBE-2096 . Please vote and follow for updates. Please see https://intellij-support.jetbrains.com/hc/en-us/articles/207241135 if you are not familiar with YouTrack.

Since 146.692 build there should be no such message obscuring the editing cell.

>The link provided by Andrey for the issue results in a 404.

Sorry there was a space at the end. I fixed the comment.

0
Comment actions Permalink

Thank you Andrey. I voted the issue. I didn't see 146.692 available yet. The EAP is only up to 145.735 (I'm running 143.2263 as the release build). Hopefully the updated will be pushed out as an official release very soon.

0

Please sign in to leave a comment.