plpgsql_check

Overview

PGDG 1st Party Extension: plpgsql_check : extended check for plpgsql functions

Information

• Extension ID: 3060
• Extension Name: plpgsql_check
• Package Name: plpgsql_check
• Category: LANG
• License: MIT
• Website: https://github.com/okbob/plpgsql_check
• Language: C
• Extra Tags: N/A
• Comment: N/A

Metadata

• Latest Version: 2.7
• Postgres Support: 17,16,15,14,13
• Need Load: Explicit Loading Required
• Need DDL: Need CREATE EXTENSION DDL
• Relocatable: Can be installed into other schemas
• Trusted: Untrusted, Require Superuser to Create
• Schemas: N/A
• Requires: plpgsql

RPM / DEB

• RPM Repo: PGDG
• RPM Name: plpgsql_check_$v*
• RPM Ver : 2.7
• RPM Deps: N/A
• DEB Repo: PGDG
• DEB Name: postgresql-$v-plpgsql-check
• DEB Ver : 2.7
• DEB Deps: N/A

Packages

Installation

Install plpgsql_check via the pig CLI tool:

pig ext install plpgsql_check

Install plpgsql_check via Pigsty playbook:

./pgsql.yml -t pg_extension -e '{"pg_extensions": ["plpgsql_check"]}' # -l <cls>

Install plpgsql_check RPM from YUM repo directly:

dnf install plpgsql_check_17*;
dnf install plpgsql_check_16*;
dnf install plpgsql_check_15*;
dnf install plpgsql_check_14*;
dnf install plpgsql_check_13*;

Install plpgsql_check DEB from APT repo directly:

apt install postgresql-17-plpgsql-check;
apt install postgresql-16-plpgsql-check;
apt install postgresql-15-plpgsql-check;
apt install postgresql-14-plpgsql-check;
apt install postgresql-13-plpgsql-check;

Extension plpgsql_check has to be added to shared_preload_libraries

shared_preload_libraries = 'plpgsql_check'; # add to pg cluster config

Enable plpgsql_check extension on PostgreSQL cluster：

CREATE EXTENSION plpgsql_check CASCADE;