Alter spoint op family to add missed operator 17 (<->) (#121)

vitcpp · web-flow · commit daa9478bcd19 · 2024-04-22T09:22:05.000+03:00
The upgrade script misses the altering of spoint operator family
to add operator 17. It is required for k-NN search.

Change the version to 1.5.1.
diff --git a/Makefile b/Makefile
@@ -35,7 +35,8 @@ DATA_built  = $(RELEASE_SQL) \
 			  pg_sphere--1.3.1--1.4.0.sql \
 			  pg_sphere--1.4.0--1.4.1.sql \
 			  pg_sphere--1.4.1--1.4.2.sql \
-			  pg_sphere--1.4.2--1.5.0.sql
+			  pg_sphere--1.4.2--1.5.0.sql \
+			  pg_sphere--1.5.0--1.5.1.sql
 
 DOCS        = README.pg_sphere COPYRIGHT.pg_sphere
 TESTS       = version tables points euler circle line ellipse poly path box \
@@ -214,6 +215,9 @@ pg_sphere--1.4.0--1.4.1.sql pg_sphere--1.4.1--1.4.2.sql:
 pg_sphere--1.4.2--1.5.0.sql:
 	cat upgrade_scripts/$@.in $^ > $@
 
+pg_sphere--1.5.0--1.5.1.sql:
+	cat upgrade_scripts/$@.in $^ > $@
+
 # end of local stuff
 
 src/sscan.o : src/sparse.c
diff --git a/Makefile.common.mk b/Makefile.common.mk
@@ -5,4 +5,4 @@
 #----------------------------------------------------------------------------
 
 EXTENSION        	:= pg_sphere
-PGSPHERE_VERSION 	:= 1.5.0
+PGSPHERE_VERSION 	:= 1.5.1
diff --git a/expected/version.out b/expected/version.out
@@ -2,6 +2,6 @@
 SELECT pg_sphere_version();
  pg_sphere_version 
 -------------------
- 1.5.0
+ 1.5.1
 (1 row)
 
diff --git a/pg_sphere.control b/pg_sphere.control
@@ -1,5 +1,5 @@
 # pg_sphere extension
 comment = 'spherical objects with useful functions, operators and index support'
-default_version = '1.5.0'
+default_version = '1.5.1'
 module_pathname = '$libdir/pg_sphere'
 relocatable = true
diff --git a/upgrade_scripts/pg_sphere--1.5.0--1.5.1.sql.in b/upgrade_scripts/pg_sphere--1.5.0--1.5.1.sql.in
@@ -0,0 +1,11 @@
+-- Upgrade: 1.5.0 -> 1.5.1
+
+DO $$
+BEGIN
+   ALTER OPERATOR FAMILY spoint USING gist ADD
+      OPERATOR 17 <-> (spoint, spoint) FOR ORDER BY float_ops;
+EXCEPTION
+   WHEN duplicate_object THEN NULL;
+   WHEN OTHERS THEN RAISE;
+END;
+$$;
