Package: postgresql-17-plpgsql-check
Source: plpgsql-check
Version: 2.8.1-1.pgdg20.04+2
Architecture: amd64
Maintainer: Debian PostgreSQL Maintainers <team+postgresql@tracker.debian.org>
Installed-Size: 801
Depends: postgresql-17, postgresql-17-jit-llvm (>= 10), libc6 (>= 2.17)
Homepage: https://github.com/okbob/plpgsql_check
Priority: optional
Section: database
Filename: pool/main/p/plpgsql-check/postgresql-17-plpgsql-check_2.8.1-1.pgdg20.04+2_amd64.deb
Size: 373692
SHA256: 06458876047d86882e20072ec4f251900d1dfab824ee6385d4dd5068639261f9
SHA1: 08cdf444a53afdfaaa417c91dcb7d1f2590be1b8
MD5sum: a188791ffff7ceca13c66b7ac105a715
Description: plpgsql_check extension for PostgreSQL
plpgsql_check is the next generation of plpgsql_lint for PL/pgsql source code.
The SQL statements inside PL/pgSQL functions are checked for semantic errors.
.
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 against SQL injection vulnerability