Remove expired ports:

2019-09-15 databases/postgresql-plruby: Abandonware
2019-09-15 databases/tablelog: Abandonware
2019-09-15 databases/skytools: Abandonware

Event:	EuroBSDCon 2019 developer summit

9 files changed, 0 insertions, 355 deletions

diff --git a/databases/postgresql-plruby/Makefile b/databases/postgresql-plruby/Makefile
deleted file mode 100644
index 68c53c83a586..000000000000
--- a/databases/postgresql-plruby/Makefile
+++ /dev/null
@@ -1,66 +0,0 @@
-# Created by: Akinori MUSHA aka knu <knu@idaemons.org>
-# $FreeBSD$
-
-PORTNAME=	postgresql-plruby
-PORTVERSION=	0.5.7
-PORTREVISION=	4
-CATEGORIES=	databases ruby
-DIST_SUBDIR=	ruby
-
-MAINTAINER=	knu@FreeBSD.org
-COMMENT=	PL/Ruby procedural language for the PostgreSQL database system
-
-LICENSE=	BSD2CLAUSE RUBY
-LICENSE_COMB=	dual
-
-DEPRECATED=		Abandonware
-EXPIRATION_DATE=	2019-09-15
-BROKEN_powerpc64=	fails to build: ruby.h:628:35: call to 'ruby_safe_level_2_error' declared with attribute error: $SAFE=2 to 4 are obsolete
-BROKEN_RUBY26=		yes
-
-USES=		uidfix pgsql
-WANT_PGSQL=	server
-USE_RUBY=	yes
-USE_RUBY_EXTCONF=	yes
-
-USE_GITHUB=	yes
-GH_ACCOUNT=	devrimgunduz
-
-POSTGRESQL_PORT?=	databases/postgresql${PGSQL_VER_NODOT}-server
-PGSQL_PORTDIR?=		${PORTSDIR}/${POSTGRESQL_PORT}
-PGSQL_WRKSRC_CMD=	cd ${PGSQL_PORTDIR} && ${MAKE} -V WRKSRC
-
-CONFIGURE_ARGS=		--with-pg-config="${LOCALBASE}/bin/pg_config" \
-			--with-pgsql-srcinc="`${PGSQL_WRKSRC_CMD}`/src/include"
-#CONFIGURE_ARGS+=	--with-safe-level=0
-#CONFIGURE_ARGS+=	--with-main-safe-level=0
-#CONFIGURE_ARGS+=	--with-timeout=30
-INSTALL_TARGET=	site-install
-
-DOCS=		Changes plruby.html plruby.rd
-
-OPTIONS_DEFINE=	DOCS
-
-PKGMESSAGE=	${WRKDIR}/createlang.sql
-
-post-fetch:
-	cd ${PGSQL_PORTDIR} && ${MAKE} -DBATCH patch
-
-post-build:
-	${SED} 's,!!PLRUBY_SO!!,${RUBY_SITEARCHLIBDIR}/plruby.so,' \
-		${FILESDIR}/createlang.sql > ${WRKDIR}/createlang.sql
-
-post-build-DOCS-on:
-	cd ${BUILD_WRKSRC}; ${SETENV} ${MAKE_ENV} ${MAKE} ${MAKE_FLAGS} ${MAKEFILE} ${MAKE_ARGS} rdoc
-
-post-install:
-	@${MKDIR} ${STAGEDIR}${RUBY_MODEXAMPLESDIR}/
-	${INSTALL_DATA} ${WRKDIR}/createlang.sql ${STAGEDIR}${RUBY_MODEXAMPLESDIR}/
-
-post-install-DOCS-on:
-	@${MKDIR} ${STAGEDIR}${RUBY_MODDOCDIR}
-	cd ${WRKSRC}/ && ${COPYTREE_SHARE} docs/doc ${STAGEDIR}${RUBY_MODDOCDIR}/ README.markdown && ${INSTALL_DATA} ${DOCS} ${STAGEDIR}${RUBY_MODDOCDIR}/
-	${FIND} -ds ${STAGEDIR}${RUBY_MODDOCDIR} -type f -print | ${SED} -E -e \
-		's,^${STAGEDIR}${PREFIX}/?,,' >> ${TMPPLIST}
-
-.include <bsd.port.mk>
diff --git a/databases/postgresql-plruby/distinfo b/databases/postgresql-plruby/distinfo
deleted file mode 100644
index abdc85be8e7c..000000000000
--- a/databases/postgresql-plruby/distinfo
+++ /dev/null
@@ -1,3 +0,0 @@
-TIMESTAMP = 1496059108
-SHA256 (ruby/devrimgunduz-postgresql-plruby-0.5.7_GH0.tar.gz) = 3eb33599e1f4b36d061268d6fe07ae20d28fd5468bb097e8c16a854a7cbf0c9a
-SIZE (ruby/devrimgunduz-postgresql-plruby-0.5.7_GH0.tar.gz) = 123579
diff --git a/databases/postgresql-plruby/files/createlang.sql b/databases/postgresql-plruby/files/createlang.sql
deleted file mode 100644
index 09bd2f3942f7..000000000000
--- a/databases/postgresql-plruby/files/createlang.sql
+++ /dev/null
@@ -1,15 +0,0 @@
---
--- Execute the following SQL statements to enable PL/Ruby.
---
--- $FreeBSD$
---
-
-CREATE FUNCTION plruby_call_handler() RETURNS language_handler
-	AS '!!PLRUBY_SO!!'
-	LANGUAGE 'C';
-
-CREATE TRUSTED LANGUAGE 'plruby'
-	HANDLER plruby_call_handler
-	LANCOMPILER 'PL/Ruby';
-
---
diff --git a/databases/postgresql-plruby/files/patch-extconf.rb b/databases/postgresql-plruby/files/patch-extconf.rb
deleted file mode 100644
index 6783678a9018..000000000000
--- a/databases/postgresql-plruby/files/patch-extconf.rb
+++ /dev/null
@@ -1,13 +0,0 @@
---- extconf.rb.orig	2017-05-28 08:47:01 UTC
-+++ extconf.rb
-@@ -122,6 +122,10 @@ end
- case version_str = `#{pg_config} --version`
- when /^PostgreSQL ([7-9])\.([0-9]{1,3})(\.[0-9]{1,3})?$/
-    version = 10 * $1.to_i + $2.to_i
-+when /^PostgreSQL 11/
-+   version = 110
-+when /^PostgreSQL 10/
-+   version = 100
- else
-    version = 0
- end
diff --git a/databases/postgresql-plruby/files/patch-src__plruby.h b/databases/postgresql-plruby/files/patch-src__plruby.h
deleted file mode 100644
index 9aac16fb1ac0..000000000000
--- a/databases/postgresql-plruby/files/patch-src__plruby.h
+++ /dev/null
@@ -1,21 +0,0 @@
---- ./src/plruby.h.orig	2012-12-23 14:51:17.000000000 +0100
-+++ ./src/plruby.h	2013-11-19 15:29:16.000000000 +0100
-@@ -7,6 +7,7 @@
- #include "executor/executor.h"
- #include "commands/trigger.h"
- #include "utils/elog.h"
-+#include "utils/rel.h"
- #include "utils/builtins.h"
- #include "fmgr.h"
- #include "access/heapam.h"
-@@ -35,6 +36,10 @@
- #include "utils/memutils.h"
- #endif
- 
-+#if PG_PL_VERSION >= 93
-+#include "access/htup_details.h"
-+#endif
-+
- #include "package.h"
- 
- #include <ruby.h>
diff --git a/databases/postgresql-plruby/files/patch-src_plpl.c b/databases/postgresql-plruby/files/patch-src_plpl.c
deleted file mode 100644
index 6f8b02ac4a81..000000000000
--- a/databases/postgresql-plruby/files/patch-src_plpl.c
+++ /dev/null
@@ -1,151 +0,0 @@
---- src/plpl.c.orig	2019-08-04 04:35:14 UTC
-+++ src/plpl.c
-@@ -137,12 +137,21 @@ pl_query_name(VALUE obj)
-     }
-     res = rb_ary_new2(tpl->dsc->natts);
-     for (i = 0; i < tpl->dsc->natts; i++) {
-+#if PG_VERSION_NUM < 110000
-         if (tpl->dsc->attrs[i]->attisdropped) {
-             attname = "";
-         }
-         else {
-             attname = NameStr(tpl->dsc->attrs[i]->attname);
-         }
-+#else
-+        if (TupleDescAttr(tpl->dsc, i)->attisdropped) {
-+            attname = "";
-+        }
-+        else {
-+            attname = NameStr(TupleDescAttr(tpl->dsc, i)->attname);
-+        }
-+#endif
-         rb_ary_push(res, rb_tainted_str_new2(attname));
-     }
-     return res;
-@@ -178,6 +187,7 @@ pl_query_type(VALUE obj)
-     }
-     res = rb_ary_new2(tpl->dsc->natts);
-     for (i = 0; i < tpl->dsc->natts; i++) {
-+#if PG_VERSION_NUM < 110000
-         if (tpl->dsc->attrs[i]->attisdropped)
-             continue;
-         PLRUBY_BEGIN(1);
-@@ -189,6 +199,19 @@ pl_query_type(VALUE obj)
-             rb_raise(pl_ePLruby, "Cache lookup for attribute '%s' type %ld failed",
-                      attname, OidGD(tpl->dsc->attrs[i]->atttypid));
-         }
-+#else
-+        if (TupleDescAttr(tpl->dsc, i)->attisdropped)
-+            continue;
-+        PLRUBY_BEGIN(1);
-+        attname = NameStr(TupleDescAttr(tpl->dsc, i)->attname);
-+        typeTup = SearchSysCache(TYPEOID, OidGD(TupleDescAttr(tpl->dsc, i)->atttypid),
-+                                 0, 0, 0);
-+        PLRUBY_END;
-+        if (!HeapTupleIsValid(typeTup)) {
-+            rb_raise(pl_ePLruby, "Cache lookup for attribute '%s' type %ld failed",
-+                     attname, OidGD(TupleDescAttr(tpl->dsc, i)->atttypid));
-+        }
-+#endif
-         fpgt = (Form_pg_type) GETSTRUCT(typeTup);
-         rb_ary_push(res, rb_tainted_str_new2(NameStr(fpgt->typname)));
-         ReleaseSysCache(typeTup);
-@@ -588,14 +611,23 @@ pl_tuple_heap(VALUE c, VALUE tuple)
-     MEMZERO(nulls, char, RARRAY_LEN(c));
-     for (i = 0; i < RARRAY_LEN(c); i++) {
-         if (NIL_P(RARRAY_PTR(c)[i]) || 
-+#if PG_VERSION_NUM < 110000
-             tupdesc->attrs[i]->attisdropped) {
-+#else
-+            TupleDescAttr(tupdesc, i)->attisdropped) {
-+#endif
-             dvalues[i] = (Datum)0;
-             nulls[i] = 'n';
-         }
-         else {
-             nulls[i] = ' ';
-+#if PG_VERSION_NUM < 110000
-             typid =  tupdesc->attrs[i]->atttypid;
-             if (tupdesc->attrs[i]->attndims != 0 ||
-+#else
-+            typid =  TupleDescAttr(tupdesc, i)->atttypid;
-+            if (TupleDescAttr(tupdesc, i)->attndims != 0 ||
-+#endif
- 		tpl->att->attinfuncs[i].fn_addr == (PGFunction)array_in) {
-                 pl_proc_desc prodesc;
-                 FmgrInfo func;
-@@ -1088,6 +1120,7 @@ plruby_build_tuple(HeapTuple tuple, TupleDesc tupdesc,
-     }
- 
-     for (i = 0; i < tupdesc->natts; i++) {
-+#if PG_VERSION_NUM < 110000
-         if (tupdesc->attrs[i]->attisdropped)
-             continue;
-         PLRUBY_BEGIN(1);
-@@ -1101,7 +1134,21 @@ plruby_build_tuple(HeapTuple tuple, TupleDesc tupdesc,
-             rb_raise(pl_ePLruby, "Cache lookup for attribute '%s' type %ld failed",
-                      attname, OidGD(tupdesc->attrs[i]->atttypid));
-         }
-+#else
-+        if (TupleDescAttr(tupdesc, i)->attisdropped)
-+            continue;
-+        PLRUBY_BEGIN(1);
-+        attname = NameStr(TupleDescAttr(tupdesc, i)->attname);
-+        attr = heap_getattr(tuple, i + 1, tupdesc, &isnull);
-+        typeTup = SearchSysCache(TYPEOID, OidGD(TupleDescAttr(tupdesc, i)->atttypid),
-+                                 0, 0, 0);
-+        PLRUBY_END;
- 
-+        if (!HeapTupleIsValid(typeTup)) {
-+            rb_raise(pl_ePLruby, "Cache lookup for attribute '%s' type %ld failed",
-+                     attname, OidGD(TupleDescAttr(tupdesc, i)->atttypid));
-+        }
-+#endif
-         fpgt = (Form_pg_type) GETSTRUCT(typeTup);
-         typoutput = (Oid) (fpgt->typoutput);
- #if PG_PL_VERSION >= 75
-@@ -1115,6 +1162,7 @@ plruby_build_tuple(HeapTuple tuple, TupleDesc tupdesc,
-             int alen;
- 
-             typname = NameStr(fpgt->typname);
-+#if PG_VERSION_NUM < 110000
-             alen = tupdesc->attrs[i]->attlen;
-             typeid = tupdesc->attrs[i]->atttypid;
-             if (strcmp(typname, "text") == 0) {
-@@ -1129,6 +1177,22 @@ plruby_build_tuple(HeapTuple tuple, TupleDesc tupdesc,
-                     alen = tupdesc->attrs[i]->atttypmod - 4;
-                 }
-             }
-+#else
-+            alen = TupleDescAttr(tupdesc, i)->attlen;
-+            typeid = TupleDescAttr(tupdesc, i)->atttypid;
-+            if (strcmp(typname, "text") == 0) {
-+                alen = -1;
-+            }
-+            else if (strcmp(typname, "bpchar") == 0 ||
-+                     strcmp(typname, "varchar") == 0) {
-+                if (TupleDescAttr(tupdesc, i)->atttypmod == -1) {
-+                    alen = 0;
-+                }
-+                else {
-+                    alen = TupleDescAttr(tupdesc, i)->atttypmod - 4;
-+                }
-+            }
-+#endif
-             if ((type_ret & RET_DESC_ARR) == RET_DESC_ARR) {
-                 res = rb_ary_new();
-                 rb_ary_push(res, rb_tainted_str_new2(attname));
-@@ -1190,8 +1254,13 @@ plruby_build_tuple(HeapTuple tuple, TupleDesc tupdesc,
-                 
-                 fmgr_info(typoutput, &finfo);
-                 
-+#if PG_VERSION_NUM < 110000
-                 s = pl_convert_arg(attr, tupdesc->attrs[i]->atttypid,
-                                    &finfo, typelem,tupdesc->attrs[i]->attlen);
-+#else
-+                s = pl_convert_arg(attr, tupdesc->attrs[i].atttypid,
-+                                   &finfo, typelem, TupleDescAttr(tupdesc, i)->attlen);
-+#endif
-             }
-             PLRUBY_END_PROTECT;
- 
diff --git a/databases/postgresql-plruby/files/patch-src_plruby.c b/databases/postgresql-plruby/files/patch-src_plruby.c
deleted file mode 100644
index c840896b462a..000000000000
--- a/databases/postgresql-plruby/files/patch-src_plruby.c
+++ /dev/null
@@ -1,74 +0,0 @@
---- src/plruby.c.orig	2019-08-04 04:30:44 UTC
-+++ src/plruby.c
-@@ -1184,17 +1184,29 @@ for_numvals(obj, argobj)
-         rb_raise(pl_ePLruby, "invalid attribute '%s'", RSTRING_PTR(key));
-     }
-     attnum -= 1;
-+#if PG_VERSION_NUM < 110000
-     if (arg->tupdesc->attrs[attnum]->attisdropped) {
-+#else
-+    if (TupleDescAttr(arg->tupdesc, attnum)->attisdropped) {
-+#endif
-         return Qnil;
-     }
- 
-     PLRUBY_BEGIN(1);
-     typeTup = SearchSysCache(TYPEOID,
-+#if PG_VERSION_NUM < 110000
-                              OidGD(arg->tupdesc->attrs[attnum]->atttypid),
-+#else
-+                             OidGD(TupleDescAttr(arg->tupdesc, attnum)->atttypid),
-+#endif
-                              0, 0, 0);
-     if (!HeapTupleIsValid(typeTup)) {   
-         rb_raise(pl_ePLruby, "Cache lookup for attribute '%s' type %ld failed",
-+#if PG_VERSION_NUM < 110000
-                  RSTRING_PTR(key), OidGD(arg->tupdesc->attrs[attnum]->atttypid));
-+#else
-+                 RSTRING_PTR(key), OidGD(TupleDescAttr(arg->tupdesc, attnum)->atttypid));
-+#endif
-     }
-     fpg = (Form_pg_type) GETSTRUCT(typeTup);
-     ReleaseSysCache(typeTup);
-@@ -1226,11 +1238,19 @@ for_numvals(obj, argobj)
-     else {
-         arg->modvalues[attnum] = 
-             plruby_to_datum(value, &finfo, 
-+#if PG_VERSION_NUM < 110000
-                             arg->tupdesc->attrs[attnum]->atttypid, 
-                             fpg->typelem,
-                             (!VARLENA_FIXED_SIZE(arg->tupdesc->attrs[attnum]))
-                             ? arg->tupdesc->attrs[attnum]->attlen
-                             : arg->tupdesc->attrs[attnum]->atttypmod);
-+#else
-+                            TupleDescAttr(arg->tupdesc, attnum)->atttypid, 
-+                            fpg->typelem,
-+                            (!VARLENA_FIXED_SIZE(TupleDescAttr(arg->tupdesc, attnum)))
-+                            ? TupleDescAttr(arg->tupdesc, attnum)->attlen
-+                            : TupleDescAttr(arg->tupdesc, attnum)->atttypmod);
-+#endif
-     }
-     return Qnil;
- }
-@@ -1284,12 +1304,21 @@ pl_trigger_handler(struct pl_thread_st *plth)
- 
-     tmp = rb_ary_new2(tupdesc->natts);
-     for (i = 0; i < tupdesc->natts; i++) {
-+#if PG_VERSION_NUM < 110000
-         if (tupdesc->attrs[i]->attisdropped) {
-             rb_ary_push(tmp, rb_str_freeze_new2(""));
-         }
-         else {
-             rb_ary_push(tmp, rb_str_freeze_new2(NameStr(tupdesc->attrs[i]->attname)));
-         }
-+#else
-+        if (TupleDescAttr(tupdesc, i)->attisdropped) {
-+            rb_ary_push(tmp, rb_str_freeze_new2(""));
-+        }
-+        else {
-+            rb_ary_push(tmp, rb_str_freeze_new2(NameStr(TupleDescAttr(tupdesc, i)->attname)));
-+        }
-+#endif
-     }
-     rb_hash_aset(TG, rb_str_freeze_new2("relatts"), rb_ary_freeze(tmp));
- 
diff --git a/databases/postgresql-plruby/pkg-descr b/databases/postgresql-plruby/pkg-descr
deleted file mode 100644
index 42f08e2c01bf..000000000000
--- a/databases/postgresql-plruby/pkg-descr
+++ /dev/null
@@ -1,5 +0,0 @@
-PL/Ruby is a loadable procedural language for the PostgreSQL database
-system (7.0 or later) that enables to write functions and trigger
-procedures in Ruby.
-
-WWW: https://github.com/knu/postgresql-plruby
diff --git a/databases/postgresql-plruby/pkg-plist b/databases/postgresql-plruby/pkg-plist
deleted file mode 100644
index 5169a81cfab3..000000000000
--- a/databases/postgresql-plruby/pkg-plist
+++ /dev/null
@@ -1,7 +0,0 @@
-%%RUBY_SITEARCHLIBDIR%%/plruby.so
-%%RUBY_SITEARCHLIBDIR%%/plruby/plruby_basic.so
-%%RUBY_SITEARCHLIBDIR%%/plruby/plruby_bitstring.so
-%%RUBY_SITEARCHLIBDIR%%/plruby/plruby_datetime.so
-%%RUBY_SITEARCHLIBDIR%%/plruby/plruby_geometry.so
-%%RUBY_SITEARCHLIBDIR%%/plruby/plruby_network.so
-%%PORTDOCS%%%%RUBY_MODEXAMPLESDIR%%/createlang.sql