-
Notifications
You must be signed in to change notification settings - Fork 627
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Tools -> Shema Diff not working correctly #7523
Comments
Are you comparing two databases or 2 schemas? |
Hi
I'm comparing two schemas on two different databases and different machines, but of the same DB version and parameters.
Regards
From: Akshay Joshi ***@***.***>
Sent: Monday, June 3, 2024 3:39 PM
To: pgadmin-org/pgadmin4 ***@***.***>
Cc: ddjuric1 ***@***.***>; Mention ***@***.***>
Subject: Re: [pgadmin-org/pgadmin4] Tools -> Shema Diff not working correctly (Issue #7523)
@ddjuric1 <https://github.com/ddjuric1>
Are you comparing two databases or 2 schemas?
—
Reply to this email directly, view it on GitHub <#7523 (comment)> , or unsubscribe <https://github.com/notifications/unsubscribe-auth/AUYVRMPCKE2CVVJWD2MR7P3ZFRWXPAVCNFSM6AAAAABISPIA4OVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDCNBVGIZTCMBXGI> .
You are receiving this because you were mentioned. <https://github.com/notifications/beacon/AUYVRMKIEPIT2AISIXUASRDZFRWXPA5CNFSM6AAAAABISPIA4OWGG33NNVSW45C7OR4XAZNMJFZXG5LFINXW23LFNZ2KUY3PNVWWK3TUL5UWJTT73WQOA.gif> Message ID: ***@***.*** ***@***.***> >
|
akshay-joshi
added a commit
that referenced
this issue
Jun 20, 2024
…ferent due to schema-qualified trigger functions in the trigger definitions. #7523
Issue resolved, tested on snapshot build. |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
States differences in comments of the same tables when there is no differences
![1](https://private-user-images.githubusercontent.com/87120049/335529951-19e2070a-7a81-4a50-b69c-23c4989e712a.png?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3MjUwMjgyOTAsIm5iZiI6MTcyNTAyNzk5MCwicGF0aCI6Ii84NzEyMDA0OS8zMzU1Mjk5NTEtMTllMjA3MGEtN2E4MS00YTUwLWI2OWMtMjNjNDk4OWU3MTJhLnBuZz9YLUFtei1BbGdvcml0aG09QVdTNC1ITUFDLVNIQTI1NiZYLUFtei1DcmVkZW50aWFsPUFLSUFWQ09EWUxTQTUzUFFLNFpBJTJGMjAyNDA4MzAlMkZ1cy1lYXN0LTElMkZzMyUyRmF3czRfcmVxdWVzdCZYLUFtei1EYXRlPTIwMjQwODMwVDE0MjYzMFomWC1BbXotRXhwaXJlcz0zMDAmWC1BbXotU2lnbmF0dXJlPTk1MGM1MDc3MDIwNzQ2MDNlMDJlNzY1NjgxZGNjMTM2MDg2ZTVkN2Q4YTdlMjUxOTYwMWJhMTY3ZmUwZTczMWYmWC1BbXotU2lnbmVkSGVhZGVycz1ob3N0JmFjdG9yX2lkPTAma2V5X2lkPTAmcmVwb19pZD0wIn0.9oU3gakQbQK8RyrpeuiKhS8MGutbxm8BF3gWK3aZXrI)
This is from earlier versions.
States differences of the same tables when there is no any text in Difference screen.
![2](https://private-user-images.githubusercontent.com/87120049/335529933-51ee8ae9-e43a-4aae-a4d7-3e035f7bfd61.png?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3MjUwMjgyOTAsIm5iZiI6MTcyNTAyNzk5MCwicGF0aCI6Ii84NzEyMDA0OS8zMzU1Mjk5MzMtNTFlZThhZTktZTQzYS00YWFlLWE0ZDctM2UwMzVmN2JmZDYxLnBuZz9YLUFtei1BbGdvcml0aG09QVdTNC1ITUFDLVNIQTI1NiZYLUFtei1DcmVkZW50aWFsPUFLSUFWQ09EWUxTQTUzUFFLNFpBJTJGMjAyNDA4MzAlMkZ1cy1lYXN0LTElMkZzMyUyRmF3czRfcmVxdWVzdCZYLUFtei1EYXRlPTIwMjQwODMwVDE0MjYzMFomWC1BbXotRXhwaXJlcz0zMDAmWC1BbXotU2lnbmF0dXJlPTdhODkyNDQyMTYyNTFmZmQ1OTU4NjM5NDNmYmNlYzhkMWJmNDM3ZTRjYzVjNjY2MTAyOTk0ZDhjMzM5MTUzYTUmWC1BbXotU2lnbmVkSGVhZGVycz1ob3N0JmFjdG9yX2lkPTAma2V5X2lkPTAmcmVwb19pZD0wIn0.GTwCVn9SfPqP9Z1MuEpzKTmDWnPND-nSgN5TEPXgCog)
This is also from earlier versions.
States differences of the same tables on triggers.
![3](https://private-user-images.githubusercontent.com/87120049/335529943-e35adeee-2d75-44ff-8293-5131ccd02e7e.png?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3MjUwMjgyOTAsIm5iZiI6MTcyNTAyNzk5MCwicGF0aCI6Ii84NzEyMDA0OS8zMzU1Mjk5NDMtZTM1YWRlZWUtMmQ3NS00NGZmLTgyOTMtNTEzMWNjZDAyZTdlLnBuZz9YLUFtei1BbGdvcml0aG09QVdTNC1ITUFDLVNIQTI1NiZYLUFtei1DcmVkZW50aWFsPUFLSUFWQ09EWUxTQTUzUFFLNFpBJTJGMjAyNDA4MzAlMkZ1cy1lYXN0LTElMkZzMyUyRmF3czRfcmVxdWVzdCZYLUFtei1EYXRlPTIwMjQwODMwVDE0MjYzMFomWC1BbXotRXhwaXJlcz0zMDAmWC1BbXotU2lnbmF0dXJlPTE5MDk5MTE5NjE1ZGRhYmFkMjIzN2RiZmFlOTM2ZWFjNjZkZmY5ZWM0YWY2MDliYmU3YjczYjdmZWUyZjNlMWImWC1BbXotU2lnbmVkSGVhZGVycz1ob3N0JmFjdG9yX2lkPTAma2V5X2lkPTAmcmVwb19pZD0wIn0.rZbABBrUw9NXisRUyRzsqI6p6sA-EtOKrBSq9bHpCoM)
It should recognize that the called trigger function is from the same shame as the calling trigger is
and not treat it as difference.
The text was updated successfully, but these errors were encountered: