PG13 兼容性问题 🔥

ted · 2024 年10 月 22 日 02:29

感谢 @RGJ 的信息！

移除 NULLS NOT DISTINCT OPTION 的 PR 已上线：

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	3836	2020 年7 月 6 日
"EXCEPTION: psql failed: DETAIL: Key (post_id)=(36946) is duplicated." Installation	8	1188	2022 年6 月 20 日
Restore fails: could not create unique index Installation	10	1213	2022 年2 月 13 日
Problem with restore Discourse from backup (3.4, quite large DB) Support	18	234	2025 年1 月 14 日
Error restoring backup "key is duplicated" Installation	8	1806	2017 年8 月 31 日

PG13 兼容性问题 🔥

相关话题