pg_strict

LOW

maintainer brauliobo 0 votes scanned 2026-11-01 00:21:48.120785

View on AUR

Why flagged

The PKGBUILD uses cargo to build a PostgreSQL extension from the project's own source code; the 'cargo install' of cargo-pgrx is a standard build tool setup and not an external untrusted package installation, posing no real risk.

Triggered rules

Low AI review downgraded a static finding llm_review

The static rules flagged this MEDIUM, but an AI model (qwen/qwen3-235b-a22b-07-25) reviewed the full PKGBUILD and judged it LOW (confidence 95%): The PKGBUILD uses cargo to build a PostgreSQL extension from the project's own source code; the 'cargo install' of cargo-pgrx is a standard build tool setup and not an external untrusted package installation, posing no real risk.

1 higher static finding superseded - not the current verdict (shown for transparency)

Medium External install via pipx/uv/poetry/cargo/go/gem alt_pkg_manager_install

A non-pip/npm package manager (pipx, uv, poetry, cargo install, go install, gem, conda…) fetches and builds an external package at build time, outside source=() and makepkg's checksums.

PKGBUILD:22 cargo install cargo-pgrx --locked --version 0.16.1 --root "$srcdir/.cargo-pgrx"

PKGBUILD

1 offending line(s) highlighted

      1# maintainer: luka null <lukadevnull@vivaldi.net>
    
      2# old maintainer: Alexey Kh <aur@devass.club>
    
      3pkgname=pg_strict
    
      4pkgver=1.0.3
    
      5pkgrel=1
    
      6pkgdesc='Blocks dangerous UPDATE and DELETE statements in PostgreSQL'
    
      7arch=('x86_64')
    
      8url='https://github.com/spa5k/pg_strict'
    
      9license=('PostgreSQL')
    
      10depends=('postgresql')
    
      11makedepends=('cargo' 'clang' 'llvm' 'rust')
    
      12source=("$pkgname-$pkgver.tar.gz::$url/archive/refs/tags/v$pkgver.tar.gz")
    
      13sha256sums=('ceeda6696d7985f07866d99d8d98a40ea525c260f36de910c2ca9f8aba6726e8')
    
      14
    
      15build() {
    
      16  cd "$pkgname-$pkgver"
    
      17  local pg_major pg_feature pgrx_home
    
      18  pg_major="$(pg_config --version | awk '{print $2}' | cut -d. -f1)"
    
      19  pg_feature="pg${pg_major}"
    
      20  pgrx_home="$srcdir/.pgrx"
    
      21
    
      22  cargo install cargo-pgrx --locked --version 0.16.1 --root "$srcdir/.cargo-pgrx"
    
      23  PATH="$srcdir/.cargo-pgrx/bin:$PATH" PGRX_HOME="$pgrx_home" \
    
      24    cargo pgrx init --pg"${pg_major}" "$(command -v pg_config)"
    
      25  PATH="$srcdir/.cargo-pgrx/bin:$PATH" PGRX_HOME="$pgrx_home" \
    
      26    cargo pgrx package \
    
      27    --pg-config "$(command -v pg_config)" \
    
      28    --no-default-features \
    
      29    --features "${pg_feature}"
    
      30}
    
      31
    
      32package() {
    
      33  cd "$pkgname-$pkgver"
    
      34  local pg_major package_root
    
      35  pg_major="$(pg_config --version | awk '{print $2}' | cut -d. -f1)"
    
      36  package_root="target/release/pg_strict-pg${pg_major}"
    
      37
    
      38  install -Dm755 "$package_root/usr/lib/postgresql/pg_strict.so" \
    
      39    "$pkgdir/usr/lib/postgresql/pg_strict.so"
    
      40  install -Dm644 "$package_root/usr/share/postgresql/extension/pg_strict.control" \
    
      41    "$pkgdir/usr/share/postgresql/extension/pg_strict.control"
    
      42  install -Dm644 "$package_root/usr/share/postgresql/extension/pg_strict--${pkgver}.sql" \
    
      43    "$pkgdir/usr/share/postgresql/extension/pg_strict--${pkgver}.sql"
    
      44}
    
      45

Scan history

Scanned at (UTC)	Severity	Rules
2026-11-01 00:21:48	Low	2
2026-10-31 00:07:41	Low	2
2026-10-30 00:29:30	Low	2
2026-10-29 00:13:55	Low	2
2026-10-28 00:06:54	Low	2
2026-10-27 00:23:28	Low	2
2026-10-26 00:12:40	Low	2
2026-10-25 00:20:48	Low	2
2026-10-24 00:14:55	Low	2
2026-10-23 00:02:19	Low	2
2026-10-22 00:13:10	Low	2
2026-10-21 00:12:50	Low	2
2026-10-20 00:10:31	Low	2
2026-10-19 00:03:55	Low	2
2026-10-18 00:06:55	Low	2
2026-10-17 00:21:55	Low	2
2026-10-16 00:12:47	Low	2
2026-10-15 00:28:05	Low	2
2026-10-14 00:06:47	Low	2
2026-10-13 00:23:45	Low	2