Can't edit any tables in one MySQL db

Note: please leave bug reports and feature requests on

Can't edit any tables in one MySQL db

Postby codebling » Tue May 22, 2012 4:37 pm

I'm connected to a MySQL server as the root user. Other databases on that server are fine, but I can't edit one particular database. Update, insert and deletes work fine from the SQL Editor window, but the delete button is grayed out, and so are the 'Save' and 'Set NULL' buttons when I try to edit a cell. I can't figure out why this is the only db that I can't edit.

Thanks making a really great product, Serge!
codebling
 
Posts: 79
Joined: Tue May 22, 2012 4:15 pm

Re: Can't edit any tables in one MySQL db

Postby Serge » Wed May 23, 2012 7:31 am

Hi!

At the moment DBeaver can edit table only if it has at least one unique key or index. Otherwise row edit is always an ambigous operation. Generally only new row addition may be permitted in this case.
In some future version we'll add logical keys (which may be defined by user on client side) to allow editing of such tables.

Thanks!
Serge
 
Posts: 1526
Joined: Sat Feb 26, 2011 8:24 pm
Location: SPb

Re: Can't edit any tables in one MySQL db

Postby codebling » Wed May 23, 2012 6:06 pm

Ah, that's it! Thanks, not only did I fix the problem but I realised that I forgot to make the index unique :)

Oracle SQLDeveloper uses a row index for its updates but I know this is a concept specific to Oracle. Guess you already know what you're doing though. :) Thanks for the help !
codebling
 
Posts: 79
Joined: Tue May 22, 2012 4:15 pm

Re: Can't edit any tables in one MySQL db

Postby EugeneJF » Thu May 24, 2012 11:35 am

EugeneJF
 
Posts: 42
Joined: Mon Feb 28, 2011 10:04 am

Re: Can't edit any tables in one MySQL db

Postby Serge » Thu May 24, 2012 2:34 pm

Serge
 
Posts: 1526
Joined: Sat Feb 26, 2011 8:24 pm
Location: SPb


Return to Support



Who is online

Users browsing this forum: Majestic-12 [Bot] and 9 guests