diff --git a/databases/pguri/Makefile b/databases/pguri/Makefile
index 7ea44d541924..555425b8f11e 100644
--- a/databases/pguri/Makefile
+++ b/databases/pguri/Makefile
@@ -1,27 +1,27 @@
 PORTNAME=	pguri
 PORTVERSION=	1.20151224
-PORTREVISION=	2
+PORTREVISION=	3
 CATEGORIES=	databases
 
 MAINTAINER=	tz@FreeBSD.org
 COMMENT=	URI datatype for PostgreSQL
 WWW=		https://github.com/petere/pguri
 
 BUILD_DEPENDS=	uriparser>=0.8.0:net/uriparser
 RUN_DEPENDS=	uriparser>=0.8.0:net/uriparser
 
 USES=		gmake pgsql pkgconfig
 LLD_UNSAFE=	yes
 
 USE_GITHUB=	yes
 GH_ACCOUNT=	petere
 
 PLIST_FILES=	lib/postgresql/uri.so share/postgresql/extension/uri--0.sql \
 		share/postgresql/extension/uri--1.sql \
 		share/postgresql/extension/uri--0--1.sql \
 		share/postgresql/extension/uri.control
 
 post-install:
 	${STRIP_CMD} ${STAGEDIR}${PREFIX}/lib/postgresql/uri.so
 
 .include <bsd.port.mk>
diff --git a/databases/pguri/files/patch-uri.c b/databases/pguri/files/patch-uri.c
new file mode 100644
index 000000000000..10a95328056d
--- /dev/null
+++ b/databases/pguri/files/patch-uri.c
@@ -0,0 +1,29 @@
+--- uri.c.orig	2024-06-13 16:34:21 UTC
++++ uri.c
+@@ -149,7 +149,7 @@ uri_host_inet(PG_FUNCTION_ARGS)
+ 		char *tmp = palloc(16);
+ 		snprintf(tmp, 16, "%u.%u.%u.%u", data[0], data[1], data[2], data[3]);
+ 		uriFreeUriMembersA(&uri);
+-		PG_RETURN_INET_P(DirectFunctionCall1(inet_in, CStringGetDatum(tmp)));
++		PG_RETURN_INET_P((inet *) (DirectFunctionCall1(inet_in, CStringGetDatum(tmp))));
+ 	}
+ 	else if (uri.hostData.ip6)
+ 	{
+@@ -161,7 +161,7 @@ uri_host_inet(PG_FUNCTION_ARGS)
+ 				 data[8], data[9], data[10], data[11],
+ 				 data[12], data[13], data[14], data[15]);
+ 		uriFreeUriMembersA(&uri);
+-		PG_RETURN_INET_P(DirectFunctionCall1(inet_in, CStringGetDatum(tmp)));
++		PG_RETURN_INET_P((inet *) (DirectFunctionCall1(inet_in, CStringGetDatum(tmp))));
+ 	}
+ 	else
+ 	{
+@@ -299,7 +299,7 @@ uri_path_array(PG_FUNCTION_ARGS)
+ 	uriFreeUriMembersA(&uri);
+ 
+ 	if (astate)
+-		PG_RETURN_ARRAYTYPE_P(makeArrayResult(astate, CurrentMemoryContext));
++		PG_RETURN_ARRAYTYPE_P((Pointer)(makeArrayResult(astate, CurrentMemoryContext)));
+ 	else
+ 		PG_RETURN_ARRAYTYPE_P(construct_empty_array(TEXTOID));
+ }