Skip to content

[Bug]: pg查询不带schema #433

Closed
Closed

Description

@feigeCode

发生了什么?/ What happened?

有个bug,我的pg库有好几个Schema,如果查询时不带Schema就会默认查public的表,不管在哪个Schema下执行都是这样

如何复现?/ How can we reproduce it?

No response

版本与系统 / Version and system

No response

截图、日志或其他信息 / Screenshots, logs, or anything else

No response

Activity

  1. feigeCode commented on Oct 22, 2026

    @feigeCode
    OwnerAuthor

    已修复,随 v0.21.0 发布。

    修复提交:ebc25513c。Auto(粘性)会话在建会话时只传了 database,没有把 search_path 对齐到编辑器中选中的 schema,后续执行又不会重放切换,所以选中的 schema 形同无效、不带表名的查询仍落在 public。

    现在的行为:会话建立后先 switch_session_schema 再执行,且只在建会话时切换一次,不覆盖用户手动的 SET search_path;切换失败会关闭会话并把结果面板置为失败态。

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Labels

    bugSomething isn't working

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions