مشكلة توافق PG13 :نار:

ted · 22 أكتوبر 2024، 2:29ص

شكراً على المعلومات @RGJ!

طلب سحب الميزة (PR) لإزالة NULLS NOT DISTINCT OPTION متاح:

github.com/discourse/discourse

DEV: Remove NULLS NOT DISTINCT from problem check trackers

main ← dev/remove-nulls-not-distinct-from-problem-check-trackers

opened 02:28AM - 22 Oct 24 UTC

Drenmi

+12 -0

### What is this change? We added `NULLS NOT DISTINCT` to a unique index on `…problem_check_trackers`. This option is only available in PG15+. It does not in itself break PG13, but restoring a PG15+ backup to PG13 currently errors out. It seems this is an operation that's more common than we first thought. This commit fixes that by removing the `NULLS NOT DISTINCT`. ### Don't we need it, since we added it? We already have another, backwards-compatible approach to do the same thing in place, so this shouldn't change existing behaviour.

الموضوع		الردود	مرات العرض
Restore fails - could not create unique index Installation	22	3832	6 يوليو 2020
"EXCEPTION: psql failed: DETAIL: Key (post_id)=(36946) is duplicated." Installation	8	1187	20 يونيو 2022
Restore fails: could not create unique index Installation	10	1213	13 فبراير 2022
Problem with restore Discourse from backup (3.4, quite large DB) Support	18	233	14 يناير 2025
Error restoring backup "key is duplicated" Installation	8	1806	31 أغسطس 2017

مشكلة توافق PG13 :نار:

الموضوعات ذات الصلة