Can't edit any tables in one MySQL db

Posted:
Tue May 22, 2012 4:37 pm
by codebling
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!
Re: Can't edit any tables in one MySQL db

Posted:
Wed May 23, 2012 7:31 am
by Serge
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!
Re: Can't edit any tables in one MySQL db

Posted:
Wed May 23, 2012 6:06 pm
by codebling
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 !