Skip to content

Schema diff lists equal tables #10446

Description

@oliverbienert

Describe the bug

Schema diff claims to find a difference for a table but the sql shown is identical and the difference window is empty.
I'll attach the sql-files as well as the debug log.
Comparing options are all ignored (e.g. Owner, Whitespace...)

log_source.py
log_target.py
Image
source.sql
target.sql

Expected behavior

The table should not be listed as there should be no difference.

Screenshots

See attached screenshot

Desktop (please complete the following information):

  • OS: Ubuntu 24.04
  • pgAdmin version: 9.18
  • Mode: Desktop
  • Package type: DEB
    Additional context

Postgresql version:

Target: PostgreSQL 16.15 (Ubuntu 16.15-0ubuntu0.24.04.1) on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 13.3.0-6ubuntu2~24.04.1) 13.3.0, 64-bit

Source: PostgreSQL 16.15 (Debian 16.15-1.pgdg11+2) on x86_64-pc-linux-gnu, compiled by gcc (Debian 10.2.1-6) 10.2.1 20210110, 64-bit

Activity

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

    Type

    No type

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions