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
author: rene <rene@FreeBSD.org> 2019-09-19 20:02:32 +0800
committer: rene <rene@FreeBSD.org> 2019-09-19 20:02:32 +0800
commit: d739a01006e082d5c2deff30127a9801db64d1e5 (patch)
tree: a880e5f6525a408881315fbb588765c29c4e4f48 /databases
parent: 44992c72bb051c2786f99cc300433e40c2bb29a6 (diff)
download: freebsd-ports-gnome-d739a01006e082d5c2deff30127a9801db64d1e5.tar.gz
freebsd-ports-gnome-d739a01006e082d5c2deff30127a9801db64d1e5.tar.zst
freebsd-ports-gnome-d739a01006e082d5c2deff30127a9801db64d1e5.zip
24 files changed, 0 insertions, 929 deletions
diff --git a/databases/Makefile b/databases/Makefile
index 42350d60a83e..f700a21778bf 100644
--- a/databases/Makefile
+++ b/databases/Makefile
@@ -680,7 +680,6 @@
     SUBDIR += postgresql-odbc
     SUBDIR += postgresql-orafce
     SUBDIR += postgresql-plproxy
-    SUBDIR += postgresql-plruby
     SUBDIR += postgresql-plv8js
     SUBDIR += postgresql-prefix
     SUBDIR += postgresql-relay
@@ -1000,7 +999,6 @@
     SUBDIR += sequeler
     SUBDIR += sfcgal
     SUBDIR += sharedance
-    SUBDIR += skytools
     SUBDIR += slony1v2
     SUBDIR += soci
     SUBDIR += spatialite
@@ -1027,7 +1025,6 @@
     SUBDIR += sqlrelay
     SUBDIR += sqsh
     SUBDIR += squirrel-sql
-    SUBDIR += tablelog
     SUBDIR += tarantool
     SUBDIR += tarantool-c
     SUBDIR += tcl-Mysql
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
diff --git a/databases/skytools/Makefile b/databases/skytools/Makefile
deleted file mode 100644
index 521ec99d4497..000000000000
--- a/databases/skytools/Makefile
+++ /dev/null
@@ -1,42 +0,0 @@
-# Created by: Sergey Skvortsov <skv@protey.ru>
-# $FreeBSD$
-
-PORTNAME=	skytools
-PORTVERSION=	3.2
-PORTREVISION=	3
-CATEGORIES=	databases
-MASTER_SITES=	http://pgfoundry.org/frs/download.php/3622/
-
-MAINTAINER=	sam@cassiba.com
-COMMENT=	PostgreSQL tools from Skype: walshipping, queueing, replication
-
-DEPRECATED=	Abandonware
-EXPIRATION_DATE=	2019-09-15
-
-GNU_CONFIGURE=	yes
-USES=		gmake python:2.7 shebangfix pgsql
-LLD_UNSAFE=	yes
-
-SHEBANG_FILES=	setup_pkgloader.py setup_skytools.py \
-		scripts/catsql.py scripts/data_maintainer.py \
-		scripts/find_sql_functions.py scripts/grantfu.py \
-		scripts/queue_loader.py scripts/queue_splitter.py \
-		scripts/queue_mover.py scripts/scriptmgr.py \
-		scripts/simple_consumer.py scripts/simple_local_consumer.py \
-		scripts/skytools_upgrade.py
-
-CONFIGURE_ARGS=	--with-python=${PYTHON_CMD} \
-		--docdir=${EXAMPLESDIR} \
-		--with-pgconfig=${LOCALBASE}/bin/pg_config
-
-OPTIONS_DEFINE=	EXAMPLES
-
-post-patch:
-	@${REINPLACE_CMD} -e 's=share/doc=share/examples=' ${WRKSRC}/setup_skytools.py
-
-post-install:
-	${STRIP_CMD} ${STAGEDIR}${PREFIX}/bin/pgqd
-	${STRIP_CMD} ${STAGEDIR}${PYTHON_SITELIBDIR}/skytools/*.so
-	${STRIP_CMD} ${STAGEDIR}${PREFIX}/lib/postgresql/*.so
-
-.include <bsd.port.mk>
diff --git a/databases/skytools/distinfo b/databases/skytools/distinfo
deleted file mode 100644
index 14cacfbed709..000000000000
--- a/databases/skytools/distinfo
+++ /dev/null
@@ -1,2 +0,0 @@
-SHA256 (skytools-3.2.tar.gz) = 0fa9c819ab50ca2cbcc5e71cd80ab734120c9d628667af08f9a95ca62086ab5f
-SIZE (skytools-3.2.tar.gz) = 693507
diff --git a/databases/skytools/files/patch-sql_pgq_triggers_common.c b/databases/skytools/files/patch-sql_pgq_triggers_common.c
deleted file mode 100644
index 8575bb588388..000000000000
--- a/databases/skytools/files/patch-sql_pgq_triggers_common.c
+++ /dev/null
@@ -1,62 +0,0 @@
---- sql/pgq/triggers/common.c.orig	2019-08-05 04:40:08 UTC
-+++ sql/pgq/triggers/common.c
-@@ -125,9 +125,15 @@ static void fill_magic_columns(PgqTriggerEvent *ev)
- 
- 	for (i = 0; i < tupdesc->natts; i++) {
- 		/* Skip dropped columns */
-+#if PG_VERSION_NUM < 110000
- 		if (tupdesc->attrs[i]->attisdropped)
- 			continue;
- 		col_name = NameStr(tupdesc->attrs[i]->attname);
-+#else
-+		if (TupleDescAttr(tupdesc, i)->attisdropped)
-+			continue;
-+		col_name = NameStr(TupleDescAttr(tupdesc, i)->attname);
-+#endif
- 		if (!is_magic_field(col_name))
- 			continue;
- 		if (strcmp(col_name, "_pgq_ev_type") == 0)
-@@ -481,7 +487,11 @@ static void parse_oldstyle_args(PgqTriggerEvent *ev, T
- 	 */
- 	tupdesc = tg->tg_relation->rd_att;
- 	for (i = 0, attcnt = 0; i < tupdesc->natts; i++) {
-+#if PG_VERSION_NUM < 110000
- 		if (!tupdesc->attrs[i]->attisdropped)
-+#else
-+		if (!TupleDescAttr(tupdesc, i)->attisdropped)
-+#endif
- 			attcnt++;
- 	}
- 
-@@ -598,9 +608,15 @@ bool pgqtriga_skip_col(PgqTriggerEvent *ev, int i, int
- 	const char *name;
- 
- 	tupdesc = tg->tg_relation->rd_att;
-+#if PG_VERSION_NUM < 110000
- 	if (tupdesc->attrs[i]->attisdropped)
- 		return true;
- 	name = NameStr(tupdesc->attrs[i]->attname);
-+#else
-+	if (TupleDescAttr(tupdesc, i)->attisdropped)
-+		return true;
-+	name = NameStr(TupleDescAttr(tupdesc, i)->attname);
-+#endif
- 
- 	if (is_magic_field(name)) {
- 		ev->tgargs->custom_fields = 1;
-@@ -632,9 +648,15 @@ bool pgqtriga_is_pkey(PgqTriggerEvent *ev, int i, int 
- 		return ev->attkind[attkind_idx] == 'k';
- 	} else if (ev->pkey_list) {
- 		tupdesc = tg->tg_relation->rd_att;
-+#if PG_VERSION_NUM < 110000
- 		if (tupdesc->attrs[i]->attisdropped)
- 			return false;
- 		name = NameStr(tupdesc->attrs[i]->attname);
-+#else
-+		if (TupleDescAttr(tupdesc, i)->attisdropped)
-+			return false;
-+		name = NameStr(TupleDescAttr(tupdesc, i)->attname);
-+#endif
- 		if (is_magic_field(name)) {
- 			ev->tgargs->custom_fields = 1;
- 			return false;
diff --git a/databases/skytools/files/patch-sql_pgq_triggers_logutriga.c b/databases/skytools/files/patch-sql_pgq_triggers_logutriga.c
deleted file mode 100644
index 126f61bd6302..000000000000
--- a/databases/skytools/files/patch-sql_pgq_triggers_logutriga.c
+++ /dev/null
@@ -1,26 +0,0 @@
---- sql/pgq/triggers/logutriga.c.orig	2019-08-05 04:38:03 UTC
-+++ sql/pgq/triggers/logutriga.c
-@@ -54,7 +54,11 @@ static int is_interesting_change(PgqTriggerEvent *ev, 
- 		/*
- 		 * Ignore dropped columns
- 		 */
-+#if PG_VERSION_NUM < 110000
- 		if (tupdesc->attrs[i]->attisdropped)
-+#else
-+		if (TupleDescAttr(tupdesc, i)->attisdropped)
-+#endif
- 			continue;
- 		attkind_idx++;
- 
-@@ -145,7 +149,11 @@ void pgq_urlenc_row(PgqTriggerEvent *ev, HeapTuple row
- 
- 	for (i = 0; i < tg->tg_relation->rd_att->natts; i++) {
- 		/* Skip dropped columns */
-+#if PG_VERSION_NUM < 110000
- 		if (tupdesc->attrs[i]->attisdropped)
-+#else
-+		if (TupleDescAttr(tupdesc, i)->attisdropped)
-+#endif
- 			continue;
- 
- 		attkind_idx++;
diff --git a/databases/skytools/files/patch-sql_pgq_triggers_makesql.c b/databases/skytools/files/patch-sql_pgq_triggers_makesql.c
deleted file mode 100644
index e5e829680a48..000000000000
--- a/databases/skytools/files/patch-sql_pgq_triggers_makesql.c
+++ /dev/null
@@ -1,86 +0,0 @@
---- sql/pgq/triggers/makesql.c.orig	2019-08-05 04:44:33 UTC
-+++ sql/pgq/triggers/makesql.c
-@@ -71,7 +71,11 @@ static void process_insert(PgqTriggerEvent *ev, String
- 		char *col_ident;
- 
- 		/* Skip dropped columns */
-+#if PG_VERSION_NUM < 110000
- 		if (tupdesc->attrs[i]->attisdropped)
-+#else
-+		if (TupleDescAttr(tupdesc, i)->attisdropped)
-+#endif
- 			continue;
- 
- 		/* Check if allowed by colstring */
-@@ -103,7 +107,11 @@ static void process_insert(PgqTriggerEvent *ev, String
- 		char *col_value;
- 
- 		/* Skip dropped columns */
-+#if PG_VERSION_NUM < 110000
- 		if (tupdesc->attrs[i]->attisdropped)
-+#else
-+		if (TupleDescAttr(tupdesc, i)->attisdropped)
-+#endif
- 			continue;
- 
- 		/* Check if allowed by colstring */
-@@ -154,7 +162,11 @@ static int process_update(PgqTriggerEvent *ev, StringI
- 		/*
- 		 * Ignore dropped columns
- 		 */
-+#if PG_VERSION_NUM < 110000
- 		if (tupdesc->attrs[i]->attisdropped)
-+#else
-+		if (TupleDescAttr(tupdesc, i)->attisdropped)
-+#endif
- 			continue;
- 
- 		attkind_idx++;
-@@ -240,7 +252,11 @@ static int process_update(PgqTriggerEvent *ev, StringI
- 			return 0;
- 
- 		for (i = 0, attkind_idx = -1; i < tupdesc->natts; i++) {
-+#if PG_VERSION_NUM < 110000
- 			if (tupdesc->attrs[i]->attisdropped)
-+#else
-+			if (TupleDescAttr(tupdesc, i)->attisdropped)
-+#endif
- 				continue;
- 
- 			attkind_idx++;
-@@ -259,7 +275,11 @@ static int process_update(PgqTriggerEvent *ev, StringI
- 		/*
- 		 * Ignore dropped columns
- 		 */
-+#if PG_VERSION_NUM < 110000
- 		if (tupdesc->attrs[i]->attisdropped)
-+#else
-+		if (TupleDescAttr(tupdesc, i)->attisdropped)
-+#endif
- 			continue;
- 
- 		attkind_idx++;
-@@ -291,7 +311,11 @@ static void process_delete(PgqTriggerEvent *ev, String
- 	int attkind_idx;
- 
- 	for (i = 0, attkind_idx = -1; i < tupdesc->natts; i++) {
-+#if PG_VERSION_NUM < 110000
- 		if (tupdesc->attrs[i]->attisdropped)
-+#else
-+		if (TupleDescAttr(tupdesc, i)->attisdropped)
-+#endif
- 			continue;
- 
- 		attkind_idx++;
-@@ -323,7 +347,11 @@ int pgqtriga_make_sql(PgqTriggerEvent *ev, StringInfo 
- 	 * Count number of active columns
- 	 */
- 	for (i = 0, attcnt = 0; i < tupdesc->natts; i++) {
-+#if PG_VERSION_NUM < 110000
- 		if (tupdesc->attrs[i]->attisdropped)
-+#else
-+		if (TupleDescAttr(tupdesc, i)->attisdropped)
-+#endif
- 			continue;
- 		attcnt++;
- 	}
diff --git a/databases/skytools/files/patch-sql_pgq_triggers_stringutil.c b/databases/skytools/files/patch-sql_pgq_triggers_stringutil.c
deleted file mode 100644
index b66f5412a227..000000000000
--- a/databases/skytools/files/patch-sql_pgq_triggers_stringutil.c
+++ /dev/null
@@ -1,14 +0,0 @@
---- sql/pgq/triggers/stringutil.c.orig	2019-08-05 04:48:30 UTC
-+++ sql/pgq/triggers/stringutil.c
-@@ -19,7 +19,11 @@
- #include <postgres.h>
- #include <lib/stringinfo.h>
- #include <mb/pg_wchar.h>
-+#if PG_VERSION_NUM < 110000
- #include <parser/keywords.h>
-+#else
-+#include <common/keywords.h>
-+#endif
- #include <utils/memutils.h>
- 
- #include "stringutil.h"
diff --git a/databases/skytools/files/patch-sql_txid_Makefile b/databases/skytools/files/patch-sql_txid_Makefile
deleted file mode 100644
index 8d95cb29256f..000000000000
--- a/databases/skytools/files/patch-sql_txid_Makefile
+++ /dev/null
@@ -1,11 +0,0 @@
---- sql/txid/Makefile.orig	2013-07-29 08:14:55 UTC
-+++ sql/txid/Makefile
-@@ -12,7 +12,7 @@ pg83 = $(shell test $(PGVER) "<" "8.3" && echo "false"
- pg82 = $(shell test $(PGVER) "<" "8.2" && echo "false" || echo "true")
- endif
- 
--ifeq ($(pg83),true)  # we have 8.3 with internal txid
-+ifeq (1,1) # we always have >= 9.4 with internal txid
- 
- # install empty txid.sql
- DATA_built = txid.sql
diff --git a/databases/skytools/pkg-descr b/databases/skytools/pkg-descr
deleted file mode 100644
index e04f6cf87622..000000000000
--- a/databases/skytools/pkg-descr
+++ /dev/null
@@ -1,5 +0,0 @@
-This is a package of tools from Skype for replication and
-failover.  Also it includes a generic queuing mechanism PgQ and
-utility library for Python scripts.
-
-WWW: http://pgfoundry.org/projects/skytools/
diff --git a/databases/skytools/pkg-plist b/databases/skytools/pkg-plist
deleted file mode 100644
index ac1ce02ea901..000000000000
--- a/databases/skytools/pkg-plist
+++ /dev/null
@@ -1,213 +0,0 @@
-bin/data_maintainer3
-bin/londiste3
-bin/pgqd
-bin/qadmin
-bin/queue_mover3
-bin/queue_splitter3
-bin/scriptmgr3
-bin/simple_consumer3
-bin/simple_local_consumer3
-bin/skytools_upgrade3
-bin/walmgr3
-lib/postgresql/pgq_lowlevel.so
-lib/postgresql/pgq_triggers.so
-%%PYTHON_SITELIBDIR%%/londiste/__init__.py
-%%PYTHON_SITELIBDIR%%/londiste/__init__.pyc
-%%PYTHON_SITELIBDIR%%/londiste/compare.py
-%%PYTHON_SITELIBDIR%%/londiste/compare.pyc
-%%PYTHON_SITELIBDIR%%/londiste/exec_attrs.py
-%%PYTHON_SITELIBDIR%%/londiste/exec_attrs.pyc
-%%PYTHON_SITELIBDIR%%/londiste/handler.py
-%%PYTHON_SITELIBDIR%%/londiste/handler.pyc
-%%PYTHON_SITELIBDIR%%/londiste/handlers/__init__.py
-%%PYTHON_SITELIBDIR%%/londiste/handlers/__init__.pyc
-%%PYTHON_SITELIBDIR%%/londiste/handlers/applyfn.py
-%%PYTHON_SITELIBDIR%%/londiste/handlers/applyfn.pyc
-%%PYTHON_SITELIBDIR%%/londiste/handlers/bulk.py
-%%PYTHON_SITELIBDIR%%/londiste/handlers/bulk.pyc
-%%PYTHON_SITELIBDIR%%/londiste/handlers/dispatch.py
-%%PYTHON_SITELIBDIR%%/londiste/handlers/dispatch.pyc
-%%PYTHON_SITELIBDIR%%/londiste/handlers/multimaster.py
-%%PYTHON_SITELIBDIR%%/londiste/handlers/multimaster.pyc
-%%PYTHON_SITELIBDIR%%/londiste/handlers/qtable.py
-%%PYTHON_SITELIBDIR%%/londiste/handlers/qtable.pyc
-%%PYTHON_SITELIBDIR%%/londiste/handlers/shard.py
-%%PYTHON_SITELIBDIR%%/londiste/handlers/shard.pyc
-%%PYTHON_SITELIBDIR%%/londiste/handlers/vtable.py
-%%PYTHON_SITELIBDIR%%/londiste/handlers/vtable.pyc
-%%PYTHON_SITELIBDIR%%/londiste/playback.py
-%%PYTHON_SITELIBDIR%%/londiste/playback.pyc
-%%PYTHON_SITELIBDIR%%/londiste/repair.py
-%%PYTHON_SITELIBDIR%%/londiste/repair.pyc
-%%PYTHON_SITELIBDIR%%/londiste/setup.py
-%%PYTHON_SITELIBDIR%%/londiste/setup.pyc
-%%PYTHON_SITELIBDIR%%/londiste/syncer.py
-%%PYTHON_SITELIBDIR%%/londiste/syncer.pyc
-%%PYTHON_SITELIBDIR%%/londiste/table_copy.py
-%%PYTHON_SITELIBDIR%%/londiste/table_copy.pyc
-%%PYTHON_SITELIBDIR%%/londiste/util.py
-%%PYTHON_SITELIBDIR%%/londiste/util.pyc
-%%PYTHON_SITELIBDIR%%/pgq/__init__.py
-%%PYTHON_SITELIBDIR%%/pgq/__init__.pyc
-%%PYTHON_SITELIBDIR%%/pgq/baseconsumer.py
-%%PYTHON_SITELIBDIR%%/pgq/baseconsumer.pyc
-%%PYTHON_SITELIBDIR%%/pgq/cascade/__init__.py
-%%PYTHON_SITELIBDIR%%/pgq/cascade/__init__.pyc
-%%PYTHON_SITELIBDIR%%/pgq/cascade/admin.py
-%%PYTHON_SITELIBDIR%%/pgq/cascade/admin.pyc
-%%PYTHON_SITELIBDIR%%/pgq/cascade/consumer.py
-%%PYTHON_SITELIBDIR%%/pgq/cascade/consumer.pyc
-%%PYTHON_SITELIBDIR%%/pgq/cascade/nodeinfo.py
-%%PYTHON_SITELIBDIR%%/pgq/cascade/nodeinfo.pyc
-%%PYTHON_SITELIBDIR%%/pgq/cascade/worker.py
-%%PYTHON_SITELIBDIR%%/pgq/cascade/worker.pyc
-%%PYTHON_SITELIBDIR%%/pgq/consumer.py
-%%PYTHON_SITELIBDIR%%/pgq/consumer.pyc
-%%PYTHON_SITELIBDIR%%/pgq/coopconsumer.py
-%%PYTHON_SITELIBDIR%%/pgq/coopconsumer.pyc
-%%PYTHON_SITELIBDIR%%/pgq/event.py
-%%PYTHON_SITELIBDIR%%/pgq/event.pyc
-%%PYTHON_SITELIBDIR%%/pgq/localconsumer.py
-%%PYTHON_SITELIBDIR%%/pgq/localconsumer.pyc
-%%PYTHON_SITELIBDIR%%/pgq/producer.py
-%%PYTHON_SITELIBDIR%%/pgq/producer.pyc
-%%PYTHON_SITELIBDIR%%/pgq/remoteconsumer.py
-%%PYTHON_SITELIBDIR%%/pgq/remoteconsumer.pyc
-%%PYTHON_SITELIBDIR%%/pgq/status.py
-%%PYTHON_SITELIBDIR%%/pgq/status.pyc
-%%PYTHON_SITELIBDIR%%/pkgloader-1.0-py2.7.egg-info
-%%PYTHON_SITELIBDIR%%/pkgloader.py
-%%PYTHON_SITELIBDIR%%/pkgloader.pyc
-%%PYTHON_SITELIBDIR%%/skytools-3.2-py2.7.egg-info
-%%PYTHON_SITELIBDIR%%/skytools/__init__.py
-%%PYTHON_SITELIBDIR%%/skytools/__init__.pyc
-%%PYTHON_SITELIBDIR%%/skytools/_chashtext.so
-%%PYTHON_SITELIBDIR%%/skytools/_cquoting.so
-%%PYTHON_SITELIBDIR%%/skytools/_pyquoting.py
-%%PYTHON_SITELIBDIR%%/skytools/_pyquoting.pyc
-%%PYTHON_SITELIBDIR%%/skytools/adminscript.py
-%%PYTHON_SITELIBDIR%%/skytools/adminscript.pyc
-%%PYTHON_SITELIBDIR%%/skytools/apipkg.py
-%%PYTHON_SITELIBDIR%%/skytools/apipkg.pyc
-%%PYTHON_SITELIBDIR%%/skytools/checker.py
-%%PYTHON_SITELIBDIR%%/skytools/checker.pyc
-%%PYTHON_SITELIBDIR%%/skytools/config.py
-%%PYTHON_SITELIBDIR%%/skytools/config.pyc
-%%PYTHON_SITELIBDIR%%/skytools/dbservice.py
-%%PYTHON_SITELIBDIR%%/skytools/dbservice.pyc
-%%PYTHON_SITELIBDIR%%/skytools/dbstruct.py
-%%PYTHON_SITELIBDIR%%/skytools/dbstruct.pyc
-%%PYTHON_SITELIBDIR%%/skytools/fileutil.py
-%%PYTHON_SITELIBDIR%%/skytools/fileutil.pyc
-%%PYTHON_SITELIBDIR%%/skytools/gzlog.py
-%%PYTHON_SITELIBDIR%%/skytools/gzlog.pyc
-%%PYTHON_SITELIBDIR%%/skytools/hashtext.py
-%%PYTHON_SITELIBDIR%%/skytools/hashtext.pyc
-%%PYTHON_SITELIBDIR%%/skytools/installer_config.py
-%%PYTHON_SITELIBDIR%%/skytools/installer_config.pyc
-%%PYTHON_SITELIBDIR%%/skytools/natsort.py
-%%PYTHON_SITELIBDIR%%/skytools/natsort.pyc
-%%PYTHON_SITELIBDIR%%/skytools/parsing.py
-%%PYTHON_SITELIBDIR%%/skytools/parsing.pyc
-%%PYTHON_SITELIBDIR%%/skytools/plpy_applyrow.py
-%%PYTHON_SITELIBDIR%%/skytools/plpy_applyrow.pyc
-%%PYTHON_SITELIBDIR%%/skytools/psycopgwrapper.py
-%%PYTHON_SITELIBDIR%%/skytools/psycopgwrapper.pyc
-%%PYTHON_SITELIBDIR%%/skytools/querybuilder.py
-%%PYTHON_SITELIBDIR%%/skytools/querybuilder.pyc
-%%PYTHON_SITELIBDIR%%/skytools/quoting.py
-%%PYTHON_SITELIBDIR%%/skytools/quoting.pyc
-%%PYTHON_SITELIBDIR%%/skytools/scripting.py
-%%PYTHON_SITELIBDIR%%/skytools/scripting.pyc
-%%PYTHON_SITELIBDIR%%/skytools/skylog.py
-%%PYTHON_SITELIBDIR%%/skytools/skylog.pyc
-%%PYTHON_SITELIBDIR%%/skytools/sockutil.py
-%%PYTHON_SITELIBDIR%%/skytools/sockutil.pyc
-%%PYTHON_SITELIBDIR%%/skytools/sqltools.py
-%%PYTHON_SITELIBDIR%%/skytools/sqltools.pyc
-%%PYTHON_SITELIBDIR%%/skytools/timeutil.py
-%%PYTHON_SITELIBDIR%%/skytools/timeutil.pyc
-%%PYTHON_SITELIBDIR%%/skytools/tnetstrings.py
-%%PYTHON_SITELIBDIR%%/skytools/tnetstrings.pyc
-%%PYTHON_SITELIBDIR%%/skytools/utf8.py
-%%PYTHON_SITELIBDIR%%/skytools/utf8.pyc
-man/man1/londiste3.1.gz
-man/man1/pgqd.1.gz
-man/man1/qadmin.1.gz
-man/man1/queue_mover3.1.gz
-man/man1/queue_splitter3.1.gz
-man/man1/scriptmgr3.1.gz
-man/man1/simple_consumer3.1.gz
-man/man1/simple_local_consumer3.1.gz
-man/man1/skytools_upgrade3.1.gz
-man/man1/walmgr3.1.gz
-share/doc/postgresql/extension/README.pgq
-share/doc/postgresql/extension/README.pgq_ext
-%%PORTEXAMPLES%%%%EXAMPLESDIR%%3/conf/pgqd.ini.templ
-%%PORTEXAMPLES%%%%EXAMPLESDIR%%3/conf/wal-master.ini
-%%PORTEXAMPLES%%%%EXAMPLESDIR%%3/conf/wal-slave.ini
-share/postgresql/contrib/londiste.sql
-share/postgresql/contrib/londiste.upgrade.sql
-share/postgresql/contrib/newgrants_londiste.sql
-share/postgresql/contrib/newgrants_pgq.sql
-share/postgresql/contrib/newgrants_pgq_coop.sql
-share/postgresql/contrib/newgrants_pgq_ext.sql
-share/postgresql/contrib/newgrants_pgq_node.sql
-share/postgresql/contrib/oldgrants_londiste.sql
-share/postgresql/contrib/oldgrants_pgq.sql
-share/postgresql/contrib/oldgrants_pgq_coop.sql
-share/postgresql/contrib/oldgrants_pgq_ext.sql
-share/postgresql/contrib/oldgrants_pgq_node.sql
-share/postgresql/contrib/pgq.sql
-share/postgresql/contrib/pgq.upgrade.sql
-share/postgresql/contrib/pgq_coop.sql
-share/postgresql/contrib/pgq_coop.upgrade.sql
-share/postgresql/contrib/pgq_ext.sql
-share/postgresql/contrib/pgq_ext.upgrade.sql
-share/postgresql/contrib/pgq_lowlevel.sql
-share/postgresql/contrib/pgq_node.sql
-share/postgresql/contrib/pgq_node.upgrade.sql
-share/postgresql/contrib/pgq_triggers.sql
-share/postgresql/contrib/txid.sql
-share/postgresql/contrib/uninstall_pgq.sql
-share/postgresql/extension/londiste--3.1--3.2.sql
-share/postgresql/extension/londiste--3.1.1--3.2.sql
-share/postgresql/extension/londiste--3.1.3--3.2.sql
-share/postgresql/extension/londiste--3.1.4--3.2.sql
-share/postgresql/extension/londiste--3.1.6--3.2.sql
-share/postgresql/extension/londiste--3.2.sql
-share/postgresql/extension/londiste--unpackaged--3.2.sql
-share/postgresql/extension/londiste.control
-share/postgresql/extension/pgq--3.1--3.2.sql
-share/postgresql/extension/pgq--3.1.1--3.2.sql
-share/postgresql/extension/pgq--3.1.2--3.2.sql
-share/postgresql/extension/pgq--3.1.3--3.2.sql
-share/postgresql/extension/pgq--3.1.6--3.2.sql
-share/postgresql/extension/pgq--3.2.sql
-share/postgresql/extension/pgq--unpackaged--3.2.sql
-share/postgresql/extension/pgq.control
-share/postgresql/extension/pgq_coop--3.1--3.1.1.sql
-share/postgresql/extension/pgq_coop--3.1.1.sql
-share/postgresql/extension/pgq_coop--unpackaged--3.1.1.sql
-share/postgresql/extension/pgq_coop.control
-share/postgresql/extension/pgq_ext--3.1.sql
-share/postgresql/extension/pgq_ext--unpackaged--3.1.sql
-share/postgresql/extension/pgq_ext.control
-share/postgresql/extension/pgq_node--3.1--3.2.sql
-share/postgresql/extension/pgq_node--3.1.3--3.2.sql
-share/postgresql/extension/pgq_node--3.1.6--3.2.sql
-share/postgresql/extension/pgq_node--3.2.sql
-share/postgresql/extension/pgq_node--unpackaged--3.2.sql
-share/postgresql/extension/pgq_node.control
-%%DATADIR%%3/londiste.sql
-%%DATADIR%%3/londiste.upgrade.sql
-%%DATADIR%%3/londiste.upgrade_2.1_to_3.1.sql
-%%DATADIR%%3/pgq.sql
-%%DATADIR%%3/pgq.upgrade.sql
-%%DATADIR%%3/pgq.upgrade_2.1_to_3.0.sql
-%%DATADIR%%3/pgq_coop.sql
-%%DATADIR%%3/pgq_coop.upgrade.sql
-%%DATADIR%%3/pgq_ext.sql
-%%DATADIR%%3/pgq_ext.upgrade.sql
-%%DATADIR%%3/pgq_node.sql
-%%DATADIR%%3/pgq_node.upgrade.sql
diff --git a/databases/tablelog/Makefile b/databases/tablelog/Makefile
deleted file mode 100644
index e6bcade59c88..000000000000
--- a/databases/tablelog/Makefile
+++ /dev/null
@@ -1,39 +0,0 @@
-# Created by: Robert Gogolok <gogo@cs.uni-sb.de>
-# $FreeBSD$
-
-PORTNAME=	tablelog
-PORTVERSION=	0.4.4
-PORTREVISION=	3
-CATEGORIES=	databases
-MASTER_SITES=	http://pgfoundry.org/frs/download.php/1387/
-
-MAINTAINER=	ports@FreeBSD.org
-COMMENT=	Logs changes on a table in PostgreSQL
-
-LICENSE=	PostgreSQL
-
-DEPRECATED=	Abandonware
-EXPIRATION_DATE=	2019-09-15
-
-WRKSRC=		${WRKDIR}/table_log-${DISTVERSION}
-
-USES=		gmake pgsql
-LLD_UNSAFE=	yes
-MAKE_ARGS=	USE_PGXS=1
-
-OPTIONS_DEFINE=	DOCS
-
-do-install:
-	@${MKDIR} ${STAGEDIR}${PREFIX}/lib/postgresql/
-	${INSTALL_LIB} ${WRKSRC}/table_log.so \
-		${STAGEDIR}${PREFIX}/lib/postgresql/
-	@${MKDIR} ${STAGEDIR}${PREFIX}/share/postgresql/contrib/
-	${INSTALL_DATA} ${WRKSRC}/table_log_init.sql \
-		${STAGEDIR}${PREFIX}/share/postgresql/contrib/
-
-do-install-DOCS-on:
-	@${MKDIR} ${STAGEDIR}${DOCSDIR}/
-	cd ${WRKSRC} && ${INSTALL_DATA} README.table_log table_log.sql \
-		${STAGEDIR}${DOCSDIR}/
-
-.include <bsd.port.mk>
diff --git a/databases/tablelog/distinfo b/databases/tablelog/distinfo
deleted file mode 100644
index 3bb95db98605..000000000000
--- a/databases/tablelog/distinfo
+++ /dev/null
@@ -1,2 +0,0 @@
-SHA256 (tablelog-0.4.4.tar.gz) = 58c84388daf7ef0b692be981821f2586d9553901005b613581e0fcdb7ed51ffd
-SIZE (tablelog-0.4.4.tar.gz) = 14197
diff --git a/databases/tablelog/files/patch-table__log.c b/databases/tablelog/files/patch-table__log.c
deleted file mode 100644
index 6a043b4542d4..000000000000
--- a/databases/tablelog/files/patch-table__log.c
+++ /dev/null
@@ -1,59 +0,0 @@
---- table_log.c.orig	2007-05-16 23:14:04 UTC
-+++ table_log.c
-@@ -22,6 +22,8 @@
- #include "utils/formatting.h"
- #include "utils/builtins.h"
- #include <utils/lsyscache.h>
-+#include <utils/rel.h>
-+#include <utils/timestamp.h>
- #include <funcapi.h>
- 
- /* for PostgreSQL >= 8.2.x */
-@@ -71,7 +73,11 @@ int count_columns (TupleDesc tupleDesc) {
-   int i;
- 
-   for (i = 0; i < tupleDesc->natts; ++i) {
-+#if PG_VERSION_NUM < 110000
-     if (!tupleDesc->attrs[i]->attisdropped) {
-+#else
-+    if (!tupleDesc->attrs[i].attisdropped) {
-+#endif
-       ++count;
-     }
-   }
-@@ -298,7 +304,11 @@ static void __table_log (TriggerData *trigdata, char *
-     col_nr++;
-     found_col = 0;
-     do {
-+#if PG_VERSION_NUM < 110000
-       if (trigdata->tg_relation->rd_att->attrs[col_nr - 1]->attisdropped) {
-+#else
-+      if (trigdata->tg_relation->rd_att->attrs[col_nr - 1].attisdropped) {
-+#endif
-         /* this column is dropped, skip it */
-         col_nr++;
-         continue;
-@@ -343,7 +353,11 @@ static void __table_log (TriggerData *trigdata, char *
-     col_nr++;
-     found_col = 0;
-     do {
-+#if PG_VERSION_NUM < 110000
-       if (trigdata->tg_relation->rd_att->attrs[col_nr - 1]->attisdropped) {
-+#else
-+      if (trigdata->tg_relation->rd_att->attrs[col_nr - 1].attisdropped) {
-+#endif
-         /* this column is dropped, skip it */
-         col_nr++;
-         continue;
-@@ -370,7 +384,11 @@ static void __table_log (TriggerData *trigdata, char *
-     col_nr++;
-     found_col = 0;
-     do {
-+#if PG_VERSION_NUM < 110000
-       if (trigdata->tg_relation->rd_att->attrs[col_nr - 1]->attisdropped) {
-+#else
-+      if (trigdata->tg_relation->rd_att->attrs[col_nr - 1].attisdropped) {
-+#endif
-         /* this column is dropped, skip it */
-         col_nr++;
-         continue;
diff --git a/databases/tablelog/pkg-descr b/databases/tablelog/pkg-descr
deleted file mode 100644
index 4a6603cae3fd..000000000000
--- a/databases/tablelog/pkg-descr
+++ /dev/null
@@ -1,6 +0,0 @@
-Tablelog is a contributed PostgreSQL module that uses a trigger to log
-any INSERTs, UPDATEs and DELETEs on a specific table into another table.
-The second part of tablelog is able to restore the state of the original
-table or of a specific row for any time in the past.
-
-WWW: http://pgfoundry.org/projects/tablelog/
diff --git a/databases/tablelog/pkg-plist b/databases/tablelog/pkg-plist
deleted file mode 100644
index acbe12d007a2..000000000000
--- a/databases/tablelog/pkg-plist
+++ /dev/null
@@ -1,4 +0,0 @@
-lib/postgresql/table_log.so
-share/postgresql/contrib/table_log_init.sql
-%%PORTDOCS%%%%DOCSDIR%%/README.table_log
-%%PORTDOCS%%%%DOCSDIR%%/table_log.sql
author	rene <rene@FreeBSD.org>	2019-09-19 20:02:32 +0800
committer	rene <rene@FreeBSD.org>	2019-09-19 20:02:32 +0800
commit	d739a01006e082d5c2deff30127a9801db64d1e5 (patch)
tree	a880e5f6525a408881315fbb588765c29c4e4f48 /databases
parent	44992c72bb051c2786f99cc300433e40c2bb29a6 (diff)
download	freebsd-ports-gnome-d739a01006e082d5c2deff30127a9801db64d1e5.tar.gz freebsd-ports-gnome-d739a01006e082d5c2deff30127a9801db64d1e5.tar.zst freebsd-ports-gnome-d739a01006e082d5c2deff30127a9801db64d1e5.zip