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
    No fields configured for issues without a type.

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions