Apr 22, 2024 · Apr 17, 2024
diff --git a/Makefile b/Makefile
  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 \
 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
 #----------------------------------------------------------------------------

 EXTENSION        := pg_sphere
 PGSPHERE_VERSION := 1.5.0
 PGSPHERE_VERSION := 1.5.1
diff --git a/expected/version.out b/expected/version.out
 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
 # 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
 -- 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;
 $$;
Original file line number	Diff line number	Diff line change
Expand Up		@@ -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 \
Expand DownExpand Up		@@ -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
Expand Down
Original file line number	Diff line number	Diff line change
Expand Up		@@ -5,4 +5,4 @@
		#----------------------------------------------------------------------------

		EXTENSION := pg_sphere
		PGSPHERE_VERSION := 1.5.0
		PGSPHERE_VERSION := 1.5.1
Original file line number	Diff line number	Diff line change
Expand Up		@@ -2,6 +2,6 @@
		SELECT pg_sphere_version();
		pg_sphere_version
		-------------------
		1.5.0
		1.5.1
		(1 row)
Original file line number	Diff line number	Diff line change
		@@ -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
Original file line number	Diff line number	Diff line change
		@@ -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;
		$$;