Data inconsistent between "edit data" visualization ad SQL query output
已回答
Hi, I've set a connection through SSH Tunnel to my remote PostgreSQL 17 server with "Transaction mode: auto" and “Transaction isolation: database default”. I can't understand why, through “Edit data” visualization I see all records on tables but, if I run a simple “select count(*) from table” I receive a different result.
why?!?
In attachments an example: Upload id: 2025_05_28_fUFymzS39pvQARfNrPLfrM (files: edit_data.png, query.png)
Additional infos:
- I don't have different objects with same name (tables/views)
- No running transaction
- The same query on pgAdmin return correct result
- Vacuum executed
Thanks a lot
Stefano
请先登录再写评论。
Hi Stefano,
We’ve discussed this issue with you in the support request, but I’ll add some details here for the record.
Closing the opened query consoles helped, but from the logs provided, it’s not clear what the issue was related to, so additional clarifications are needed. It would also be helpful if you could reproduce the issue and share the steps.