Index: head/databases/skytools/Makefile =================================================================== --- head/databases/skytools/Makefile (revision 509207) +++ head/databases/skytools/Makefile (revision 509208) @@ -1,39 +1,42 @@ # Created by: Sergey Skvortsov # $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 Index: head/databases/skytools/files/patch-sql_pgq_triggers_common.c =================================================================== --- head/databases/skytools/files/patch-sql_pgq_triggers_common.c (nonexistent) +++ head/databases/skytools/files/patch-sql_pgq_triggers_common.c (revision 509208) @@ -0,0 +1,62 @@ +--- 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; Property changes on: head/databases/skytools/files/patch-sql_pgq_triggers_common.c ___________________________________________________________________ Added: fbsd:nokeywords ## -0,0 +1 ## +yes \ No newline at end of property Added: svn:eol-style ## -0,0 +1 ## +native \ No newline at end of property Added: svn:mime-type ## -0,0 +1 ## +text/plain \ No newline at end of property Index: head/databases/skytools/files/patch-sql_pgq_triggers_logutriga.c =================================================================== --- head/databases/skytools/files/patch-sql_pgq_triggers_logutriga.c (nonexistent) +++ head/databases/skytools/files/patch-sql_pgq_triggers_logutriga.c (revision 509208) @@ -0,0 +1,26 @@ +--- 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++; Property changes on: head/databases/skytools/files/patch-sql_pgq_triggers_logutriga.c ___________________________________________________________________ Added: fbsd:nokeywords ## -0,0 +1 ## +yes \ No newline at end of property Added: svn:eol-style ## -0,0 +1 ## +native \ No newline at end of property Added: svn:mime-type ## -0,0 +1 ## +text/plain \ No newline at end of property Index: head/databases/skytools/files/patch-sql_pgq_triggers_makesql.c =================================================================== --- head/databases/skytools/files/patch-sql_pgq_triggers_makesql.c (nonexistent) +++ head/databases/skytools/files/patch-sql_pgq_triggers_makesql.c (revision 509208) @@ -0,0 +1,86 @@ +--- 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++; + } Property changes on: head/databases/skytools/files/patch-sql_pgq_triggers_makesql.c ___________________________________________________________________ Added: fbsd:nokeywords ## -0,0 +1 ## +yes \ No newline at end of property Added: svn:eol-style ## -0,0 +1 ## +native \ No newline at end of property Added: svn:mime-type ## -0,0 +1 ## +text/plain \ No newline at end of property Index: head/databases/skytools/files/patch-sql_pgq_triggers_stringutil.c =================================================================== --- head/databases/skytools/files/patch-sql_pgq_triggers_stringutil.c (nonexistent) +++ head/databases/skytools/files/patch-sql_pgq_triggers_stringutil.c (revision 509208) @@ -0,0 +1,14 @@ +--- sql/pgq/triggers/stringutil.c.orig 2019-08-05 04:48:30 UTC ++++ sql/pgq/triggers/stringutil.c +@@ -19,7 +19,11 @@ + #include + #include + #include ++#if PG_VERSION_NUM < 110000 + #include ++#else ++#include ++#endif + #include + + #include "stringutil.h" Property changes on: head/databases/skytools/files/patch-sql_pgq_triggers_stringutil.c ___________________________________________________________________ Added: fbsd:nokeywords ## -0,0 +1 ## +yes \ No newline at end of property Added: svn:eol-style ## -0,0 +1 ## +native \ No newline at end of property Added: svn:mime-type ## -0,0 +1 ## +text/plain \ No newline at end of property Index: head/databases/skytools/files/patch-sql_txid_Makefile =================================================================== --- head/databases/skytools/files/patch-sql_txid_Makefile (nonexistent) +++ head/databases/skytools/files/patch-sql_txid_Makefile (revision 509208) @@ -0,0 +1,11 @@ +--- 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 Property changes on: head/databases/skytools/files/patch-sql_txid_Makefile ___________________________________________________________________ Added: fbsd:nokeywords ## -0,0 +1 ## +yes \ No newline at end of property Added: svn:eol-style ## -0,0 +1 ## +native \ No newline at end of property Added: svn:mime-type ## -0,0 +1 ## +text/plain \ No newline at end of property