Index: head/databases/plpgsql_check/Makefile
===================================================================
--- head/databases/plpgsql_check/Makefile	(revision 499284)
+++ head/databases/plpgsql_check/Makefile	(revision 499285)
@@ -1,35 +1,29 @@
 # Created by: Jov <amutu@amutu.com>
 # $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
 
 .include <bsd.port.mk>
Index: head/databases/plpgsql_check/distinfo
===================================================================
--- head/databases/plpgsql_check/distinfo	(revision 499284)
+++ head/databases/plpgsql_check/distinfo	(revision 499285)
@@ -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

Property changes on: head/databases/plpgsql_check/distinfo
___________________________________________________________________
Modified: fbsd:nokeywords
## -1 +1 ##
-on
\ No newline at end of property
+yes
\ No newline at end of property
Index: head/databases/plpgsql_check/pkg-descr
===================================================================
--- head/databases/plpgsql_check/pkg-descr	(revision 499284)
+++ head/databases/plpgsql_check/pkg-descr	(revision 499285)
@@ -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

Property changes on: head/databases/plpgsql_check/pkg-descr
___________________________________________________________________
Modified: fbsd:nokeywords
## -1 +1 ##
-on
\ No newline at end of property
+yes
\ No newline at end of property
Index: head/databases/plpgsql_check/pkg-plist
===================================================================
--- head/databases/plpgsql_check/pkg-plist	(revision 499284)
+++ head/databases/plpgsql_check/pkg-plist	(revision 499285)
@@ -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

Property changes on: head/databases/plpgsql_check/pkg-plist
___________________________________________________________________
Modified: fbsd:nokeywords
## -1 +1 ##
-on
\ No newline at end of property
+yes
\ No newline at end of property