DataGrip Unable to add new rows from the tool
I am trying to add new rows through the UI. However, the add new row button is disabled for me. How do you enable the add new row button? Tried to use the shortcut command + N, but doesn't work for me.
Note: I tried to synch the schema, still doesn't work for me. Also, I am able to insert into the database by running scripts so there is no permission issue unless I need to explicitly let datagrip configure for inserts.
I also tried all the steps, still not able to insert:
- Click Command + D to clone on the toolbar.
- Right-click the table and select Add New Row from the context menu.
Press⌘N.
datagrip
asked Nov 20 at 18:59
Karan Sharma
757
add a comment |
I am trying to add new rows through the UI. However, the add new row button is disabled for me. How do you enable the add new row button? Tried to use the shortcut command + N, but doesn't work for me.
Note: I tried to synch the schema, still doesn't work for me. Also, I am able to insert into the database by running scripts so there is no permission issue unless I need to explicitly let datagrip configure for inserts.
I also tried all the steps, still not able to insert:
- Click Command + D to clone on the toolbar.
- Right-click the table and select Add New Row from the context menu.
Press⌘N.
datagrip
asked Nov 20 at 18:59
Karan Sharma
757
is the table locked ?
– Himanshu Ahuja
Nov 20 at 19:07
Possible duplicate of IntelliJ DataGrip how to enable add row?
– Himanshu Ahuja
Nov 20 at 19:27
No, the table isn't locked. I tried to synch the schema as mentioned in the post but that doesn't solve the problem.
– Karan Sharma
Nov 20 at 19:37
Please, show a query to get this result.
– moscas
Nov 21 at 11:40
What database do you use? Aren't you in Read-only mode?
– moscas
Nov 30 at 15:34
add a comment |
I am trying to add new rows through the UI. However, the add new row button is disabled for me. How do you enable the add new row button? Tried to use the shortcut command + N, but doesn't work for me.
Note: I tried to synch the schema, still doesn't work for me. Also, I am able to insert into the database by running scripts so there is no permission issue unless I need to explicitly let datagrip configure for inserts.
I also tried all the steps, still not able to insert:
- Click Command + D to clone on the toolbar.
- Right-click the table and select Add New Row from the context menu.
Press⌘N.
datagrip
asked Nov 20 at 18:59
Karan Sharma
757
I am trying to add new rows through the UI. However, the add new row button is disabled for me. How do you enable the add new row button? Tried to use the shortcut command + N, but doesn't work for me.
Note: I tried to synch the schema, still doesn't work for me. Also, I am able to insert into the database by running scripts so there is no permission issue unless I need to explicitly let datagrip configure for inserts.
I also tried all the steps, still not able to insert:
- Click Command + D to clone on the toolbar.
- Right-click the table and select Add New Row from the context menu.
Press⌘N.
datagrip
datagrip
asked Nov 20 at 18:59
Karan Sharma
757
asked Nov 20 at 18:59
Karan Sharma
757
edited Nov 20 at 19:52
asked Nov 20 at 18:59
Karan Sharma
757
asked Nov 20 at 18:59
Karan Sharma
757
asked Nov 20 at 18:59
Karan Sharma
757
757
is the table locked ?
– Himanshu Ahuja
Nov 20 at 19:07
Possible duplicate of IntelliJ DataGrip how to enable add row?
– Himanshu Ahuja
Nov 20 at 19:27
No, the table isn't locked. I tried to synch the schema as mentioned in the post but that doesn't solve the problem.
– Karan Sharma
Nov 20 at 19:37
Please, show a query to get this result.
– moscas
Nov 21 at 11:40
What database do you use? Aren't you in Read-only mode?
– moscas
Nov 30 at 15:34
add a comment |
is the table locked ?
– Himanshu Ahuja
Nov 20 at 19:07
Possible duplicate of IntelliJ DataGrip how to enable add row?
– Himanshu Ahuja
Nov 20 at 19:27
No, the table isn't locked. I tried to synch the schema as mentioned in the post but that doesn't solve the problem.
– Karan Sharma
Nov 20 at 19:37
Please, show a query to get this result.
– moscas
Nov 21 at 11:40
What database do you use? Aren't you in Read-only mode?
– moscas
Nov 30 at 15:34
is the table locked ?
– Himanshu Ahuja
Nov 20 at 19:07
is the table locked ?
– Himanshu Ahuja
Nov 20 at 19:07
Possible duplicate of IntelliJ DataGrip how to enable add row?
– Himanshu Ahuja
Nov 20 at 19:27
Possible duplicate of IntelliJ DataGrip how to enable add row?
– Himanshu Ahuja
Nov 20 at 19:27
No, the table isn't locked. I tried to synch the schema as mentioned in the post but that doesn't solve the problem.
– Karan Sharma
Nov 20 at 19:37
No, the table isn't locked. I tried to synch the schema as mentioned in the post but that doesn't solve the problem.
– Karan Sharma
Nov 20 at 19:37
Please, show a query to get this result.
– moscas
Nov 21 at 11:40
Please, show a query to get this result.
– moscas
Nov 21 at 11:40
What database do you use? Aren't you in Read-only mode?
– moscas
Nov 30 at 15:34
What database do you use? Aren't you in Read-only mode?
– moscas
Nov 30 at 15:34
add a comment |
2 Answers
2
active
oldest
votes
Most of UI database need unique keys to enable insert / update / delete.
Look at also the source if it's a query non updatable.
answered Nov 20 at 19:13
phili_b
8611
add a comment |
Just right click your scheme then click synchronize or you can use ctrl + alt + y as shortcut this will refresh your db model else use clone command (ctrl + d) . If that also doesnt work just restore the settings to default.
answered Nov 20 at 19:12
Himanshu Ahuja
402215
I tried doing this. But doesn't work for me. I tried to reconnect to the database too still no luck.
– Karan Sharma
Nov 20 at 19:34
I think your table is locked for any changes take some grant permissions for insert atleast
– Himanshu Ahuja
Nov 20 at 19:37
I am able to execute the insert statements in the SQL editor. So that rules out the permission issue.
– Karan Sharma
Nov 20 at 19:38
use ctrl + d to clone the row
– Himanshu Ahuja
Nov 20 at 19:44
add a comment |
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53399799%2fdatagrip-unable-to-add-new-rows-from-the-tool%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
2 Answers
2
active
oldest
votes
2 Answers
2
active
oldest
votes
active
oldest
votes
active
oldest
votes
Most of UI database need unique keys to enable insert / update / delete.
Look at also the source if it's a query non updatable.
answered Nov 20 at 19:13
phili_b
8611
add a comment |
Most of UI database need unique keys to enable insert / update / delete.
Look at also the source if it's a query non updatable.
answered Nov 20 at 19:13
phili_b
8611
add a comment |
Most of UI database need unique keys to enable insert / update / delete.
Look at also the source if it's a query non updatable.
answered Nov 20 at 19:13
phili_b
8611
Most of UI database need unique keys to enable insert / update / delete.
Look at also the source if it's a query non updatable.
answered Nov 20 at 19:13
phili_b
8611
answered Nov 20 at 19:13
phili_b
8611
answered Nov 20 at 19:13
phili_b
8611
answered Nov 20 at 19:13
phili_b
8611
8611
add a comment |
add a comment |
Just right click your scheme then click synchronize or you can use ctrl + alt + y as shortcut this will refresh your db model else use clone command (ctrl + d) . If that also doesnt work just restore the settings to default.
answered Nov 20 at 19:12
Himanshu Ahuja
402215
I tried doing this. But doesn't work for me. I tried to reconnect to the database too still no luck.
– Karan Sharma
Nov 20 at 19:34
I think your table is locked for any changes take some grant permissions for insert atleast
– Himanshu Ahuja
Nov 20 at 19:37
I am able to execute the insert statements in the SQL editor. So that rules out the permission issue.
– Karan Sharma
Nov 20 at 19:38
use ctrl + d to clone the row
– Himanshu Ahuja
Nov 20 at 19:44
add a comment |
Just right click your scheme then click synchronize or you can use ctrl + alt + y as shortcut this will refresh your db model else use clone command (ctrl + d) . If that also doesnt work just restore the settings to default.
answered Nov 20 at 19:12
Himanshu Ahuja
402215
I tried doing this. But doesn't work for me. I tried to reconnect to the database too still no luck.
– Karan Sharma
Nov 20 at 19:34
I think your table is locked for any changes take some grant permissions for insert atleast
– Himanshu Ahuja
Nov 20 at 19:37
I am able to execute the insert statements in the SQL editor. So that rules out the permission issue.
– Karan Sharma
Nov 20 at 19:38
use ctrl + d to clone the row
– Himanshu Ahuja
Nov 20 at 19:44
add a comment |
Just right click your scheme then click synchronize or you can use ctrl + alt + y as shortcut this will refresh your db model else use clone command (ctrl + d) . If that also doesnt work just restore the settings to default.
answered Nov 20 at 19:12
Himanshu Ahuja
402215
Just right click your scheme then click synchronize or you can use ctrl + alt + y as shortcut this will refresh your db model else use clone command (ctrl + d) . If that also doesnt work just restore the settings to default.
answered Nov 20 at 19:12
Himanshu Ahuja
402215
edited Nov 20 at 19:43
answered Nov 20 at 19:12
Himanshu Ahuja
402215
answered Nov 20 at 19:12
Himanshu Ahuja
402215
answered Nov 20 at 19:12
Himanshu Ahuja
402215
402215
I tried doing this. But doesn't work for me. I tried to reconnect to the database too still no luck.
– Karan Sharma
Nov 20 at 19:34
I think your table is locked for any changes take some grant permissions for insert atleast
– Himanshu Ahuja
Nov 20 at 19:37
I am able to execute the insert statements in the SQL editor. So that rules out the permission issue.
– Karan Sharma
Nov 20 at 19:38
use ctrl + d to clone the row
– Himanshu Ahuja
Nov 20 at 19:44
add a comment |
I tried doing this. But doesn't work for me. I tried to reconnect to the database too still no luck.
– Karan Sharma
Nov 20 at 19:34
I think your table is locked for any changes take some grant permissions for insert atleast
– Himanshu Ahuja
Nov 20 at 19:37
I am able to execute the insert statements in the SQL editor. So that rules out the permission issue.
– Karan Sharma
Nov 20 at 19:38
use ctrl + d to clone the row
– Himanshu Ahuja
Nov 20 at 19:44
I tried doing this. But doesn't work for me. I tried to reconnect to the database too still no luck.
– Karan Sharma
Nov 20 at 19:34
I tried doing this. But doesn't work for me. I tried to reconnect to the database too still no luck.
– Karan Sharma
Nov 20 at 19:34
I think your table is locked for any changes take some grant permissions for insert atleast
– Himanshu Ahuja
Nov 20 at 19:37
I think your table is locked for any changes take some grant permissions for insert atleast
– Himanshu Ahuja
Nov 20 at 19:37
I am able to execute the insert statements in the SQL editor. So that rules out the permission issue.
– Karan Sharma
Nov 20 at 19:38
I am able to execute the insert statements in the SQL editor. So that rules out the permission issue.
– Karan Sharma
Nov 20 at 19:38
use ctrl + d to clone the row
– Himanshu Ahuja
Nov 20 at 19:44
use ctrl + d to clone the row
– Himanshu Ahuja
Nov 20 at 19:44
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53399799%2fdatagrip-unable-to-add-new-rows-from-the-tool%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
is the table locked ?
– Himanshu Ahuja
Nov 20 at 19:07
Possible duplicate of IntelliJ DataGrip how to enable add row?
– Himanshu Ahuja
Nov 20 at 19:27
No, the table isn't locked. I tried to synch the schema as mentioned in the post but that doesn't solve the problem.
– Karan Sharma
Nov 20 at 19:37
Please, show a query to get this result.
– moscas
Nov 21 at 11:40
What database do you use? Aren't you in Read-only mode?
– moscas
Nov 30 at 15:34