1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39
|
Source: plpgsql-check
Section: database
Priority: optional
Maintainer: Debian PostgreSQL Maintainers <team+postgresql@tracker.debian.org>
Uploaders:
Stefan Hühner <stefan.huehner@openbravo.com>,
Christoph Berg <myon@debian.org>,
Build-Depends:
architecture-is-64-bit <!pkg.postgresql.32-bit>,
debhelper-compat (= 13),
libicu-dev,
postgresql-all <!nocheck>,
postgresql-server-dev-all,
Standards-Version: 4.7.0
Rules-Requires-Root: no
Homepage: https://github.com/okbob/plpgsql_check
Vcs-Browser: https://salsa.debian.org/postgresql/plpgsql-check
Vcs-Git: https://salsa.debian.org/postgresql/plpgsql-check.git
Package: postgresql-17-plpgsql-check
Architecture: any
Depends:
${misc:Depends},
${postgresql:Depends},
${shlibs:Depends},
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
|