pg.ddx.io pgsql-committers@postgresql.org mailing list archivehelp / color / mirror / Atom feed
pgsql: Sort DO_DEFAULT_ACL dump objects independent of OIDs. 7+ messages / 1 participants [nested] [flat]
* pgsql: Sort DO_DEFAULT_ACL dump objects independent of OIDs. @ 2025-08-23 03:53 Noah Misch <noah@leadboat.com> 0 siblings, 0 replies; 7+ messages in thread From: Noah Misch @ 2025-08-23 03:53 UTC (permalink / raw) To: pgsql-committers@lists.postgresql.org Sort DO_DEFAULT_ACL dump objects independent of OIDs. Commit 0decd5e89db9f5edb9b27351082f0d74aae7a9b6 missed DO_DEFAULT_ACL, leading to assertion failures, potential dump order instability, and spurious schema diffs. Back-patch to v13, like that commit. Reported-by: Alexander Lakhin <exclusion@gmail.com> Author: Kirill Reshke <reshkekirill@gmail.com> Discussion: https://postgr.es/m/d32aaa8d-df7c-4f94-bcb3-4c85f02bea21@gmail.com Backpatch-through: 13 Branch ------ REL_14_STABLE Details ------- https://git.postgresql.org/pg/commitdiff/4948bb9df4210e30492caf3fa4e982bac376fd0b Modified Files -------------- src/bin/pg_dump/pg_dump_sort.c | 13 +++++++++++++ src/test/regress/expected/privileges.out | 5 +++++ src/test/regress/sql/privileges.sql | 7 +++++++ 3 files changed, 25 insertions(+) ^ permalink raw reply [nested|flat] 7+ messages in thread
* pgsql: Sort DO_DEFAULT_ACL dump objects independent of OIDs. @ 2025-08-23 03:53 Noah Misch <noah@leadboat.com> 0 siblings, 0 replies; 7+ messages in thread From: Noah Misch @ 2025-08-23 03:53 UTC (permalink / raw) To: pgsql-committers@lists.postgresql.org Sort DO_DEFAULT_ACL dump objects independent of OIDs. Commit 0decd5e89db9f5edb9b27351082f0d74aae7a9b6 missed DO_DEFAULT_ACL, leading to assertion failures, potential dump order instability, and spurious schema diffs. Back-patch to v13, like that commit. Reported-by: Alexander Lakhin <exclusion@gmail.com> Author: Kirill Reshke <reshkekirill@gmail.com> Discussion: https://postgr.es/m/d32aaa8d-df7c-4f94-bcb3-4c85f02bea21@gmail.com Backpatch-through: 13 Branch ------ REL_18_STABLE Details ------- https://git.postgresql.org/pg/commitdiff/7652142f4c1446d533797b24a5bac6cd2b3a4a4e Modified Files -------------- src/bin/pg_dump/pg_dump_sort.c | 13 +++++++++++++ src/test/regress/expected/privileges.out | 5 +++++ src/test/regress/sql/privileges.sql | 7 +++++++ 3 files changed, 25 insertions(+) ^ permalink raw reply [nested|flat] 7+ messages in thread
* pgsql: Sort DO_DEFAULT_ACL dump objects independent of OIDs. @ 2025-08-23 03:53 Noah Misch <noah@leadboat.com> 0 siblings, 0 replies; 7+ messages in thread From: Noah Misch @ 2025-08-23 03:53 UTC (permalink / raw) To: pgsql-committers@lists.postgresql.org Sort DO_DEFAULT_ACL dump objects independent of OIDs. Commit 0decd5e89db9f5edb9b27351082f0d74aae7a9b6 missed DO_DEFAULT_ACL, leading to assertion failures, potential dump order instability, and spurious schema diffs. Back-patch to v13, like that commit. Reported-by: Alexander Lakhin <exclusion@gmail.com> Author: Kirill Reshke <reshkekirill@gmail.com> Discussion: https://postgr.es/m/d32aaa8d-df7c-4f94-bcb3-4c85f02bea21@gmail.com Backpatch-through: 13 Branch ------ REL_15_STABLE Details ------- https://git.postgresql.org/pg/commitdiff/fbf967e996ddb6ce32983479236339ac3c7e1ce6 Modified Files -------------- src/bin/pg_dump/pg_dump_sort.c | 13 +++++++++++++ src/test/regress/expected/privileges.out | 5 +++++ src/test/regress/sql/privileges.sql | 7 +++++++ 3 files changed, 25 insertions(+) ^ permalink raw reply [nested|flat] 7+ messages in thread
* pgsql: Sort DO_DEFAULT_ACL dump objects independent of OIDs. @ 2025-08-23 03:53 Noah Misch <noah@leadboat.com> 0 siblings, 0 replies; 7+ messages in thread From: Noah Misch @ 2025-08-23 03:53 UTC (permalink / raw) To: pgsql-committers@lists.postgresql.org Sort DO_DEFAULT_ACL dump objects independent of OIDs. Commit 0decd5e89db9f5edb9b27351082f0d74aae7a9b6 missed DO_DEFAULT_ACL, leading to assertion failures, potential dump order instability, and spurious schema diffs. Back-patch to v13, like that commit. Reported-by: Alexander Lakhin <exclusion@gmail.com> Author: Kirill Reshke <reshkekirill@gmail.com> Discussion: https://postgr.es/m/d32aaa8d-df7c-4f94-bcb3-4c85f02bea21@gmail.com Backpatch-through: 13 Branch ------ REL_16_STABLE Details ------- https://git.postgresql.org/pg/commitdiff/e68fa9a830f015a5870abcf9ef8bbc4b416464c4 Modified Files -------------- src/bin/pg_dump/pg_dump_sort.c | 13 +++++++++++++ src/test/regress/expected/privileges.out | 5 +++++ src/test/regress/sql/privileges.sql | 7 +++++++ 3 files changed, 25 insertions(+) ^ permalink raw reply [nested|flat] 7+ messages in thread
* pgsql: Sort DO_DEFAULT_ACL dump objects independent of OIDs. @ 2025-08-23 03:53 Noah Misch <noah@leadboat.com> 0 siblings, 0 replies; 7+ messages in thread From: Noah Misch @ 2025-08-23 03:53 UTC (permalink / raw) To: pgsql-committers@lists.postgresql.org Sort DO_DEFAULT_ACL dump objects independent of OIDs. Commit 0decd5e89db9f5edb9b27351082f0d74aae7a9b6 missed DO_DEFAULT_ACL, leading to assertion failures, potential dump order instability, and spurious schema diffs. Back-patch to v13, like that commit. Reported-by: Alexander Lakhin <exclusion@gmail.com> Author: Kirill Reshke <reshkekirill@gmail.com> Discussion: https://postgr.es/m/d32aaa8d-df7c-4f94-bcb3-4c85f02bea21@gmail.com Backpatch-through: 13 Branch ------ REL_17_STABLE Details ------- https://git.postgresql.org/pg/commitdiff/e8d22095e5df4d22513ce553998eef899f5f0692 Modified Files -------------- src/bin/pg_dump/pg_dump_sort.c | 13 +++++++++++++ src/test/regress/expected/privileges.out | 5 +++++ src/test/regress/sql/privileges.sql | 7 +++++++ 3 files changed, 25 insertions(+) ^ permalink raw reply [nested|flat] 7+ messages in thread
* pgsql: Sort DO_DEFAULT_ACL dump objects independent of OIDs. @ 2025-08-23 03:53 Noah Misch <noah@leadboat.com> 0 siblings, 0 replies; 7+ messages in thread From: Noah Misch @ 2025-08-23 03:53 UTC (permalink / raw) To: pgsql-committers@lists.postgresql.org Sort DO_DEFAULT_ACL dump objects independent of OIDs. Commit 0decd5e89db9f5edb9b27351082f0d74aae7a9b6 missed DO_DEFAULT_ACL, leading to assertion failures, potential dump order instability, and spurious schema diffs. Back-patch to v13, like that commit. Reported-by: Alexander Lakhin <exclusion@gmail.com> Author: Kirill Reshke <reshkekirill@gmail.com> Discussion: https://postgr.es/m/d32aaa8d-df7c-4f94-bcb3-4c85f02bea21@gmail.com Backpatch-through: 13 Branch ------ REL_13_STABLE Details ------- https://git.postgresql.org/pg/commitdiff/05341b2e9914d8c5690ba38c081c0af450c7d3e9 Modified Files -------------- src/bin/pg_dump/pg_dump_sort.c | 13 +++++++++++++ src/test/regress/expected/privileges.out | 5 +++++ src/test/regress/sql/privileges.sql | 7 +++++++ 3 files changed, 25 insertions(+) ^ permalink raw reply [nested|flat] 7+ messages in thread
* pgsql: Sort DO_DEFAULT_ACL dump objects independent of OIDs. @ 2025-08-23 03:53 Noah Misch <noah@leadboat.com> 0 siblings, 0 replies; 7+ messages in thread From: Noah Misch @ 2025-08-23 03:53 UTC (permalink / raw) To: pgsql-committers@lists.postgresql.org Sort DO_DEFAULT_ACL dump objects independent of OIDs. Commit 0decd5e89db9f5edb9b27351082f0d74aae7a9b6 missed DO_DEFAULT_ACL, leading to assertion failures, potential dump order instability, and spurious schema diffs. Back-patch to v13, like that commit. Reported-by: Alexander Lakhin <exclusion@gmail.com> Author: Kirill Reshke <reshkekirill@gmail.com> Discussion: https://postgr.es/m/d32aaa8d-df7c-4f94-bcb3-4c85f02bea21@gmail.com Backpatch-through: 13 Branch ------ master Details ------- https://git.postgresql.org/pg/commitdiff/b61a5c4bed7df87120df587731840e51ea7c7525 Modified Files -------------- src/bin/pg_dump/pg_dump_sort.c | 13 +++++++++++++ src/test/regress/expected/privileges.out | 5 +++++ src/test/regress/sql/privileges.sql | 7 +++++++ 3 files changed, 25 insertions(+) ^ permalink raw reply [nested|flat] 7+ messages in thread
end of thread, other threads:[~2025-08-23 03:53 UTC | newest] Thread overview: 7+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2025-08-23 03:53 pgsql: Sort DO_DEFAULT_ACL dump objects independent of OIDs. Noah Misch <noah@leadboat.com> 2025-08-23 03:53 pgsql: Sort DO_DEFAULT_ACL dump objects independent of OIDs. Noah Misch <noah@leadboat.com> 2025-08-23 03:53 pgsql: Sort DO_DEFAULT_ACL dump objects independent of OIDs. Noah Misch <noah@leadboat.com> 2025-08-23 03:53 pgsql: Sort DO_DEFAULT_ACL dump objects independent of OIDs. Noah Misch <noah@leadboat.com> 2025-08-23 03:53 pgsql: Sort DO_DEFAULT_ACL dump objects independent of OIDs. Noah Misch <noah@leadboat.com> 2025-08-23 03:53 pgsql: Sort DO_DEFAULT_ACL dump objects independent of OIDs. Noah Misch <noah@leadboat.com> 2025-08-23 03:53 pgsql: Sort DO_DEFAULT_ACL dump objects independent of OIDs. Noah Misch <noah@leadboat.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox