Fix the commutators of the ttext temporal compops (#722)#725
Merged
mschoema merged 1 commit intoMobilityDB:stable-1.2from Sep 30, 2025
Merged
Fix the commutators of the ttext temporal compops (#722)#725mschoema merged 1 commit intoMobilityDB:stable-1.2from
mschoema merged 1 commit intoMobilityDB:stable-1.2from
Conversation
Fixes the issue mentioned by MobilityDB#680. The commutators of the temporal compops for the `ttext` were wrong. Previously this didn't raise an error, but starting with PG 17, postgres raises an error when two operators have the same commutator. Strangely, this error was only raised when running `pg_upgrade` to go from PG 16 to PG 17, and does not get raised when running `CREATE INSTALL`.
estebanzimanyi
approved these changes
Sep 30, 2025
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
2 participants
Add this suggestion to a batch that can be applied as a single commit.This suggestion is invalid because no changes were made to the code.Suggestions cannot be applied while the pull request is closed.Suggestions cannot be applied while viewing a subset of changes.Only one suggestion per line can be applied in a batch.Add this suggestion to a batch that can be applied as a single commit.Applying suggestions on deleted lines is not supported.You must change the existing code in this line in order to create a valid suggestion.Outdated suggestions cannot be applied.This suggestion has been applied or marked resolved.Suggestions cannot be applied from pending reviews.Suggestions cannot be applied on multi-line comments.Suggestions cannot be applied while the pull request is queued to merge.Suggestion cannot be applied right now. Please check back later.
Fixes the issue mentioned by #680.
The commutators of the temporal compops for the
ttextwere wrong. Previously this didn't raise an error, but starting with PG 17, postgres raises an error when two operators have the same commutator. Strangely, this error was only raised when runningpg_upgradeto go from PG 16 to PG 17, and does not get raised when runningCREATE INSTALL.Cherry-pick of c2c5608