Skip to content

Schema Diff tool may produce incorrect difference script #8850

Open
@mkrauter

Description

@mkrauter

Describe the bug

I did a comparison between two instances of table test_section_page_stats. The only difference is a change in a FK ON DELETE action for table test_request_detail. The difference script gave a reference to an incorrect (albeit existing) table:

Image

It is worth noting that I had run the diff tool multiple times before in this session along multiple servers, and after restarting pgAdmin, a fresh run gave the correct difference script.

To Reproduce
I guess that might be a bit difficult.

Desktop (please complete the following information):

  • OS: Windows-10-10.0.19045-SP0
  • Version: 9.4
  • Mode: Desktop
  • Package type: Windows executable

Metadata

Metadata

Assignees

Labels

Type

No type

Projects

Status

No status

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions