search

dbeaver / dbeaver

Free universal database tool and SQL client
https://dbeaver.io
Apache License 2.0
39.35k stars 3.4k forks source link

dbeaver show the oldest script #23166

Open wonb168 opened 6 months ago

wonb168 commented 6 months ago

Description

When opening the script of a stored procedure in DBeaver, it does not fetch the latest script content in real time; instead, it retains the content from the previous connection. This can lead to making changes based on an older version, resulting in errors.

How to get the newest script when open？

DBeaver Version

24.0

Operating System

macos 14

Database and driver

greenplum6 or postgres10+

Steps to reproduce

doubleclick the procedure， then show the script

Additional context

nothing

Matvey16 commented 5 months ago

@wonb168 It is currently impossible to always open the latest version form the navigator, because of how caching in the navigator works. I can change this issue to a feature request and investigate if some kind of auto-refresh can be implemented, but for now the only possible way is to refresh the source of the procedure prior to doing any changes. Or you can refresh the entire procedures folder/schema/db in the navigator before opening it from there. You can refresh any node and all of it's child nodes in the navigator from it's context menu or by selecting it and pressing F5 dbeaver_Sg3Gzhzkje

wonb168 commented 5 months ago

I know I can manually refresh, but I won't always remember to do it, and it's easy to make mistakes. When Navicat is opened, it should automatically refresh to display the latest data.

wonb168 commented 4 months ago

@wonb168 It is currently impossible to always open the latest version form the navigator, because of how caching in the navigator works. I can change this issue to a feature request and investigate if some kind of auto-refresh can be implemented, but for now the only possible way is to refresh the source of the procedure prior to doing any changes. Or you can refresh the entire procedures folder/schema/db in the navigator before opening it from there. You can refresh any node and all of it's child nodes in the navigator from it's context menu or by selecting it and pressing F5 dbeaver_Sg3Gzhzkje

but, only refresh not work everytime, If I edit the proc and refresh , then also the old script, may refresh several times or wait a few moment, then refresh. Only disconnect and then connect again WORK ，is the most secure.