Skip to content

Postgres cross schema preview not working #644

@dpuche

Description

@dpuche

What happened?

Preview on a foreign key column targets a different schema not working

Steps to reproduce

  1. having a postgres database with 2 schemas: project and common. Having a table user in project schema with a column id_language referencing a table language in common schema
  2. trying to get the preview of id_language on a row
  3. getting an error popup which says: Query Execution Failed, ERROR: relation "language" does not exist
    LINE 1: SELECT * FROM "language" WHERE "id" = ...
    ^ (SQLSTATE: 15)

Expected behavior

No response

Database type

None

TablePro version

No response

macOS version & chip

No response

Screenshots / Logs

No response

Metadata

Metadata

Assignees

No one assigned

    Labels

    bugSomething isn't working

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions