Oct 27, 2023 · Oct 26, 2023
diff --git a/Makefile b/Makefile
 PGS_SQL    += pgs_gist_spoint3.sql

 ifneq ($(USE_HEALPIX),0)
 PGS_SQL    += pgs_moc_type.sqlpgs_moc_compat.sqlpgs_moc_ops.sql \
 PGS_SQL    += pgs_moc_type.sql pgs_moc_ops.sql \
              pgs_moc_geo_casts.sql
 endif

 pg_sphere--1.1.5beta0gavo--1.1.5beta2gavo.sql: pgs_moc_type.sql.in
 cat upgrade_scripts/$@.in $^ > $@

 pg_sphere--1.1.5beta2gavo--1.1.5beta4gavo.sql: pgs_moc_compat.sql.in
 pg_sphere--1.1.5beta2gavo--1.1.5beta4gavo.sql:
 cat upgrade_scripts/$@.in $^ > $@

 pg_sphere--1.1.5beta4gavo--1.2.0.sql: pgs_moc_ops.sql.in
diff --git a/pgs_moc_compat.sql.in b/pgs_moc_compat.sql.in
diff --git a/upgrade_scripts/pg_sphere--1.3.1--1.3.2.sql.in b/upgrade_scripts/pg_sphere--1.3.1--1.3.2.sql.in
   WHEN OTHERS THEN RAISE;
 END;
 $$;

 -- remove legacy spellings of operators
 DROP OPERATOR IF EXISTS @(bigint, smoc);
 DROP OPERATOR IF EXISTS @(spoint, smoc);
Original file line number	Diff line number	Diff line change
Expand Up		@@ -65,7 +65,7 @@ endif
		PGS_SQL += pgs_gist_spoint3.sql

		ifneq ($(USE_HEALPIX),0)
		PGS_SQL += pgs_moc_type.sqlpgs_moc_compat.sqlpgs_moc_ops.sql \
		PGS_SQL += pgs_moc_type.sql pgs_moc_ops.sql \
		pgs_moc_geo_casts.sql
		endif

Expand DownExpand Up		@@ -154,7 +154,7 @@ ifneq ($(USE_HEALPIX),0)
		pg_sphere--1.1.5beta0gavo--1.1.5beta2gavo.sql: pgs_moc_type.sql.in
		cat upgrade_scripts/$@.in $^ > $@

		pg_sphere--1.1.5beta2gavo--1.1.5beta4gavo.sql: pgs_moc_compat.sql.in
		pg_sphere--1.1.5beta2gavo--1.1.5beta4gavo.sql:
		cat upgrade_scripts/$@.in $^ > $@

		pg_sphere--1.1.5beta4gavo--1.2.0.sql: pgs_moc_ops.sql.in
Expand Down
Original file line number	Diff line number	Diff line change
Expand Up		@@ -12,3 +12,7 @@ EXCEPTION
		WHEN OTHERS THEN RAISE;
		END;
		$$;

		-- remove legacy spellings of operators
		DROP OPERATOR IF EXISTS @(bigint, smoc);
		DROP OPERATOR IF EXISTS @(spoint, smoc);