Package: postgresql-17-plpgsql-check Source: plpgsql-check Version: 2.10.16-1.pgdg22.04+2 Architecture: amd64 Maintainer: Debian PostgreSQL Maintainers Installed-Size: 889 Depends: postgresql-17 (>> 17.12), libc6 (>= 2.17) Breaks: postgresql-17-jit-llvm (<< 15) Homepage: https://github.com/okbob/plpgsql_check Priority: optional Section: database Filename: pool/main/p/plpgsql-check/postgresql-17-plpgsql-check_2.10.16-1.pgdg22.04+2_amd64.deb Size: 428072 SHA512: cca59f7507fc0585051158cad9519d5c91d6dfea16ca9529c999b4abb71bcdcb966ae3022b6453004f4afdcf2f31c8758c4887e19c8d6b90c140466af4df90a1 SHA256: 280365ee7bf57ba781ccb14641c542330fe6100036eed8ae00f9a884a8069cb8 SHA1: dd14b9885e7c286170eecd0650528adb6fd04fa5 MD5sum: caecfa0970dfce27ca513a0c5bf21dd5 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