databases/pgsphere: Remove expired port

2024-04-30 databases/pgsphere: The repository has been archived by the owner on 2023-08-09 and is inactive for almost 4.5 years

8 files changed, 1 insertions, 130 deletions

diff --git a/MOVED b/MOVED
index 446bde4b4723..e9e4cb096b56 100644
--- a/MOVED
+++ b/MOVED
@@ -3207,3 +3207,4 @@ x11-toolkits/p5-Tk-FileDialog||2024-04-30|Has expired: Does not work with recent
 www/py-django-dpaste||2024-04-30|Has expired
 dns/bind916|dns/bind918|2024-04-30|Has expired: End of life, please migrate to a newer version of BIND9
 devel/rubygem-ruby_dep||2024-04-30|Has expired: Upstream official support to Ruby 2.x only and is inactive for 7.5 years. And there is no dependent ports
+databases/pgsphere||2024-04-30|Has expired: The repository has been archived by the owner on 2023-08-09 and is inactive for almost 4.5 years
diff --git a/databases/Makefile b/databases/Makefile
index 5f97c2795586..3cbc1d002bf1 100644
--- a/databases/Makefile
+++ b/databases/Makefile
@@ -574,7 +574,6 @@
     SUBDIR += pgroonga
     SUBDIR += pgrouting
     SUBDIR += pgsanity
-    SUBDIR += pgsphere
     SUBDIR += pgtcl
     SUBDIR += pgtop
     SUBDIR += pguri
diff --git a/databases/pgsphere/Makefile b/databases/pgsphere/Makefile
deleted file mode 100644
index a1e28cb09d78..000000000000
--- a/databases/pgsphere/Makefile
+++ /dev/null
@@ -1,40 +0,0 @@
-PORTNAME=	pgsphere
-PORTVERSION=	1.1.5
-PORTREVISION=	4
-CATEGORIES=	databases geography
-
-MAINTAINER=	sunpoet@FreeBSD.org
-COMMENT=	Spherical data types, functions, and operators for PostgreSQL
-WWW=		https://pgsphere.github.io/
-
-LICENSE=	BSD3CLAUSE
-LICENSE_FILE=	${WRKSRC}/COPYRIGHT.pg_sphere
-
-DEPRECATED=	The repository has been archived by the owner on 2023-08-09 and is inactive for almost 4.5 years
-EXPIRATION_DATE=2024-04-30
-
-OPTIONS_DEFINE=	DOCS
-
-USES=		gmake pgsql
-LLD_UNSAFE=	yes
-USE_LDCONFIG=	yes
-MAKE_ARGS=	PG_CONFIG=${LOCALBASE}/bin/pg_config USE_PGXS=1 \
-		docdir=${DOCSDIR} \
-		install_bin=/usr/bin/install
-TEST_TARGET=	installcheck
-
-DATADIR=	${PREFIX}/share/postgresql
-DOCSDIR?=	${PREFIX}/share/doc/postgresql
-
-GH_TAGNAME=	e0b303d
-USE_GITHUB=	yes
-
-DOCS_MAKE_ARGS_OFF=	DOCS=""
-
-post-patch:
-	@${REINPLACE_CMD} -e 's|int4|int32|g' ${WRKSRC}/line.c ${WRKSRC}/line.h
-
-post-install:
-	${STRIP_CMD} ${STAGEDIR}${PREFIX}/lib/postgresql/pg_sphere.so
-
-.include <bsd.port.mk>
diff --git a/databases/pgsphere/distinfo b/databases/pgsphere/distinfo
deleted file mode 100644
index 100084f2a129..000000000000
--- a/databases/pgsphere/distinfo
+++ /dev/null
@@ -1,3 +0,0 @@
-TIMESTAMP = 1599860707
-SHA256 (pgsphere-pgsphere-1.1.5-e0b303d_GH0.tar.gz) = 8a96e9ec6d44d25aab4f8fdc17a914d39a85e5aeba42f609db63762f6f4c963d
-SIZE (pgsphere-pgsphere-1.1.5-e0b303d_GH0.tar.gz) = 458817
diff --git a/databases/pgsphere/files/patch-path.c b/databases/pgsphere/files/patch-path.c
deleted file mode 100644
index c4f4e14171c8..000000000000
--- a/databases/pgsphere/files/patch-path.c
+++ /dev/null
@@ -1,25 +0,0 @@
---- path.c.orig	2019-10-30 10:18:38 UTC
-+++ path.c
-@@ -513,13 +513,21 @@ spherepath_in(PG_FUNCTION_ARGS)
- 	nelem = get_path_count();
- 	if (nelem > 1)
- 	{
--		SPoint		arr[nelem];
-+		SPoint*		arr = (SPoint*)malloc(nelem*sizeof(SPoint));
-+		if (arr == NULL) {
-+			reset_buffer();
-+			elog(ERROR, "spherepath_in: could not allocate array");
-+			PG_RETURN_NULL();
-+		}
- 
- 		for (i = 0; i < nelem; i++)
- 		{
- 			get_path_elem(i, &arr[i].lng, &arr[i].lat);
- 		}
- 		path = spherepath_from_array(&arr[0], nelem);
-+
-+		//free array
-+		free(arr);
- 	}
- 	else
- 	{
diff --git a/databases/pgsphere/files/patch-polygon.c b/databases/pgsphere/files/patch-polygon.c
deleted file mode 100644
index 15ff051fe439..000000000000
--- a/databases/pgsphere/files/patch-polygon.c
+++ /dev/null
@@ -1,54 +0,0 @@
---- polygon.c.orig	2019-10-30 10:18:38 UTC
-+++ polygon.c
-@@ -824,13 +824,21 @@ spherepoly_in(PG_FUNCTION_ARGS)
- 	nelem = get_path_count();
- 	if (nelem > 2)
- 	{
--		SPoint		arr[nelem];
-+		// allocate arr
-+		SPoint* arr = (SPoint *)malloc(nelem * sizeof(SPoint));
-+		if (arr == NULL) {
-+			reset_buffer();
-+			elog(ERROR, "spherepoly_in: Could not allocate array.");
-+			PG_RETURN_NULL();
-+		}
- 
- 		for (i = 0; i < nelem; i++)
- 		{
- 			get_path_elem(i, &arr[i].lng, &arr[i].lat);
- 		}
- 		poly = spherepoly_from_array(&arr[0], nelem);
-+		// free allocated array
-+		free(arr);
- 	}
- 	else
- 	{
-@@ -892,11 +900,17 @@ spherepoly_area(PG_FUNCTION_ARGS)
- {
- 	SPOLY	   *poly = PG_GETARG_SPOLY(0);
- 	int32		i;
--	SPoint		s[poly->npts + 2];
-+	SPoint     *s = (SPoint*)malloc((poly->npts+2)*sizeof(SPoint));
-+	//SPoint		s[poly->npts + 2];
- 	SPoint		stmp[2];
- 	SEuler		se;
- 	float8		sum = 0.0;
- 
-+	if (s == NULL) {
-+		elog(ERROR, "spherepoly_area: Could not allocate array.");
-+		PG_RETURN_NULL();
-+	}
-+
- 	memcpy((void *) &s[1],
- 		   (void *) &poly->p[0],
- 		   poly->npts * sizeof(SPoint));
-@@ -935,6 +949,9 @@ spherepoly_area(PG_FUNCTION_ARGS)
- 	{
- 		sum = 0.0;
- 	}
-+
-+	// free array
-+	free(s);
- 
- 	PG_RETURN_FLOAT8(sum);
- }
diff --git a/databases/pgsphere/pkg-descr b/databases/pgsphere/pkg-descr
deleted file mode 100644
index 0de10b9db1ec..000000000000
--- a/databases/pgsphere/pkg-descr
+++ /dev/null
@@ -1,2 +0,0 @@
-PgSphere provides spherical data types, functions, operators, and indexing for
-PostgreSQL.
diff --git a/databases/pgsphere/pkg-plist b/databases/pgsphere/pkg-plist
deleted file mode 100644
index e3ddebbcb6fd..000000000000
--- a/databases/pgsphere/pkg-plist
+++ /dev/null
@@ -1,5 +0,0 @@
-lib/postgresql/pg_sphere.so
-%%PORTDOCS%%%%DOCSDIR%%/extension/COPYRIGHT.pg_sphere
-%%PORTDOCS%%%%DOCSDIR%%/extension/README.pg_sphere
-%%DATADIR%%/extension/pg_sphere--1.0.sql
-%%DATADIR%%/extension/pg_sphere.control