Package: postgresql-15-plpgsql-check Source: plpgsql-check Version: 2.9.0-1.pgdg22.04+1 Architecture: amd64 Maintainer: Debian PostgreSQL Maintainers Installed-Size: 826 Depends: postgresql-15, libc6 (>= 2.17) Breaks: postgresql-15-jit-llvm (<< 15) Homepage: https://github.com/okbob/plpgsql_check Priority: optional Section: database Filename: pool/main/p/plpgsql-check/postgresql-15-plpgsql-check_2.9.0-1.pgdg22.04+1_amd64.deb Size: 388156 SHA512: 5f16850d2ed5f171ec2d1f3ba0071f23fcca87a674cf5cb3da951b61a9cd9572cd3cd8e5611471ddbf492f655cc470780612a15b6dfbba8f8496cd3640a3ccfe SHA256: 92b7e73032000965b0565c03c7a407e15c33cde90d60e8de145f62691d86a2ce SHA1: 2bf281eff70b4dee5f7c6c664b5a073ec63605c6 MD5sum: fc81cc371e6b380dd16c49ac05770941 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