Vulnerability advisory

CVE-2024-27289

pgx SQL Injection via Line Comment Creation

Published Updated OSV record ↗

Also known as GHSA-m7wr-2xf7-cm9pGO-2024-2605

Severity
  • CVSS 3.xCVSS:3.1/AV:N/AC:H/PR:N/UI:N/S:U/C:H/I:H/A:H

Affected versions

Repository

Affected commitsFixed by commit
GIT github.com/jackc/pgx ↗
All commits before 14690df4c533758df97f7cc561cb9062155045c614690df4c533758df97f7cc561cb9062155045c6
Not specifiedf94eb0e2f96782042c96801b5ac448f44f0a81df
Also listed as affected (57)
  • v4.18.1
  • v4.18.0
  • v4.17.2
  • v4.17.1
  • v4.17.0
  • v4.16.1
  • v4.16.0
  • v4.15.0
  • v4.14.1
  • v4.14.0
  • v4.13.0
  • v4.12.0
  • v4.11.0
  • v4.10.1
  • v4.10.0
  • v4.9.2
  • v4.9.1
  • v4.9.0
  • v4.8.1
  • v4.8.0
  • v4.7.2
  • v4.7.1
  • v4.7.0
  • v4.6.0
  • v4.5.0
  • v4.4.1
  • v4.4.0
  • v4.3.0
  • v4.2.1
  • v4.2.0
  • v4.1.2
  • v4.1.1
  • v4.1.0
  • v4.0.1
  • v4.0.0
  • v4.0.0-rc2
  • v4.0.0-rc1
  • v4.0.0-pre2
  • v4.0.0-pre1
  • v3.2.0
  • v3.1.0
  • v3.0.1
  • v3.0.0
  • v2.11.0
  • v2.10.0
  • v2.9.0
  • v2.8.1
  • v2.8.0
  • v2.7.1
  • v2.7.0
  • v2.6.0
  • v2.5.0
  • v2.4.0
  • v2.3.0
  • v2.2.0
  • v2.1.0
  • v2.0.0

Description

pgx is a PostgreSQL driver and toolkit for Go. Prior to version 4.18.2, SQL injection can occur when all of the following conditions are met: the non-default simple protocol is used; a placeholder for a numeric value must be immediately preceded by a minus; there must be a second placeholder for a string value after the first placeholder; both must be on the same line; and both parameter values must be user-controlled. The problem is resolved in v4.18.2. As a workaround, do not use the simple protocol or do not place a minus directly before a placeholder.

References

  • Codex
  • Claude Code
  • VS Code
  • GitHub Copilot
  • Cursor
  • Cline
  • Windsurf
  • Google Anti-gravity
  • OpenCode
  • Pi
  • Gemini CLI
  • Hermes Agent
  • Zed
  • Junie
  • Qwen Code
  • Kiro
  • Kilo Code
  • Factory Droid

Set up GitHits for your agents

Run this command:

<> bash
npx githits@latest init

What happens next:

  1. Opens your browser to authorize GitHits
  2. Asks whether to set up GitHits at the user or project level
  3. Detects your supported AI coding tools
  4. Lets you choose which tools to configure
  5. Configures the selected tools