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

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
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
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):
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