Download Browse

plpgsql_check 2.8.0

This Release
plpgsql_check 2.8.0
Date
Status
Stable
Other Releases
Abstract
Additional tools for plpgsql functions validation
Description
The plpgsql_check is PostgreSQL extension with functionality for direct or indirect extra validation of functions in plpgsql language. It verifies a validity of SQL identifiers used in plpgsql code. It try to identify a performance issues. Modern versions has integrated profiler. The table and function dependencies can be displayed
Released By
okbob
License
BSD
Resources
Special Files
Tags

Extensions

plpgsql_check 2.8.0
Additional tools for plpgsql functions validation

Documentation

custom_scan_function
custom_scan_function
TODO
TODO

README

Contents

Build on Microsoft Windows with Microsoft Visual Studio and meson

1. Install
   - Microsft Visual Studio with C and C++ support
   - Meson
   - PostgreSQL

2. Run x64 Native Tools Command Prompt for VS 20xx (*** ensure x64 ***)

3. Set PATH

   set PATH=%PATH%;C:\Program Files\PostgreSQL\16\bin;C:\Program Files\Meson

4. execute in plpgsql_check source directory (buildtype should be release or plain,
   attention - the release buildtype inject dependency on vc_redist.x64.exe)

   meson setup --wipe --buildtype release plain
   cd build
   ninja
   sudo ninja install (on linux)
   ninja test (on linux)
   # ninja bindist

5. tests on MSWIN requires installation DiffUtils from gnuwin32

   set PATH=%PATH%;C:\Program Files (x86)\GnuWin32\bin
   set PGPORT=
   set PGUSER=
   set PGPASSWORD=
   ninja test