Update to 1.7.0

- Use PGSQL_VER_NODOT
- Add LICENSE_FILE
- Update pkg-descr
- Take maintainership

Changes:	https://github.com/okbob/plpgsql_check/releases

4 files changed, 28 insertions, 27 deletions

diff --git a/databases/plpgsql_check/Makefile b/databases/plpgsql_check/Makefile
index 4f5cd307a4a6..dc60b3e0549a 100644
--- a/databases/plpgsql_check/Makefile
+++ b/databases/plpgsql_check/Makefile
@@ -2,33 +2,27 @@
 # $FreeBSD$
 
 PORTNAME=	plpgsql_check
-PORTVERSION=	1.2.0
+PORTVERSION=	1.7.0
 DISTVERSIONPREFIX=	v
-PORTREVISION=	2
 CATEGORIES=	databases
-PKGNAMEPREFIX=	postgresql${PGSQL_VER:S/.//}-
+PKGNAMEPREFIX=	postgresql${PGSQL_VER_NODOT}-
 
-MAINTAINER=	ports@FreeBSD.org
+MAINTAINER=	sunpoet@FreeBSD.org
 COMMENT=	PostgreSQL extension to check PL/pgSQL code
 
 LICENSE=	UNKNOWN
 LICENSE_NAME=	postcardware
-LICENSE_TEXT=	If you like it - send a postcard to address: \
-			Pavel Stehule \
-			Skalice 12 \
-			Benesov u Prahy \
-			256 01 \
-			Czech Republic \
-		Use this code freely on own risk
+LICENSE_FILE=	${WRKSRC}/LICENSE
 LICENSE_PERMS=	dist-mirror pkg-mirror dist-sell pkg-sell auto-accept
 
-USES=		gmake pgsql:9.2+
+USES=		gmake pgsql
+
 LLD_UNSAFE=	yes
+WANT_PGSQL=	server
+
 USE_GITHUB=	yes
 GH_ACCOUNT=	okbob
 
-WANT_PGSQL=	server
-
 post-install:
 	${STRIP_CMD} ${STAGEDIR}${PREFIX}/lib/postgresql/plpgsql_check.so
 
diff --git a/databases/plpgsql_check/distinfo b/databases/plpgsql_check/distinfo
index 63d64ed1eb27..7619a92a7419 100644
--- a/databases/plpgsql_check/distinfo
+++ b/databases/plpgsql_check/distinfo
@@ -1,3 +1,3 @@
-TIMESTAMP = 1496223426
-SHA256 (okbob-plpgsql_check-v1.2.0_GH0.tar.gz) = 370be67e557e91936f05c3697629ce45f1a7855d668359dc147d7fbf125dfcf5
-SIZE (okbob-plpgsql_check-v1.2.0_GH0.tar.gz) = 62269
+TIMESTAMP = 1555592218
+SHA256 (okbob-plpgsql_check-v1.7.0_GH0.tar.gz) = 191004174ec25dc06937fa1c92f4bd8762fe9a3e96ef7acfabd169482d36b4ab
+SIZE (okbob-plpgsql_check-v1.7.0_GH0.tar.gz) = 154818
diff --git a/databases/plpgsql_check/pkg-descr b/databases/plpgsql_check/pkg-descr
index bd28ddfbee08..52181a5ebc4a 100644
--- a/databases/plpgsql_check/pkg-descr
+++ b/databases/plpgsql_check/pkg-descr
@@ -1,7 +1,18 @@
-Plpgsql_check is next generation of plpgsql_lint. It allows to check source
-code by explicit call plpgsql_check_function. The SQL statements inside
-PL/pgSQL functions are checked by validator for semantic errors. These errors
-can be found by plpgsql_check_function. PostgreSQL 9.2 is required, PostgreSQL
-9.3, 9.4, 9.5, 9.6 and 10 are supported.
+plpgsql_check is next generation of plpgsql_lint. It allows to check source code
+by explicit call plpgsql_check_function. PostgreSQL 9.4, 9.5, 9.6, 10, 11 are
+supported (Develop 12 is supported too). The SQL statements inside PL/pgSQL
+functions are checked by validator for semantic errors. These errors can be
+found by plpgsql_check_function.
+
+Features:
+- check fields of referenced database objects and types inside embedded SQL
+- using correct types of function parameters
+- unused variables and function argumens, unmodified OUT argumens
+- partially detection of dead code (due RETURN command)
+- detection of missing RETURN command in function
+- try to identify unwanted hidden casts, that can be performance issue like
+  unused indexes
+- possibility to collect relations and functions used by function
+- possibility to check EXECUTE stmt agaist SQL injection vulnerability
 
 WWW: https://github.com/okbob/plpgsql_check
diff --git a/databases/plpgsql_check/pkg-plist b/databases/plpgsql_check/pkg-plist
index 87ecece9a70d..4cb00e864354 100644
--- a/databases/plpgsql_check/pkg-plist
+++ b/databases/plpgsql_check/pkg-plist
@@ -1,7 +1,3 @@
 lib/postgresql/plpgsql_check.so
-share/postgresql/extension/plpgsql_check--1.0--1.1.sql
-share/postgresql/extension/plpgsql_check--1.0.sql
-share/postgresql/extension/plpgsql_check--1.1--1.2.sql
-share/postgresql/extension/plpgsql_check--1.1.sql
-share/postgresql/extension/plpgsql_check--1.2.sql
+share/postgresql/extension/plpgsql_check--1.7.sql
 share/postgresql/extension/plpgsql_check.control