Port details on branch 2022Q3 |
- plpgsql_check PostgreSQL extension to check PL/pgSQL code
- 2.7.5 databases =0 2.7.3Version of this port present on the latest quarterly branch.
- Maintainer: sunpoet@FreeBSD.org
- Port Added: 2017-07-05 09:24:22
- Last Update: 2024-04-05 00:38:30
- Commit Hash: aa7b604
- License: UNKNOWN
- WWW:
- https://github.com/okbob/plpgsql_check
- Description:
- 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
- ¦ ¦ ¦ ¦
- Manual pages:
- FreshPorts has no man page information for this port.
- pkg-plist: as obtained via:
make generate-plist - Dependency lines:
-
- postgresql15-plpgsql_check>0:databases/plpgsql_check
- To install the port:
- cd /usr/ports/databases/plpgsql_check/ && make install clean
- To add the package, run one of these commands:
- pkg install databases/plpgsql_check
- pkg install postgresql15-plpgsql_check
NOTE: If this package has multiple flavors (see below), then use one of them instead of the name specified above.- PKGNAME: postgresql15-plpgsql_check
- Flavors: there is no flavor information for this port.
- distinfo:
- TIMESTAMP = 1712084456
SHA256 (okbob-plpgsql_check-v2.7.5_GH0.tar.gz) = d067772c6a060702424aadb3d8adbbe513cfb41c839ed2cac52bced99c73b963
SIZE (okbob-plpgsql_check-v2.7.5_GH0.tar.gz) = 254593
Packages (timestamps in pop-ups are UTC):
- Dependencies
- NOTE: FreshPorts displays only information on required and default dependencies. Optional dependencies are not covered.
- Build dependencies:
-
- gmake>=4.4.1 : devel/gmake
- postgres : databases/postgresql15-server
- as : devel/binutils
- Runtime dependencies:
-
- postgres : databases/postgresql15-server
- There are no ports dependent upon this port
Configuration Options:
- No options to configure
- Options name:
- databases_plpgsql_check
- USES:
- compiler:c11 gmake pgsql:12+
- FreshPorts was unable to extract/find any pkg message
- Master Sites:
|