Can not edit data in grid

kefi's profile image kefi posted 5 months ago in General Permalink

In the last weeks something happened and I can not edit data directly in the grid results like before. If I do an update statement the update works. Am I missing something or it is some problem with the latest updates? I'm on Windows 11 Pro 24H2 and running the latest version of HeidiSQL 12.11.0.7087 (64).

ansgar's profile image ansgar posted 5 months ago Permalink

Not sure. What exactly do you get on the second click in a grid cell, or when you press F2?

kefi's profile image kefi posted 5 months ago Permalink

The sell text gets this blue highlight, but it doesn't recognize the keyboard actions. I get this message down in the log - / Could not find table or view user.user.custom. Please refresh database tree. / But there is something wrong with the message. It should be user.custom not user.user.custom. Maybe this is the reason. User is the schema and custom is the table I want to edit. It just puts whatever schema I select from the tree on the left like product.user.custom, which does not exist.

ansgar's profile image ansgar posted 5 months ago Permalink

Can you please post the server type (MySQL, PostgreSQL, ...) and a screenshot would be nice.

kefi's profile image kefi posted 5 months ago Permalink

PostgreSQL

ansgar's profile image ansgar posted 5 months ago Permalink

Just tested with PostgreSQL here, I can insert and update rows without issues. There must be some more difference in your setup.

1 attachment(s):
  • pg-grid-edit
kefi's profile image kefi posted 4 months ago Permalink

Today the issue has disappeared.

Please login to leave a reply, or register at first.