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
|
