Schema Diff issue (RM #7424)

[dpage]

Issue migrated from Redmine: https://redmine.postgresql.org/issues/7424
Originally created by Mark Pare at 2022-05-26 20:23:14 UTC.

Hi, when running a schema diff, because the permissions of a table are displayed in a different order, it is considered a difference when it shouldn't be. Example:

DEV database
GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE . TO

UAT database
GRANT INSERT, SELECT, UPDATE, DELETE ON TABLE . TO

This will generate a difference but it shouldn't the SQL tab displays permissions in a random order in some cases, even if they are always created as SELECT, INSERT, UPDATE, DELETE

Thanks

[dpage]

Comment migrated from Redmine: https://redmine.postgresql.org/issues/7424#note-1
Originally created by Khushboo Vashi at 2022-05-27 11:03:35 UTC.

Redmine ticket header update:

Name	Old Value	New Value
Sprint changed		Ready

[dpage]

Comment migrated from Redmine: https://redmine.postgresql.org/issues/7424#note-2
Originally created by Akshay Joshi at 2022-06-07 11:02:56 UTC.

Redmine ticket header update:

Name	Old Value	New Value
Relationship (relates) changed		RM #7432

[dpage]

Comment migrated from Redmine: https://redmine.postgresql.org/issues/7424#note-3
Originally created by Akshay Joshi at 2022-08-16 06:05:22 UTC.

Redmine ticket header update:

Name	Old Value	New Value
Sprint changed	Ready	EDB Sprint 124

[dpage]

Comment migrated from Redmine: https://redmine.postgresql.org/issues/7424#note-4
Originally created by Akshay Joshi at 2022-08-17 07:14:13 UTC.

Redmine ticket header update:

Name	Old Value	New Value
Assigned To changed		Akshay Joshi

[dpage]

Comment migrated from Redmine: https://redmine.postgresql.org/issues/7424#note-5
Originally created by Akshay Joshi at 2022-08-18 08:41:04 UTC.

Redmine ticket header update:

Name	Old Value	New Value
Status changed	New	In Progress

[dpage]

Comment migrated from Redmine: https://redmine.postgresql.org/issues/7424#note-6
Originally created by Akshay Joshi at 2022-08-18 13:23:42 UTC.

Redmine ticket header update:

Name	Old Value	New Value
Sprint changed	EDB Sprint 124	Ready
Assigned To changed	Akshay Joshi
Status changed	In Progress	New

[FaharAbbasRizvi]

This is resolved in the snapshot build:
https://www.postgresql.org/ftp/pgadmin/pgadmin4/snapshots/2022-09-29/