notbugAs an Amazon Associate I earn from qualifying purchases.
Want a good read? Try FreeBSD Mastery: Jails (IT Mastery Book 15)Want a good monitor light? See my photosAll times are UTC		 Ukraine
Port details
plpgsql_check PostgreSQL extension to check PL/pgSQL code
2.7.15 databases on this many watch lists=2 search for ports that depend on this port Find issues related to this port Report an issue related to this port View this port on Repology. pkg-fallout 2.7.12Version of this port present on the latest quarterly branch.
Maintainer: sunpoet@FreeBSD.org search for ports maintained by this maintainer
Port Added: 2017-07-05 09:24:22
Last Update: 2025-02-17 08:11:32
Commit Hash: 141ca9b
People watching this port, also watch:: jdictionary, py311-Automat, py311-python-gdsii, py39-PyOpenGL, p5-Sane
License: UNKNOWN
WWW:
https://github.com/okbob/plpgsql_check
Description:
plpgsql_check is next generation of plpgsql_lint. It allows to check source code by explicit call plpgsql_check_function. PostgreSQL 9.4, 9.5, 9.6, 10, 11 are supported (Develop 12 is supported too). The SQL statements inside PL/pgSQL functions are checked by validator for semantic errors. These errors can be found by plpgsql_check_function. 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 agaist SQL injection vulnerability
Homepage    cgit ¦ Codeberg ¦ GitHub ¦ GitLab ¦ SVNWeb

Manual pages:
FreshPorts has no man page information for this port.
pkg-plist: as obtained via: make generate-plist
Expand this list (9 items)
Collapse this list.
  1. /usr/local/share/licenses/postgresql16-plpgsql_check-2.7.15/catalog.mk
  2. /usr/local/share/licenses/postgresql16-plpgsql_check-2.7.15/LICENSE
  3. /usr/local/share/licenses/postgresql16-plpgsql_check-2.7.15/UNKNOWN
  4. lib/postgresql/plpgsql_check.so
  5. share/postgresql/extension/plpgsql_check--2.7.sql
  6. share/postgresql/extension/plpgsql_check.control
  7. @owner
  8. @group
  9. @mode
Collapse this list.
Dependency lines:
  • postgresql16-plpgsql_check>0:databases/plpgsql_check
To install the port:
cd /usr/ports/databases/plpgsql_check/ && make install clean
To add the package, run one of these commands:
  • pkg install databases/plpgsql_check
  • pkg install postgresql16-plpgsql_check
NOTE: If this package has multiple flavors (see below), then use one of them instead of the name specified above.
PKGNAME: postgresql16-plpgsql_check
Flavors: there is no flavor information for this port.
distinfo:
TIMESTAMP = 1739116670 SHA256 (okbob-plpgsql_check-v2.7.15_GH0.tar.gz) = 1a16b957fa10dadd1abf3b17201eb702d3fc7fd466ff6ce04db2d6d6d38da442 SIZE (okbob-plpgsql_check-v2.7.15_GH0.tar.gz) = 295573
Packages (timestamps in pop-ups are UTC):
postgresql12-plpgsql_check
ABIaarch64amd64armv6armv7i386powerpcpowerpc64powerpc64le
FreeBSD:13:latest--1.15.1---1.15.1-
FreeBSD:13:quarterly--------
FreeBSD:14:latest--------
FreeBSD:14:quarterly--------
FreeBSD:15:latest--n/a-n/a---
 

postgresql13-plpgsql_check
ABIaarch64amd64armv6armv7i386powerpcpowerpc64powerpc64le
FreeBSD:13:latest--------
FreeBSD:13:quarterly--2.3.4-----
FreeBSD:14:latest--2.2.3--2.3.4-2.3.4
FreeBSD:14:quarterly--------
FreeBSD:15:latest--n/a-n/a---
 

postgresql15-plpgsql_check
ABIaarch64amd64armv6armv7i386powerpcpowerpc64powerpc64le
FreeBSD:13:latest--------
FreeBSD:13:quarterly-----2.7.12.7.12.7.1
FreeBSD:14:latest--------
FreeBSD:14:quarterly-----2.7.12.7.12.7.1
FreeBSD:15:latest--n/a-n/a2.7.12.7.12.7.2
 

postgresql16-plpgsql_check
ABIaarch64amd64armv6armv7i386powerpcpowerpc64powerpc64le
FreeBSD:13:latest2.7.152.7.15-2.7.152.7.15---
FreeBSD:13:quarterly2.7.132.7.13-2.7.132.7.13---
FreeBSD:14:latest2.7.152.7.15-2.7.152.7.15---
FreeBSD:14:quarterly2.7.132.7.13-2.7.132.7.13---
FreeBSD:15:latest2.7.152.7.15n/a2.7.15n/a---
 

Dependencies
NOTE: FreshPorts displays only information on required and default dependencies. Optional dependencies are not covered.
Build dependencies:
  1. gmake>=4.4.1 : devel/gmake
  2. postgres : databases/postgresql16-server
  3. as : devel/binutils
Runtime dependencies:
  1. postgres : databases/postgresql16-server
There are no ports dependent upon this port
Configuration Options:
No options to configure
Options name:
databases_plpgsql_check
USES:
compiler:c11 gmake pgsql
FreshPorts was unable to extract/find any pkg message
Master Sites:
Expand this list (1 items)
Collapse this list.
  1. https://codeload.github.com/okbob/plpgsql_check/tar.gz/v2.7.15?dummy=/
Collapse this list.

Number of commits found: 82

Commit History - (may be incomplete: for full details, see links to repositories near top of page)
CommitCreditsLog message
2.7.15
17 Feb 2025 08:11:32
commit hash: 141ca9ba1df0ab3badd0e88b713d3ce3fca396fdcommit hash: 141ca9ba1df0ab3badd0e88b713d3ce3fca396fdcommit hash: 141ca9ba1df0ab3badd0e88b713d3ce3fca396fdcommit hash: 141ca9ba1df0ab3badd0e88b713d3ce3fca396fd files touched by this commit		 Po-Chuan Hsieh (sunpoet) search for other commits by this committer 
databases/plpgsql_check: Update to 2.7.15

Changes:	https://github.com/okbob/plpgsql_check/releases
2.7.14
07 Feb 2025 21:15:50
commit hash: 02206ccb9afb9e56ea19ddcc61b4f9f6d63a8abdcommit hash: 02206ccb9afb9e56ea19ddcc61b4f9f6d63a8abdcommit hash: 02206ccb9afb9e56ea19ddcc61b4f9f6d63a8abdcommit hash: 02206ccb9afb9e56ea19ddcc61b4f9f6d63a8abd files touched by this commit		 Po-Chuan Hsieh (sunpoet) search for other commits by this committer 
databases/plpgsql_check: Update to 2.7.14

Changes:	https://github.com/okbob/plpgsql_check/releases
2.7.13
31 Dec 2024 15:42:26
commit hash: f813f03a47bdc37d7a8e5bc88b15b52530120865commit hash: f813f03a47bdc37d7a8e5bc88b15b52530120865commit hash: f813f03a47bdc37d7a8e5bc88b15b52530120865commit hash: f813f03a47bdc37d7a8e5bc88b15b52530120865 files touched by this commit		 Po-Chuan Hsieh (sunpoet) search for other commits by this committer 
databases/plpgsql_check: Update to 2.7.13

Changes:	https://github.com/okbob/plpgsql_check/releases
2.7.12
22 Oct 2024 21:58:17
commit hash: b3c63f2cde39b478f2510bb87bd187d6668f1a85commit hash: b3c63f2cde39b478f2510bb87bd187d6668f1a85commit hash: b3c63f2cde39b478f2510bb87bd187d6668f1a85commit hash: b3c63f2cde39b478f2510bb87bd187d6668f1a85 files touched by this commit		 Po-Chuan Hsieh (sunpoet) search for other commits by this committer 
databases/plpgsql_check: Update to 2.7.12

Changes:	https://github.com/okbob/plpgsql_check/releases
2.7.11
25 Sep 2024 04:22:25
commit hash: f40f50ef9f301267ef7298032075472aefe37a6acommit hash: f40f50ef9f301267ef7298032075472aefe37a6acommit hash: f40f50ef9f301267ef7298032075472aefe37a6acommit hash: f40f50ef9f301267ef7298032075472aefe37a6a files touched by this commit		 Po-Chuan Hsieh (sunpoet) search for other commits by this committer 
databases/plpgsql_check: Update to 2.7.11

Changes:	https://github.com/okbob/plpgsql_check/releases
2.7.9
08 Sep 2024 18:36:57
commit hash: 229153a81a7f0c851390dd0a1c49d992cb609a7acommit hash: 229153a81a7f0c851390dd0a1c49d992cb609a7acommit hash: 229153a81a7f0c851390dd0a1c49d992cb609a7acommit hash: 229153a81a7f0c851390dd0a1c49d992cb609a7a files touched by this commit		 Po-Chuan Hsieh (sunpoet) search for other commits by this committer 
databases/plpgsql_check: Update to 2.7.9

Changes:	https://github.com/okbob/plpgsql_check/releases
2.7.8
15 Aug 2024 10:55:25
commit hash: d7bd62cfd27c49ab56091a5e48d80bb032c761e4commit hash: d7bd62cfd27c49ab56091a5e48d80bb032c761e4commit hash: d7bd62cfd27c49ab56091a5e48d80bb032c761e4commit hash: d7bd62cfd27c49ab56091a5e48d80bb032c761e4 files touched by this commit		 Po-Chuan Hsieh (sunpoet) search for other commits by this committer 
databases/plpgsql_check: Update to 2.7.8

Changes:	https://github.com/okbob/plpgsql_check/releases
2.7.7
06 Jul 2024 16:01:38
commit hash: c00dc26b8eb1f026d8a6d84ed6eeaa4ea8b97cc1commit hash: c00dc26b8eb1f026d8a6d84ed6eeaa4ea8b97cc1commit hash: c00dc26b8eb1f026d8a6d84ed6eeaa4ea8b97cc1commit hash: c00dc26b8eb1f026d8a6d84ed6eeaa4ea8b97cc1 files touched by this commit		 Po-Chuan Hsieh (sunpoet) search for other commits by this committer 
databases/plpgsql_check: Update to 2.7.7

Changes:	https://github.com/okbob/plpgsql_check/releases
2.7.6
03 Jun 2024 02:37:25
commit hash: ef9741202e6d14fbcb5442498d3eb5d8e30812afcommit hash: ef9741202e6d14fbcb5442498d3eb5d8e30812afcommit hash: ef9741202e6d14fbcb5442498d3eb5d8e30812afcommit hash: ef9741202e6d14fbcb5442498d3eb5d8e30812af files touched by this commit		 Po-Chuan Hsieh (sunpoet) search for other commits by this committer 
databases/plpgsql_check: Update to 2.7.6

Changes:	https://github.com/okbob/plpgsql_check/releases
2.7.5
05 Apr 2024 00:38:30
commit hash: aa7b60470e959b3747b5f00a27450180d25d850fcommit hash: aa7b60470e959b3747b5f00a27450180d25d850fcommit hash: aa7b60470e959b3747b5f00a27450180d25d850fcommit hash: aa7b60470e959b3747b5f00a27450180d25d850f files touched by this commit		 Po-Chuan Hsieh (sunpoet) search for other commits by this committer 
databases/plpgsql_check: Update to 2.7.5

Changes:	https://github.com/okbob/plpgsql_check/releases
2.7.4
31 Mar 2024 03:05:36
commit hash: 84f8c25c1ce6db83dc97ed9b2bbdb18d65033f80commit hash: 84f8c25c1ce6db83dc97ed9b2bbdb18d65033f80commit hash: 84f8c25c1ce6db83dc97ed9b2bbdb18d65033f80commit hash: 84f8c25c1ce6db83dc97ed9b2bbdb18d65033f80 files touched by this commit		 Po-Chuan Hsieh (sunpoet) search for other commits by this committer 
databases/plpgsql_check: Update to 2.7.4

Changes:	https://github.com/okbob/plpgsql_check/releases
2.7.3
09 Mar 2024 14:05:17
commit hash: a55235a28286c73633b5501906a5de70eaff400dcommit hash: a55235a28286c73633b5501906a5de70eaff400dcommit hash: a55235a28286c73633b5501906a5de70eaff400dcommit hash: a55235a28286c73633b5501906a5de70eaff400d files touched by this commit		 Po-Chuan Hsieh (sunpoet) search for other commits by this committer 
databases/plpgsql_check: Update to 2.7.3

Changes:	https://github.com/okbob/plpgsql_check/releases
2.7.2
21 Feb 2024 15:06:17
commit hash: 1016469c4d98952b1d5731a0752dc29940652a78commit hash: 1016469c4d98952b1d5731a0752dc29940652a78commit hash: 1016469c4d98952b1d5731a0752dc29940652a78commit hash: 1016469c4d98952b1d5731a0752dc29940652a78 files touched by this commit		 Po-Chuan Hsieh (sunpoet) search for other commits by this committer 
databases/plpgsql_check: Update to 2.7.2

Changes:	https://github.com/okbob/plpgsql_check/releases
2.7.1
25 Dec 2023 08:59:18
commit hash: 045cbc3d514f4d50e12e784fa80b64cb5ddaad94commit hash: 045cbc3d514f4d50e12e784fa80b64cb5ddaad94commit hash: 045cbc3d514f4d50e12e784fa80b64cb5ddaad94commit hash: 045cbc3d514f4d50e12e784fa80b64cb5ddaad94 files touched by this commit		 Po-Chuan Hsieh (sunpoet) search for other commits by this committer 
databases/plpgsql_check: Update to 2.7.1

Changes:	https://github.com/okbob/plpgsql_check/releases
2.7.0
14 Dec 2023 05:35:31
commit hash: 5efe53f44c8a7a74c2ff86b89f13d83456d73273commit hash: 5efe53f44c8a7a74c2ff86b89f13d83456d73273commit hash: 5efe53f44c8a7a74c2ff86b89f13d83456d73273commit hash: 5efe53f44c8a7a74c2ff86b89f13d83456d73273 files touched by this commit		 Po-Chuan Hsieh (sunpoet) search for other commits by this committer 
databases/plpgsql_check: Update to 2.7.0

Changes:	https://github.com/okbob/plpgsql_check/releases
2.6.2
27 Nov 2023 18:07:48
commit hash: 2ab13da5cf9719af1ef89221c303e6720ba245dacommit hash: 2ab13da5cf9719af1ef89221c303e6720ba245dacommit hash: 2ab13da5cf9719af1ef89221c303e6720ba245dacommit hash: 2ab13da5cf9719af1ef89221c303e6720ba245da files touched by this commit		 Po-Chuan Hsieh (sunpoet) search for other commits by this committer 
databases/plpgsql_check: Update to 2.6.2

Changes:	https://github.com/okbob/plpgsql_check/releases
2.6.1
14 Nov 2023 17:15:31
commit hash: 7b88633528c3fc1f7baace8fac4ec5593a79ad69commit hash: 7b88633528c3fc1f7baace8fac4ec5593a79ad69commit hash: 7b88633528c3fc1f7baace8fac4ec5593a79ad69commit hash: 7b88633528c3fc1f7baace8fac4ec5593a79ad69 files touched by this commit		 Po-Chuan Hsieh (sunpoet) search for other commits by this committer 
databases/plpgsql_check: Update to 2.6.1

Changes:	https://github.com/okbob/plpgsql_check/releases
2.6.0
02 Nov 2023 07:37:18
commit hash: 9c065c125313516c579afeba8a82515768e557d7commit hash: 9c065c125313516c579afeba8a82515768e557d7commit hash: 9c065c125313516c579afeba8a82515768e557d7commit hash: 9c065c125313516c579afeba8a82515768e557d7 files touched by this commit		 Po-Chuan Hsieh (sunpoet) search for other commits by this committer 
databases/plpgsql_check: Update to 2.6.0

Changes:	https://github.com/okbob/plpgsql_check/releases
2.5.4
16 Oct 2023 15:59:41
commit hash: 38a4a8611e985dba8cd008267182217969fb8878commit hash: 38a4a8611e985dba8cd008267182217969fb8878commit hash: 38a4a8611e985dba8cd008267182217969fb8878commit hash: 38a4a8611e985dba8cd008267182217969fb8878 files touched by this commit		 Po-Chuan Hsieh (sunpoet) search for other commits by this committer 
databases/plpgsql_check: Update to 2.5.4

Changes:	https://github.com/okbob/plpgsql_check/releases
2.5.3
08 Oct 2023 11:54:07
commit hash: dcb53554ae515077d5a817be68718ea95b68ba39commit hash: dcb53554ae515077d5a817be68718ea95b68ba39commit hash: dcb53554ae515077d5a817be68718ea95b68ba39commit hash: dcb53554ae515077d5a817be68718ea95b68ba39 files touched by this commit		 Po-Chuan Hsieh (sunpoet) search for other commits by this committer 
databases/plpgsql_check: Update to 2.5.3

Changes:	https://github.com/okbob/plpgsql_check/releases
2.5.2
30 Sep 2023 23:29:50
commit hash: 8d331f1bfe8d9f9cc393f2ac5026ae06b2f4427dcommit hash: 8d331f1bfe8d9f9cc393f2ac5026ae06b2f4427dcommit hash: 8d331f1bfe8d9f9cc393f2ac5026ae06b2f4427dcommit hash: 8d331f1bfe8d9f9cc393f2ac5026ae06b2f4427d files touched by this commit		 Po-Chuan Hsieh (sunpoet) search for other commits by this committer 
databases/plpgsql_check: Update to 2.5.2

Changes:	https://github.com/okbob/plpgsql_check/releases
2.5.1
22 Sep 2023 03:16:53
commit hash: 2c6a9059d4cf6fc9c015359006d28c59b127097fcommit hash: 2c6a9059d4cf6fc9c015359006d28c59b127097fcommit hash: 2c6a9059d4cf6fc9c015359006d28c59b127097fcommit hash: 2c6a9059d4cf6fc9c015359006d28c59b127097f files touched by this commit		 Po-Chuan Hsieh (sunpoet) search for other commits by this committer 
databases/plpgsql_check: Update to 2.5.1

Changes:	https://github.com/okbob/plpgsql_check/releases
2.5.0
11 Sep 2023 03:07:38
commit hash: 75d0ff39c0ef0c56498ae551b741b836c37c9eb0commit hash: 75d0ff39c0ef0c56498ae551b741b836c37c9eb0commit hash: 75d0ff39c0ef0c56498ae551b741b836c37c9eb0commit hash: 75d0ff39c0ef0c56498ae551b741b836c37c9eb0 files touched by this commit		 Po-Chuan Hsieh (sunpoet) search for other commits by this committer 
databases/plpgsql_check: Update to 2.5.0

Changes:	https://github.com/okbob/plpgsql_check/releases
2.4.0
21 Aug 2023 17:02:47
commit hash: 0c2e9bbcebe1df9f60711b23fcb38ca528f9e5d1commit hash: 0c2e9bbcebe1df9f60711b23fcb38ca528f9e5d1commit hash: 0c2e9bbcebe1df9f60711b23fcb38ca528f9e5d1commit hash: 0c2e9bbcebe1df9f60711b23fcb38ca528f9e5d1 files touched by this commit		 Po-Chuan Hsieh (sunpoet) search for other commits by this committer 
databases/plpgsql_check: Update to 2.4.0

Changes:	https://github.com/okbob/plpgsql_check/releases
2.3.4
18 Apr 2023 18:00:43
commit hash: 15b2c53a2735efb6dfcd7ddc0be883aee929f780commit hash: 15b2c53a2735efb6dfcd7ddc0be883aee929f780commit hash: 15b2c53a2735efb6dfcd7ddc0be883aee929f780commit hash: 15b2c53a2735efb6dfcd7ddc0be883aee929f780 files touched by this commit		 Po-Chuan Hsieh (sunpoet) search for other commits by this committer 
databases/plpgsql_check: Update to 2.3.4

Changes:	https://github.com/okbob/plpgsql_check/releases
2.3.3
15 Apr 2023 13:14:58
commit hash: a40c0e7d8311e72078684f0a7ee388966a6adaf9commit hash: a40c0e7d8311e72078684f0a7ee388966a6adaf9commit hash: a40c0e7d8311e72078684f0a7ee388966a6adaf9commit hash: a40c0e7d8311e72078684f0a7ee388966a6adaf9 files touched by this commit		 Muhammad Moinur Rahman (bofh) search for other commits by this committer 
*/*: Remove pointers to EOLed pgsql versions

- Remove dotted pgsql versions

Approved by:	portmgr
2.3.3
05 Apr 2023 17:29:44
commit hash: bcb40be56fff51a8f178bbb5db0025973d9f1357commit hash: bcb40be56fff51a8f178bbb5db0025973d9f1357commit hash: bcb40be56fff51a8f178bbb5db0025973d9f1357commit hash: bcb40be56fff51a8f178bbb5db0025973d9f1357 files touched by this commit		 Po-Chuan Hsieh (sunpoet) search for other commits by this committer 
databases/plpgsql_check: Update to 2.3.3

Changes:	https://github.com/okbob/plpgsql_check/releases
2.3.1
21 Mar 2023 19:20:01
commit hash: 806d1e6e7d74ad14206b41a72ed5102a30b08104commit hash: 806d1e6e7d74ad14206b41a72ed5102a30b08104commit hash: 806d1e6e7d74ad14206b41a72ed5102a30b08104commit hash: 806d1e6e7d74ad14206b41a72ed5102a30b08104 files touched by this commit		 Po-Chuan Hsieh (sunpoet) search for other commits by this committer 
databases/plpgsql_check: Update to 2.3.1

Changes:	https://github.com/okbob/plpgsql_check/releases
2.3.0
30 Jan 2023 12:58:59
commit hash: 9b37f900868fabc7e76d4d7dd76de3c9dd9827cacommit hash: 9b37f900868fabc7e76d4d7dd76de3c9dd9827cacommit hash: 9b37f900868fabc7e76d4d7dd76de3c9dd9827cacommit hash: 9b37f900868fabc7e76d4d7dd76de3c9dd9827ca files touched by this commit		 Po-Chuan Hsieh (sunpoet) search for other commits by this committer 
databases/plpgsql_check: Update to 2.3.0

Changes:	https://github.com/okbob/plpgsql_check/releases
2.2.3
30 Dec 2022 09:04:05
commit hash: 69ee4aa616253e4494bd7b93b1de57e485cd1682commit hash: 69ee4aa616253e4494bd7b93b1de57e485cd1682commit hash: 69ee4aa616253e4494bd7b93b1de57e485cd1682commit hash: 69ee4aa616253e4494bd7b93b1de57e485cd1682 files touched by this commit		 Po-Chuan Hsieh (sunpoet) search for other commits by this committer 
databases/plpgsql_check: Update to 2.2.3

Changes:	https://github.com/okbob/plpgsql_check/releases
2.2.2
09 Oct 2022 19:45:25
commit hash: 1e139c1d6d1dad66ccfe65b283de76bc11ba1730commit hash: 1e139c1d6d1dad66ccfe65b283de76bc11ba1730commit hash: 1e139c1d6d1dad66ccfe65b283de76bc11ba1730commit hash: 1e139c1d6d1dad66ccfe65b283de76bc11ba1730 files touched by this commit		 Po-Chuan Hsieh (sunpoet) search for other commits by this committer 
databases/plpgsql_check: Update to 2.2.2

Changes:	https://github.com/okbob/plpgsql_check/releases
2.2.1
03 Oct 2022 17:10:16
commit hash: 6ef75e32e3bb10f67eebed1d05c17f49ac6b7f9ecommit hash: 6ef75e32e3bb10f67eebed1d05c17f49ac6b7f9ecommit hash: 6ef75e32e3bb10f67eebed1d05c17f49ac6b7f9ecommit hash: 6ef75e32e3bb10f67eebed1d05c17f49ac6b7f9e files touched by this commit		 Po-Chuan Hsieh (sunpoet) search for other commits by this committer 
databases/plpgsql_check: Update to 2.2.1

Changes:	https://github.com/okbob/plpgsql_check/releases
2.1.10
10 Sep 2022 12:52:58
commit hash: 582ec0b4c1d557516e89b270c24665dd6d1f8375commit hash: 582ec0b4c1d557516e89b270c24665dd6d1f8375commit hash: 582ec0b4c1d557516e89b270c24665dd6d1f8375commit hash: 582ec0b4c1d557516e89b270c24665dd6d1f8375 files touched by this commit		 Po-Chuan Hsieh (sunpoet) search for other commits by this committer 
databases/plpgsql_check: Update to 2.1.10

Changes:	https://github.com/okbob/plpgsql_check/releases
07 Sep 2022 21:58:51
commit hash: fb16dfecae4a6efac9f3a78e0b759fb7a3c53de4commit hash: fb16dfecae4a6efac9f3a78e0b759fb7a3c53de4commit hash: fb16dfecae4a6efac9f3a78e0b759fb7a3c53de4commit hash: fb16dfecae4a6efac9f3a78e0b759fb7a3c53de4 files touched by this commit		 Stefan Eßer (se) search for other commits by this committer 
Remove WWW entries moved into port Makefiles

Commit b7f05445c00f has added WWW entries to port Makefiles based on
WWW: lines in pkg-descr files.

This commit removes the WWW: lines of moved-over URLs from these
pkg-descr files.

Approved by:		portmgr (tcberner)
2.1.9
07 Sep 2022 21:10:59
commit hash: b7f05445c00f2625aa19b4154ebcbce5ed2daa52commit hash: b7f05445c00f2625aa19b4154ebcbce5ed2daa52commit hash: b7f05445c00f2625aa19b4154ebcbce5ed2daa52commit hash: b7f05445c00f2625aa19b4154ebcbce5ed2daa52 files touched by this commit		 Stefan Eßer (se) search for other commits by this committer 
Add WWW entries to port Makefiles

It has been common practice to have one or more URLs at the end of the
ports' pkg-descr files, one per line and prefixed with "WWW:". These
URLs should point at a project website or other relevant resources.

Access to these URLs required processing of the pkg-descr files, and
they have often become stale over time. If more than one such URL was
present in a pkg-descr file, only the first one was tarnsfered into
the port INDEX, but for many ports only the last line did contain the
port specific URL to further information.

There have been several proposals to make a project URL available as
a macro in the ports' Makefiles, over time.
(Only the first 15 lines of the commit message are shown above View all of this commit message)
2.1.9
04 Sep 2022 15:24:41
commit hash: fc3b26b61721c119b2c922bd7802fc81343d3a2acommit hash: fc3b26b61721c119b2c922bd7802fc81343d3a2acommit hash: fc3b26b61721c119b2c922bd7802fc81343d3a2acommit hash: fc3b26b61721c119b2c922bd7802fc81343d3a2a files touched by this commit		 Po-Chuan Hsieh (sunpoet) search for other commits by this committer 
databases/plpgsql_check: Update to 2.1.9

Changes:	https://github.com/okbob/plpgsql_check/releases
2.1.8
30 Jul 2022 19:24:06
commit hash: 4eb464f56f168dbd558e7bc4f8bcc4f8c25094a3commit hash: 4eb464f56f168dbd558e7bc4f8bcc4f8c25094a3commit hash: 4eb464f56f168dbd558e7bc4f8bcc4f8c25094a3commit hash: 4eb464f56f168dbd558e7bc4f8bcc4f8c25094a3 files touched by this commit		 Po-Chuan Hsieh (sunpoet) search for other commits by this committer 
databases/plpgsql_check: Update to 2.1.8

Changes:	https://github.com/okbob/plpgsql_check/releases
2.1.7
20 Jul 2022 14:21:07
commit hash: d076ad94e206dda108061fe99ddb860d93cc6d16commit hash: d076ad94e206dda108061fe99ddb860d93cc6d16commit hash: d076ad94e206dda108061fe99ddb860d93cc6d16commit hash: d076ad94e206dda108061fe99ddb860d93cc6d16 files touched by this commit		 Tobias C. Berner (tcberner) search for other commits by this committer 
databases: remove 'Created by' lines

A big Thank You to the original contributors of these ports:

  *  "Choe, Cheng-Dae" whitekid
  *  "Mahdi Mokhtari <mokhi64@gmail.com>"
  *  "Meikel Brandmeyer" <ocaml-sqlite3-port@kotka.de>
  *  <hvo.pm@xs4all.nl>
  *  <jsmith@resonatingmedia.com>
  *  <ports@c0decafe.net>
  *  Aaron Dalton <aaron@FreeBSD.org>
  *  Adam Weinberger <adamw@FreeBSD.org>
  *  Ade Lovett <ade@FreeBSD.org>
  *  Akinori MUSHA aka knu <knu@idaemons.org>
  *  Alan Snelson <Alan@Wave2.org>
(Only the first 15 lines of the commit message are shown above View all of this commit message)
2.1.7
03 Jun 2022 23:36:29
commit hash: 16a6101fe5f1c2fd1703cbb7b18fe369e1defc05commit hash: 16a6101fe5f1c2fd1703cbb7b18fe369e1defc05commit hash: 16a6101fe5f1c2fd1703cbb7b18fe369e1defc05commit hash: 16a6101fe5f1c2fd1703cbb7b18fe369e1defc05 files touched by this commit		 Po-Chuan Hsieh (sunpoet) search for other commits by this committer 
databases/plpgsql_check: Update to 2.1.7

Changes:	https://github.com/okbob/plpgsql_check/releases
2.1.6
22 May 2022 04:10:46
commit hash: fa61b7123e4850873b5edd569c1b038daa947b19commit hash: fa61b7123e4850873b5edd569c1b038daa947b19commit hash: fa61b7123e4850873b5edd569c1b038daa947b19commit hash: fa61b7123e4850873b5edd569c1b038daa947b19 files touched by this commit		 Po-Chuan Hsieh (sunpoet) search for other commits by this committer 
databases/plpgsql_check: Update to 2.1.6

Changes:	https://github.com/okbob/plpgsql_check/releases
2.1.5
13 May 2022 11:39:14
commit hash: d9f38e3789c80ee2d14c3ef7eff5cc75a774480dcommit hash: d9f38e3789c80ee2d14c3ef7eff5cc75a774480dcommit hash: d9f38e3789c80ee2d14c3ef7eff5cc75a774480dcommit hash: d9f38e3789c80ee2d14c3ef7eff5cc75a774480d files touched by this commit		 Po-Chuan Hsieh (sunpoet) search for other commits by this committer 
databases/plpgsql_check: Update to 2.1.5

Changes:	https://github.com/okbob/plpgsql_check/releases
2.1.3
17 Apr 2022 23:58:00
commit hash: b10049dbda33f99fcf2a7f4752a4e25fba218108commit hash: b10049dbda33f99fcf2a7f4752a4e25fba218108commit hash: b10049dbda33f99fcf2a7f4752a4e25fba218108commit hash: b10049dbda33f99fcf2a7f4752a4e25fba218108 files touched by this commit		 Po-Chuan Hsieh (sunpoet) search for other commits by this committer 
databases/plpgsql_check: Update to 2.1.3

Changes:	https://github.com/okbob/plpgsql_check/releases
2.1.2
28 Feb 2022 12:45:58
commit hash: b83c2b36bcd422ab977070e2b8d5c3b871268e20commit hash: b83c2b36bcd422ab977070e2b8d5c3b871268e20commit hash: b83c2b36bcd422ab977070e2b8d5c3b871268e20commit hash: b83c2b36bcd422ab977070e2b8d5c3b871268e20 files touched by this commit		 Po-Chuan Hsieh (sunpoet) search for other commits by this committer 
databases/plpgsql_check: Update to 2.1.2

Changes:	https://github.com/okbob/plpgsql_check/releases
2.1.1
28 Jan 2022 23:26:36
commit hash: 09763e9fa87bba5bd9e385ed5156f0efc5fc8e92commit hash: 09763e9fa87bba5bd9e385ed5156f0efc5fc8e92commit hash: 09763e9fa87bba5bd9e385ed5156f0efc5fc8e92commit hash: 09763e9fa87bba5bd9e385ed5156f0efc5fc8e92 files touched by this commit		 Po-Chuan Hsieh (sunpoet) search for other commits by this committer 
databases/plpgsql_check: Update to 2.1.1

Changes:	https://github.com/okbob/plpgsql_check/releases
2.0.6
21 Dec 2021 18:46:17
commit hash: 8981fe0db57ead731d4de89c76447e7d3cab87efcommit hash: 8981fe0db57ead731d4de89c76447e7d3cab87efcommit hash: 8981fe0db57ead731d4de89c76447e7d3cab87efcommit hash: 8981fe0db57ead731d4de89c76447e7d3cab87ef files touched by this commit		 Po-Chuan Hsieh (sunpoet) search for other commits by this committer 
databases/plpgsql_check: Update to 2.0.6

Changes:	https://github.com/okbob/plpgsql_check/releases
2.0.5
25 Oct 2021 21:46:31
commit hash: b868cb22485911f3733387730eb331088ff7f024commit hash: b868cb22485911f3733387730eb331088ff7f024commit hash: b868cb22485911f3733387730eb331088ff7f024commit hash: b868cb22485911f3733387730eb331088ff7f024 files touched by this commit		 Po-Chuan Hsieh (sunpoet) search for other commits by this committer 
databases/plpgsql_check: Update to 2.0.5

Changes:	https://github.com/okbob/plpgsql_check/releases
1.17.1
30 Jun 2021 20:43:32
commit hash: e455a17bd30cc5efb10461894659bb4273d29d44commit hash: e455a17bd30cc5efb10461894659bb4273d29d44commit hash: e455a17bd30cc5efb10461894659bb4273d29d44commit hash: e455a17bd30cc5efb10461894659bb4273d29d44 files touched by this commit		 Po-Chuan Hsieh (sunpoet) search for other commits by this committer 
databases/plpgsql_check: Update to 1.17.1

Changes:	https://github.com/okbob/plpgsql_check/releases
1.16.1
25 Jun 2021 13:34:01
commit hash: a78afbc0fa06eec6606421441762aea6ddabefa3commit hash: a78afbc0fa06eec6606421441762aea6ddabefa3commit hash: a78afbc0fa06eec6606421441762aea6ddabefa3commit hash: a78afbc0fa06eec6606421441762aea6ddabefa3 files touched by this commit		 Po-Chuan Hsieh (sunpoet) search for other commits by this committer 
databases/plpgsql_check: Update to 1.16.1

Changes:	https://github.com/okbob/plpgsql_check/releases
1.16.0
18 Apr 2021 05:41:53
commit hash: 954766aa1f64a8babf0741174dbf2a7a5ebacf8fcommit hash: 954766aa1f64a8babf0741174dbf2a7a5ebacf8fcommit hash: 954766aa1f64a8babf0741174dbf2a7a5ebacf8fcommit hash: 954766aa1f64a8babf0741174dbf2a7a5ebacf8f files touched by this commit		 Po-Chuan Hsieh (sunpoet) search for other commits by this committer 
databases/plpgsql_check: Update to 1.16.0

Changes:	https://github.com/okbob/plpgsql_check/releases
1.15.3
06 Apr 2021 14:31:07
commit hash: 305f148f482daf30dcf728039d03d019f88344ebcommit hash: 305f148f482daf30dcf728039d03d019f88344ebcommit hash: 305f148f482daf30dcf728039d03d019f88344ebcommit hash: 305f148f482daf30dcf728039d03d019f88344eb files touched by this commit		 Mathieu Arnold (mat) search for other commits by this committer 
Remove # $FreeBSD$ from Makefiles.
1.15.3
17 Feb 2021 18:00:52
Revision:565544Original commit files touched by this commit		 sunpoet search for other commits by this committer 
Update to 1.15.3

Changes:	https://github.com/okbob/plpgsql_check/releases
1.15.2
26 Jan 2021 17:21:06
Revision:562731Original commit files touched by this commit		 sunpoet search for other commits by this committer 
Update to 1.15.2

Changes:	https://github.com/okbob/plpgsql_check/releases
1.15.1
26 Nov 2020 21:16:53
Revision:556352Original commit files touched by this commit		 sunpoet search for other commits by this committer 
Update to 1.15.1

Changes:	https://github.com/okbob/plpgsql_check/releases
1.14.0
21 Nov 2020 09:17:47
Revision:555819Original commit files touched by this commit		 sunpoet search for other commits by this committer 
Update to 1.14.0

Changes:	https://github.com/okbob/plpgsql_check/releases
1.13.1
19 Sep 2020 15:35:02
Revision:548999Original commit files touched by this commit		 sunpoet search for other commits by this committer 
Cosmetic change
1.13.1
30 Aug 2020 20:02:43
Revision:547078Original commit files touched by this commit		 pkubaj search for other commits by this committer 
databases/plpgsql_check: fix build on GCC architectures

Use C11 compiler:
src/expr_walk.c:37: error: redefinition of typedef 'check_function_callback'
/usr/local/include/postgresql/server/nodes/nodeFuncs.h:30: error: previous
declaration of 'check_function_callback' was here
1.13.1
21 Aug 2020 21:21:36
Revision:545626Original commit files touched by this commit		 sunpoet search for other commits by this committer 
Update to 1.13.1

Changes:	https://github.com/okbob/plpgsql_check/releases
1.13.0
19 Aug 2020 16:18:18
Revision:545343Original commit files touched by this commit		 sunpoet search for other commits by this committer 
Update to 1.13.0

Changes:	https://github.com/okbob/plpgsql_check/releases
1.11.4
08 Aug 2020 10:17:15
Revision:544385Original commit files touched by this commit		 sunpoet search for other commits by this committer 
Update to 1.11.4

Changes:	https://github.com/okbob/plpgsql_check/releases
1.11.3
30 Jul 2020 09:49:46
Revision:543739Original commit files touched by this commit		 sunpoet search for other commits by this committer 
Update to 1.11.3

Changes:	https://github.com/okbob/plpgsql_check/releases
1.11.2
24 Jul 2020 07:08:35
Revision:543016Original commit files touched by this commit		 sunpoet search for other commits by this committer 
Update to 1.11.2

Changes:	https://github.com/okbob/plpgsql_check/releases
1.11.0
08 Jul 2020 18:55:20
Revision:541514Original commit files touched by this commit		 sunpoet search for other commits by this committer 
Update to 1.11.0

Changes:	https://github.com/okbob/plpgsql_check/releases
1.10.1
15 Jun 2020 18:43:20
Revision:538934Original commit files touched by this commit		 sunpoet search for other commits by this committer 
Update to 1.10.1

Changes:	https://github.com/okbob/plpgsql_check/releases
1.9.2
02 May 2020 01:36:31
Revision:533606Original commit files touched by this commit		 sunpoet search for other commits by this committer 
Update to 1.9.2

Changes:	https://github.com/okbob/plpgsql_check/releases
1.9.1
28 Apr 2020 22:54:53
Revision:533281Original commit files touched by this commit		 sunpoet search for other commits by this committer 
Update to 1.9.1

Changes:	https://github.com/okbob/plpgsql_check/releases
1.9.0
02 Apr 2020 12:01:00
Revision:530284Original commit files touched by this commit		 sunpoet search for other commits by this committer 
Update to 1.9.0

Changes:	https://github.com/okbob/plpgsql_check/releases
1.8.2
08 Jan 2020 14:48:29
Revision:522377Original commit files touched by this commit		 sunpoet search for other commits by this committer 
Update to 1.8.2

Changes:	https://github.com/okbob/plpgsql_check/releases
1.8.1
06 Jan 2020 14:44:25
Revision:522239Original commit files touched by this commit		 sunpoet search for other commits by this committer 
Update to 1.8.1

Changes:	https://github.com/okbob/plpgsql_check/releases
1.8.0
30 Dec 2019 16:56:45
Revision:521501Original commit files touched by this commit		 sunpoet search for other commits by this committer 
Update to 1.8.0

Changes:	https://github.com/okbob/plpgsql_check/releases
1.7.6
26 Sep 2019 18:12:59
Revision:512915Original commit files touched by this commit		 sunpoet search for other commits by this committer 
Update to 1.7.6

Changes:	https://github.com/okbob/plpgsql_check/releases
1.7.5
12 Sep 2019 19:06:43
Revision:511890Original commit files touched by this commit		 sunpoet search for other commits by this committer 
Update to 1.7.5

Changes:	https://github.com/okbob/plpgsql_check/releases
1.7.3
01 Aug 2019 16:15:19
Revision:507780Original commit files touched by this commit		 sunpoet search for other commits by this committer 
Update to 1.7.3

Changes:	https://github.com/okbob/plpgsql_check/releases
1.7.2_1
26 Jul 2019 20:46:57
Revision:507372Original commit files touched by this commit		 gerald search for other commits by this committer 
Bump PORTREVISION for ports depending on the canonical version of GCC
as defined in Mk/bsd.default-versions.mk which has moved from GCC 8.3
to GCC 9.1 under most circumstances now after revision 507371.

This includes ports
 - with USE_GCC=yes or USE_GCC=any,
 - with USES=fortran,
 - using Mk/bsd.octave.mk which in turn features USES=fortran, and
 - with USES=compiler specifying openmp, nestedfct, c11, c++0x, c++11-lang,
   c++11-lib, c++14-lang, c++17-lang, or gcc-c++11-lib
plus, everything INDEX-11 shows with a dependency on lang/gcc9 now.

PR:		238330
1.7.2
21 May 2019 18:03:39
Revision:502224Original commit files touched by this commit		 sunpoet search for other commits by this committer 
Update to 1.7.2

Changes:	https://github.com/okbob/plpgsql_check/releases
1.7.1
26 Apr 2019 20:45:35
Revision:500141Original commit files touched by this commit		 sunpoet search for other commits by this committer 
Update to 1.7.1

Changes:	https://github.com/okbob/plpgsql_check/releases
1.7.0
18 Apr 2019 17:59:43
Revision:499285Original commit files touched by this commit		 sunpoet search for other commits by this committer 
Update to 1.7.0

- Use PGSQL_VER_NODOT
- Add LICENSE_FILE
- Update pkg-descr
- Take maintainership

Changes:	https://github.com/okbob/plpgsql_check/releases
1.2.0_2
12 Dec 2018 01:35:36
Revision:487272Original commit files touched by this commit		 gerald search for other commits by this committer 
Bump PORTREVISION for ports depending on the canonical version of GCC
defined via Mk/bsd.default-versions.mk which has moved from GCC 7.4 t
GCC 8.2 under most circumstances.

This includes ports
 - with USE_GCC=yes or USE_GCC=any,
 - with USES=fortran,
 - using Mk/bsd.octave.mk which in turn features USES=fortran, and
 - with USES=compiler specifying openmp, nestedfct, c11, c++0x, c++11-lang,
   c++11-lib, c++14-lang, c++17-lang, or gcc-c++11-lib
plus, as a double check, everything INDEX-11 showed depending on lang/gcc7.

PR:		231590
1.2.0_1
24 Jun 2018 00:54:27
Revision:473169Original commit files touched by this commit		 linimon search for other commits by this committer 
Workaround the following problem on aarch64 by setting LLD_UNSAFE=yes:

  cc: error: invalid linker name in argument '-fuse-ld=bfd'

Neither emaste nor I can figure out exactly where the offending stanza is
coming in.  It will take someone with more knowledge of gmake debug flags,
and possibly the src build infrastructure, to figure it out.

While here, pet portlint.

Approved by:	portmgr (tier-2 blanket)
1.2.0_1
22 Jun 2018 08:28:00
Revision:473023Original commit files touched by this commit		 yuri search for other commits by this committer 
Correction to r473019: Revert the unintended change to the 'Created by' headers.
1.2.0_1
22 Jun 2018 08:04:39
Revision:473019Original commit files touched by this commit		 yuri search for other commits by this committer 
Reset MAINTAINER on ports maintained by amutu@amutu.com

Based on the new policy of all maintained ports reset
when maintaner is absent for 3 months.

Bug#226400 for science/py-tensorflow is ignored since 2018-03-06 (3+ months).
portscout database indicates that 48.94% of his ports aren't updated.
1.2.0_1
06 Jul 2017 09:23:27
Revision:445131Original commit files touched by this commit		 tz search for other commits by this committer 
databases/plpgsql_check: Add missing stripping
1.2.0
05 Jul 2017 09:24:14
Revision:445059Original commit files touched by this commit		 tz search for other commits by this committer 
New port: databases/plpgsql_check

Plpgsql_check is next generation of plpgsql_lint. It allows to check source
code by explicit call plpgsql_check_function. The SQL statements inside
PL/pgSQL functions are checked by validator for semantic errors. These errors
can be found by plpgsql_check_function. PostgreSQL 9.2 is required, PostgreSQL
9.3, 9.4, 9.5, 9.6 and 10 are supported.

WWW: https://github.com/okbob/plpgsql_check

PR:           219680
Submitted by: Jov <amutu@amutu.com>

Number of commits found: 82
Login
User Login
Create account

Servers and bandwidth provided by
New York Internet, iXsystems, and RootBSD

This site
What is FreshPorts?
About the authors
Issues
FAQ
How big is it?
Security Policy
Privacy
Blog
Contact

Search
Enter Keywords:
 
more...

Latest Vulnerabilities
electron33Mar 28
electron34Mar 28
gitlabMar 26
electron33Mar 25
electron34Mar 25
qt5-webengineMar 23
varnish7Mar 22
chromiumMar 20
ungoogled-chromiumMar 20
gitlabMar 13
opensamlMar 13
php81Mar 13
php82Mar 13
php83Mar 13
php84Mar 13

6 vulnerabilities affecting 91 ports have been reported in the past 14 days

* - modified, not new

All vulnerabilities

Last processed:
2025-03-28 12:03:43 UTC


Ports
Home
Categories
Deleted ports
Sanity Test Failures
Newsfeeds

Statistics
Graphs
NEW Graphs (Javascript)

Calculated hourly:
Port count 33321
Broken 130
Deprecated 329
Ignore 245
Forbidden 1
Restricted 2
No CDROM 1
Vulnerable 27
Expired 16
Set to expire 287
Interactive 0
new 24 hours 8
new 48 hours14
new 7 days28
new fortnight56
new month106
Servers and bandwidth provided by
New York Internet, iXsystems, and RootBSD 		Valid HTML, CSS, and RSS. Copyright © 2000-2025 Dan Langille. All rights reserved.