#42086·dbeaver

Lost virtual key definition

Author: marins130-stackCreated Sep 11, 2026Updated Sep 17, 2026
Labelsx:postgresqlwait for responsexf:sql editorxqa:need-testing

Description

After creating a virtual key—similar to the one in the 'v_org' attachment—and restarting the program, the key changes and loses some of its relationships. An example of the key after the change is shown in the 'vk_regen' attachment. This always happens when the same field is related multiple times to different fields in the reference table (see attachment 'vk_org_def').

DBeaver Version

Version 26.2.0.202608301738

Operating System

ms windows

Database and driver

PostgreSQL JDBC Driver

Steps to reproduce

  1. create vk key like in attachment 'vk_org_def' (After refreshing, the diagram shows the correct relationships)
  2. restarting the program
  3. the VK key has already been changed.

Additional context

No response