Skip to content

Failed to fetch data errors when opening table properties after upgrade to version 9.16 #10126

Description

@mark-orion

Please note that security bugs or issues should be reported to security@pgadmin.org.

Describe the bug

"Failed to fetch data error" when opening the properties of a table. The error window contains a message like:
column att.attcompression does not exist
LINE 39: (CASE WHEN att.attcompression = 'p' THEN 'pglz' WHEN att.at...
^

To Reproduce

  • Right click on a table in the left sidebar
  • Select properties
  • Error message pops up

Expected behavior

No errors when opening table properties

Error message

column att.attcompression does not exist
LINE 39: (CASE WHEN att.attcompression = 'p' THEN 'pglz' WHEN att.at...
^

Desktop (please complete the following information):

  • OS: Linux - UbuntuStudio 24.04
  • pgAdmin version: 9.16
  • Mode: Desktop
  • Package type: DEB

Additional context

The error appears with all connected servers (different Postgres versions).

Metadata

Metadata

Assignees

No one assigned

    Labels

    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