pg_task

maintainer brauliobo · 0 votes · scanned 2026-08-03 00:08:14.047287

LOW

Why flagged The source is a versioned release tarball from pgxn.org, a known PostgreSQL extension repository;虽非标准主机但属项目相关生态，且为源码构建非远程二进制执行，风险低。

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 source is a versioned release tarball from pgxn.org, a known PostgreSQL extension repository;虽非标准主机但属项目相关生态，且为源码构建非远程二进制执行，风险低。

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

MEDIUM source=() URL on a non-standard host source_untrusted_domain

One or more source=() URLs point to a host outside the trusted allowlist (github.com, gitlab.com, codeberg.org, pypi.org, …).

PKGBUILD:12 source=("https://api.pgxn.org/dist/$pkgname/$pkgver/$pkgname-$pkgver.zip")

PKGBUILD

1 offending line(s) highlighted

      1# maintainer: luka null <lukadevnull@vivaldi.net>
    
      2pkgname=pg_task
    
      3pkgver=2.1.29
    
      4pkgrel=1
    
      5pkgdesc='PostgreSQL job scheduler for asynchronous background SQL execution'
    
      6arch=('x86_64')
    
      7url='https://github.com/RekGRpth/pg_task'
    
      8license=('MIT')
    
      9depends=('postgresql')
    
      10makedepends=('make' 'gcc' 'clang' 'llvm' 'curl' 'pcre')
    
      11install="$pkgname.install"
    
      12source=("https://api.pgxn.org/dist/$pkgname/$pkgver/$pkgname-$pkgver.zip")
    
      13sha256sums=('6fa7fe6c5187db5bb8fbe7477c00bd76042bb73c0f2df50c2e904b74567f31ca')
    
      14
    
      15build() {
    
      16  cd "$pkgname-$pkgver"
    
      17  make
    
      18}
    
      19
    
      20package() {
    
      21  cd "$pkgname-$pkgver"
    
      22  make DESTDIR="$pkgdir" install
    
      23  install -Dm644 LICENSE "$pkgdir/usr/share/licenses/$pkgname/LICENSE"
    
      24}
    
      25

Scan history

Scanned at (UTC)	Severity	Rules
2026-08-03 00:08:14	LOW	2
2026-08-02 00:16:08	LOW	2
2026-08-01 00:11:18	LOW	2
2026-07-31 00:14:10	LOW	2
2026-07-30 00:17:23	LOW	2
2026-07-29 00:25:53	LOW	2
2026-07-28 00:07:28	LOW	2
2026-07-27 00:24:32	LOW	2
2026-07-26 00:07:32	LOW	2
2026-07-25 00:13:44	LOW	2
2026-07-24 00:02:28	LOW	2
2026-07-23 00:14:47	LOW	2
2026-07-22 00:29:32	LOW	2
2026-07-21 00:24:15	LOW	2
2026-07-20 00:19:49	LOW	2
2026-07-19 00:17:08	LOW	2
2026-07-18 00:14:48	LOW	2
2026-07-17 00:06:16	LOW	2
2026-07-16 00:05:41	LOW	2
2026-07-15 00:09:25	LOW	2