From owner-svn-ports-all@freebsd.org Fri Dec 14 19:39:41 2018 Return-Path: Delivered-To: svn-ports-all@mailman.ysv.freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2610:1c1:1:606c::19:1]) by mailman.ysv.freebsd.org (Postfix) with ESMTP id 0B8B4130B00A; Fri, 14 Dec 2018 19:39:41 +0000 (UTC) (envelope-from dbn@FreeBSD.org) Received: from mxrelay.nyi.freebsd.org (mxrelay.nyi.freebsd.org [IPv6:2610:1c1:1:606c::19:3]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits) server-signature RSA-PSS (4096 bits) client-signature RSA-PSS (4096 bits) client-digest SHA256) (Client CN "mxrelay.nyi.freebsd.org", Issuer "Let's Encrypt Authority X3" (verified OK)) by mx1.freebsd.org (Postfix) with ESMTPS id A56A18DE80; Fri, 14 Dec 2018 19:39:40 +0000 (UTC) (envelope-from dbn@FreeBSD.org) Received: from repo.freebsd.org (repo.freebsd.org [IPv6:2610:1c1:1:6068::e6a:0]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (Client did not present a certificate) by mxrelay.nyi.freebsd.org (Postfix) with ESMTPS id 976A74278; Fri, 14 Dec 2018 19:39:40 +0000 (UTC) (envelope-from dbn@FreeBSD.org) Received: from repo.freebsd.org ([127.0.1.37]) by repo.freebsd.org (8.15.2/8.15.2) with ESMTP id wBEJdeiV055317; Fri, 14 Dec 2018 19:39:40 GMT (envelope-from dbn@FreeBSD.org) Received: (from dbn@localhost) by repo.freebsd.org (8.15.2/8.15.2/Submit) id wBEJddfW055311; Fri, 14 Dec 2018 19:39:39 GMT (envelope-from dbn@FreeBSD.org) Message-Id: <201812141939.wBEJddfW055311@repo.freebsd.org> X-Authentication-Warning: repo.freebsd.org: dbn set sender to dbn@FreeBSD.org using -f From: David Naylor Date: Fri, 14 Dec 2018 19:39:39 +0000 (UTC) To: ports-committers@freebsd.org, svn-ports-all@freebsd.org, svn-ports-head@freebsd.org Subject: svn commit: r487459 - in head/databases: . postgresql-prefix postgresql-prefix/files X-SVN-Group: ports-head X-SVN-Commit-Author: dbn X-SVN-Commit-Paths: in head/databases: . postgresql-prefix postgresql-prefix/files X-SVN-Commit-Revision: 487459 X-SVN-Commit-Repository: ports MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit X-Rspamd-Queue-Id: A56A18DE80 X-Spamd-Bar: -- Authentication-Results: mx1.freebsd.org X-Spamd-Result: default: False [-2.85 / 15.00]; local_wl_from(0.00)[FreeBSD.org]; NEURAL_HAM_MEDIUM(-0.99)[-0.990,0]; NEURAL_HAM_LONG(-0.88)[-0.881,0]; NEURAL_HAM_SHORT(-0.98)[-0.982,0]; ASN(0.00)[asn:11403, ipnet:2610:1c1:1::/48, country:US] X-BeenThere: svn-ports-all@freebsd.org X-Mailman-Version: 2.1.29 Precedence: list List-Id: SVN commit messages for the ports tree List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Fri, 14 Dec 2018 19:39:41 -0000 Author: dbn Date: Fri Dec 14 19:39:38 2018 New Revision: 487459 URL: https://svnweb.freebsd.org/changeset/ports/487459 Log: databases/portsgresql-prefix: Prefix Range module for PostgreSQL Added: head/databases/postgresql-prefix/ head/databases/postgresql-prefix/Makefile (contents, props changed) head/databases/postgresql-prefix/distinfo (contents, props changed) head/databases/postgresql-prefix/files/ head/databases/postgresql-prefix/files/patch-Makefile (contents, props changed) head/databases/postgresql-prefix/pkg-descr (contents, props changed) head/databases/postgresql-prefix/pkg-plist (contents, props changed) Modified: head/databases/Makefile Modified: head/databases/Makefile ============================================================================== --- head/databases/Makefile Fri Dec 14 18:57:45 2018 (r487458) +++ head/databases/Makefile Fri Dec 14 19:39:38 2018 (r487459) @@ -710,6 +710,7 @@ SUBDIR += postgresql-plproxy SUBDIR += postgresql-plruby SUBDIR += postgresql-plv8js + SUBDIR += postgresql-prefix SUBDIR += postgresql-relay SUBDIR += postgresql-repmgr SUBDIR += postgresql-tds_fdw Added: head/databases/postgresql-prefix/Makefile ============================================================================== --- /dev/null 00:00:00 1970 (empty, because file is newly added) +++ head/databases/postgresql-prefix/Makefile Fri Dec 14 19:39:38 2018 (r487459) @@ -0,0 +1,28 @@ +# $FreeBSD$ + +PORTNAME= prefix +PORTVERSION= 1.2.8 +DISTVERSIONPREFIX= v +CATEGORIES= databases +PKGNAMEPREFIX= postgresql${PGSQL_VER:S/.//}- + +MAINTAINER= lbartoletti@tuxfamily.org +COMMENT= Prefix Range module for PostgreSQL + +LICENSE= PostgreSQL + +USES= gmake pgsql:9.1+ +WANT_PGSQL= server +USE_GITHUB= yes +GH_ACCOUNT= dimitri + +OPTIONS_DEFINE= DOCS + +post-install: + ${STRIP_CMD} ${STAGEDIR}${PREFIX}/lib/postgresql/prefix.so + +post-install-DOCS-on: + @${MKDIR} ${STAGEDIR}${DOCSDIR} + (cd ${WRKSRC} ; ${INSTALL_DATA} README.md TESTS.md ${STAGEDIR}${DOCSDIR}) + +.include Added: head/databases/postgresql-prefix/distinfo ============================================================================== --- /dev/null 00:00:00 1970 (empty, because file is newly added) +++ head/databases/postgresql-prefix/distinfo Fri Dec 14 19:39:38 2018 (r487459) @@ -0,0 +1,3 @@ +TIMESTAMP = 1537990947 +SHA256 (dimitri-prefix-v1.2.8_GH0.tar.gz) = db568a543cddfd5542e6e34c9ed804d842151667897b13657ca9954bf2fe115c +SIZE (dimitri-prefix-v1.2.8_GH0.tar.gz) = 74974 Added: head/databases/postgresql-prefix/files/patch-Makefile ============================================================================== --- /dev/null 00:00:00 1970 (empty, because file is newly added) +++ head/databases/postgresql-prefix/files/patch-Makefile Fri Dec 14 19:39:38 2018 (r487459) @@ -0,0 +1,10 @@ +--- Makefile.orig 2018-09-26 20:01:05 UTC ++++ Makefile +@@ -2,7 +2,6 @@ PKGNAME = prefix + EXTENSION = prefix + MODULES = prefix + DATA = prefix--1.2.0.sql prefix--unpackaged--1.2.0.sql prefix--1.1--1.2.0.sql +-DOCS = $(wildcard *.md) + # "explain (costs off)" needs 9.0+ (and 9.0 needs expected/explain_1.out) + EXPLAINSQL = $(shell $(PG_CONFIG) --version | grep -qE " 8\." || echo explain) + REGRESS = create_extension prefix falcon $(EXPLAINSQL) queries Added: head/databases/postgresql-prefix/pkg-descr ============================================================================== --- /dev/null 00:00:00 1970 (empty, because file is newly added) +++ head/databases/postgresql-prefix/pkg-descr Fri Dec 14 19:39:38 2018 (r487459) @@ -0,0 +1,13 @@ +Prefix matching is both very common and important in telephony applications, +where call routing and costs depend on matching caller/callee phone number +to an operator prefix. + +Let's say the prefixes table is called prefixes, a typical query will try to +match a phone number to the longest prefix in the table: + +SELECT * + FROM prefixes + WHERE prefix @> '0123456789' +ORDER BY length(prefix) DESC LIMIT 1; + +WWW: https://github.com/dimitri/prefix Added: head/databases/postgresql-prefix/pkg-plist ============================================================================== --- /dev/null 00:00:00 1970 (empty, because file is newly added) +++ head/databases/postgresql-prefix/pkg-plist Fri Dec 14 19:39:38 2018 (r487459) @@ -0,0 +1,7 @@ +lib/postgresql/prefix.so +%%PORTDOCS%%%%DOCSDIR%%/README.md +%%PORTDOCS%%%%DOCSDIR%%/TESTS.md +share/postgresql/extension/prefix--1.1--1.2.0.sql +share/postgresql/extension/prefix--1.2.0.sql +share/postgresql/extension/prefix--unpackaged--1.2.0.sql +share/postgresql/extension/prefix.control