From owner-svn-ports-all@freebsd.org Sun Jul 28 16:13:29 2019 Return-Path: Delivered-To: svn-ports-all@mailman.nyi.freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2610:1c1:1:606c::19:1]) by mailman.nyi.freebsd.org (Postfix) with ESMTP id B1719AEC50; Sun, 28 Jul 2019 16:13:29 +0000 (UTC) (envelope-from kai@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 8E9FC6C460; Sun, 28 Jul 2019 16:13:29 +0000 (UTC) (envelope-from kai@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 586FF1A49D; Sun, 28 Jul 2019 16:13:29 +0000 (UTC) (envelope-from kai@FreeBSD.org) Received: from repo.freebsd.org ([127.0.1.37]) by repo.freebsd.org (8.15.2/8.15.2) with ESMTP id x6SGDTVV086217; Sun, 28 Jul 2019 16:13:29 GMT (envelope-from kai@FreeBSD.org) Received: (from kai@localhost) by repo.freebsd.org (8.15.2/8.15.2/Submit) id x6SGDS3P086214; Sun, 28 Jul 2019 16:13:28 GMT (envelope-from kai@FreeBSD.org) Message-Id: <201907281613.x6SGDS3P086214@repo.freebsd.org> X-Authentication-Warning: repo.freebsd.org: kai set sender to kai@FreeBSD.org using -f From: Kai Knoblich Date: Sun, 28 Jul 2019 16:13:28 +0000 (UTC) To: ports-committers@freebsd.org, svn-ports-all@freebsd.org, svn-ports-head@freebsd.org Subject: svn commit: r507514 - head/databases/postgresql-prefix X-SVN-Group: ports-head X-SVN-Commit-Author: kai X-SVN-Commit-Paths: head/databases/postgresql-prefix X-SVN-Commit-Revision: 507514 X-SVN-Commit-Repository: ports MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit X-Rspamd-Queue-Id: 8E9FC6C460 X-Spamd-Bar: -- Authentication-Results: mx1.freebsd.org X-Spamd-Result: default: False [-2.96 / 15.00]; local_wl_from(0.00)[FreeBSD.org]; NEURAL_HAM_MEDIUM(-0.99)[-0.991,0]; NEURAL_HAM_SHORT(-0.97)[-0.966,0]; NEURAL_HAM_LONG(-1.00)[-1.000,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: Sun, 28 Jul 2019 16:13:29 -0000 Author: kai Date: Sun Jul 28 16:13:28 2019 New Revision: 507514 URL: https://svnweb.freebsd.org/changeset/ports/507514 Log: databases/postgresql-prefix: Update to 1.2.9 * Pet portlint by fixing whitespace issues in pkg-plist while I'm here. Changelog: * Add support for PostgreSQL 12 PR: 239452 Submitted by: lbartoletti (maintainer) Modified: head/databases/postgresql-prefix/Makefile head/databases/postgresql-prefix/distinfo head/databases/postgresql-prefix/pkg-descr Modified: head/databases/postgresql-prefix/Makefile ============================================================================== --- head/databases/postgresql-prefix/Makefile Sun Jul 28 16:06:01 2019 (r507513) +++ head/databases/postgresql-prefix/Makefile Sun Jul 28 16:13:28 2019 (r507514) @@ -1,8 +1,7 @@ # $FreeBSD$ PORTNAME= prefix -PORTVERSION= 1.2.8 -PORTREVISION= 1 +PORTVERSION= 1.2.9 DISTVERSIONPREFIX= v CATEGORIES= databases PKGNAMEPREFIX= postgresql${PGSQL_VER:S/.//}- Modified: head/databases/postgresql-prefix/distinfo ============================================================================== --- head/databases/postgresql-prefix/distinfo Sun Jul 28 16:06:01 2019 (r507513) +++ head/databases/postgresql-prefix/distinfo Sun Jul 28 16:13:28 2019 (r507514) @@ -1,3 +1,3 @@ -TIMESTAMP = 1537990947 -SHA256 (dimitri-prefix-v1.2.8_GH0.tar.gz) = db568a543cddfd5542e6e34c9ed804d842151667897b13657ca9954bf2fe115c -SIZE (dimitri-prefix-v1.2.8_GH0.tar.gz) = 74974 +TIMESTAMP = 1563903139 +SHA256 (dimitri-prefix-v1.2.9_GH0.tar.gz) = 38d30a08d0241a8bbb8e1eb8f0152b385051665a8e621c8899e7c5068f8b511e +SIZE (dimitri-prefix-v1.2.9_GH0.tar.gz) = 75147 Modified: head/databases/postgresql-prefix/pkg-descr ============================================================================== --- head/databases/postgresql-prefix/pkg-descr Sun Jul 28 16:06:01 2019 (r507513) +++ head/databases/postgresql-prefix/pkg-descr Sun Jul 28 16:13:28 2019 (r507514) @@ -1,11 +1,11 @@ Prefix matching is both very common and important in telephony applications, -where call routing and costs depend on matching caller/callee phone number +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 * +SELECT * FROM prefixes WHERE prefix @> '0123456789' ORDER BY length(prefix) DESC LIMIT 1;