When reindexing, maybe just warn on later versions with lower numbers, since those likely predate the requirement that new releases have higher versions.
--- a/sql/14-dist_processing.sql
+++ b/sql/14-dist_processing.sql
@@ -85,7 +85,7 @@ BEGIN
ORDER BY de.extension
);
IF array_length(versions, 1) > 0 THEN
- RAISE EXCEPTION E'One or more extension versions are greater than later versions:\n * %', array_to_string(versions, E'\n * ');
+ RAISE WARNING E'One or more extension versions are greater than later versions:\n * %', array_to_string(versions, E'\n * ');
END IF;
RETURN;
When reindexing, maybe just warn on later versions with lower numbers, since those likely predate the requirement that new releases have higher versions.