dbeaver / dbeaver

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

Relod metadata cache if object not found? #21734

Open fjf2002 opened 1 year ago

fjf2002 commented 1 year ago

Is your feature request related to a problem? Please describe.

  1. I often create DB Objects using plain SQL (as opposed to using the GUI).
  2. I heavily use "Open Database Object" (Ctrl-Shift-D) and Ctrl-Mouseclick (jump to definition).

However, DBeaver seems to cache the metadata and does not update the information from 2. automatically. I often get errors like "database object not found".

However I unterstand that you cannot update your metadata cache when I am executing arbitrary DDL statements.

Describe the solution you'd like Proposal: If the DB object is not found in the DBeaver metadata cache, refresh it and search again.

Describe alternatives you've considered Alternative: select a root node in the navigator and press F5.

Additional context using a PostgreSQL DB

LonwoLonwo commented 1 year ago

Hello @fjf2002

Thanks for the idea.

Partially, it is already described here: https://github.com/dbeaver/dbeaver/issues/16219

But, probably, we can add a special Refresh setting to the Search dialog/Search panel or in the Preferences.

fjf2002 commented 1 year ago

@LonwoLonwo: Yeah, that would be great. Thanks.