这是indexloc提供的服务,不要输入任何密码
Skip to content

BUG: Relations not showing for read-only Postgres connection #3262

@ben-etherfi

Description

@ben-etherfi

Describe the bug
Table relations are not visible when the DB connection is read-only.

To Reproduce
Steps to reproduce the behavior:

  1. Create a Postgres DB with tables t1 and t2.
  2. Create a column in t1 referencing entries of t2 via a foreign key constraint.
    3.Connect to the Postgres DB with a user with read-only credentials.
  3. Right click the t1 entity in the left sidebar.
  4. Click "View Structure".
  5. Click the "Relations" tab.
  6. Observe no relations are listed despite the column in t1 referencing entries of t2 via a foreign key constraint.

Expected behavior
The relation of t1 referencing entries of t2 via a foreign key constraint is listed in the "Relations" tab after opening the "View Structure" view.

Version Information (please complete the following information):

  • OS: MacOS Sequoia 15.5
  • App Version: Beekeeper Studio Version 5.2.12
  • Database type and version: PostgreSQL 16.8 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 7.3.1 20180712 (Red Hat 7.3.1-17), 64-bit

Metadata

Metadata

Assignees

No one assigned

    Labels

    bugSomething isn't workingneed-more-info ❔Debug logs or platform needed before we can look into this issue

    Type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions