public inbox for [email protected]help / color / mirror / Atom feed
pgsql: Allow non-btree unique indexes for partition keys 2+ messages / 1 participants [nested] [flat]
* pgsql: Allow non-btree unique indexes for partition keys @ 2025-03-18 10:34 Peter Eisentraut <[email protected]> 0 siblings, 0 replies; 2+ messages in thread From: Peter Eisentraut @ 2025-03-18 10:34 UTC (permalink / raw) To: [email protected] Allow non-btree unique indexes for partition keys We were rejecting non-btree indexes in some cases owing to the inability to determine the equality operators for other index AMs; that problem no longer exists, because we can look up the equality operator using COMPARE_EQ. The problem of not knowing the strategy number for equality in other index AMs is already resolved. Stop rejecting the indexes upfront, and instead reject any for which the equality operator lookup fails. Author: Mark Dilger <[email protected]> Discussion: https://www.postgresql.org/message-id/flat/[email protected] Branch ------ master Details ------- https://git.postgresql.org/pg/commitdiff/f278e1fe300ab1b7d43c3efb55a29aa17e5f5dda Modified Files -------------- src/backend/commands/indexcmds.c | 30 +++++++++++------------------- 1 file changed, 11 insertions(+), 19 deletions(-) ^ permalink raw reply [nested|flat] 2+ messages in thread
* pgsql: Allow non-btree unique indexes for matviews @ 2025-03-18 10:34 Peter Eisentraut <[email protected]> 0 siblings, 0 replies; 2+ messages in thread From: Peter Eisentraut @ 2025-03-18 10:34 UTC (permalink / raw) To: [email protected] Allow non-btree unique indexes for matviews We were rejecting non-btree indexes in some cases owing to the inability to determine the equality operators for other index AMs; that problem no longer exists, because we can look up the equality operator using COMPARE_EQ. Stop rejecting these indexes, but instead rely on all unique indexes having equality operators. Unique indexes must have equality operators. Author: Mark Dilger <[email protected]> Discussion: https://www.postgresql.org/message-id/flat/[email protected] Branch ------ master Details ------- https://git.postgresql.org/pg/commitdiff/9d6db8bec19413cd0167f1e59d1af005a997bd3e Modified Files -------------- src/backend/commands/matview.c | 15 ++++----------- 1 file changed, 4 insertions(+), 11 deletions(-) ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2025-03-18 10:34 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2025-03-18 10:34 pgsql: Allow non-btree unique indexes for partition keys Peter Eisentraut <[email protected]> 2025-03-18 10:34 pgsql: Allow non-btree unique indexes for matviews Peter Eisentraut <[email protected]>
This inbox is served by agora; see mirroring instructions for how to clone and mirror all data and code used for this inbox