plpgsql_check
plpgsql_check copied to clipboard
plpgsql_check is a linter tool (does source code static analyze) for the PostgreSQL language plpgsql (the native language for PostgreSQL store procedures).
plpgsql_check version 2.7 PostgreSQL 16.2 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 11.4.1 20230605 (Red Hat 11.4.1-2), 64-bit In case temporary table is created inside the fucntion we check, it generates...
Hello! After building postgres in the following way: `./configure --enable-tap-tests --enable-debug --enable-cassert && make -j8` And executing the query: ``` set plpgsql_check.profiler to on; create function f1() returns void as...
Having used this code for years. Here is my second attempt to give back. The message: Detail: cast "integer" value to "bigint" type now indicates the variable, if available: Detail:...
**Context**: I have a stored procedure that performs an insert on a table. I added two new non-nullable columns to that table. I ran the plpgsql_check after adding those columns...