HighGHSA-m7wr-2xf7-cm9pCVE-2024-27289GO-2024-2605

pgx SQL Injection via Line Comment Creation

Published 4 Mar 2024 · Updated 10 Sept 2026

Is your project on an affected github.com/jackc/pgx?

Private repo? Upload its lockfile instead, or connect GitHub to check every repo.

Look after several Go apps? Indie watches up to 15 repos, private ones too, for $5 a month. See Indie

Affected packages

Affected
<4.18.2
Fixed in
4.18.2
Update to the fixed version for your release line, for example:go get github.com/jackc/pgx@v4.18.2
Affected
<4.18.2
Fixed in
4.18.2
Update to the fixed version for your release line, for example:go get github.com/jackc/pgx/v4@v4.18.2

Details

Impact

SQL injection can occur when all of the following conditions are met:

1. The non-default simple protocol is used. 2. A placeholder for a numeric value must be immediately preceded by a minus. 3. There must be a second placeholder for a string value after the first placeholder; both must be on the same line. 4. Both parameter values must be user-controlled.

e.g.

Simple mode must be enabled:

// connection string includes "prefer_simple_protocol=true"
// or
// directly enabled in code
config.ConnConfig.PreferSimpleProtocol = true

Parameterized query:

SELECT * FROM example WHERE result=-$1 OR name=$2;

Parameter values:

$1 => -42 $2 => "foo\n 1 AND 1=0 UNION SELECT * FROM secrets; --"

Resulting query after preparation:

SELECT * FROM example WHERE result=--42 OR name= 'foo
1 AND 1=0 UNION SELECT * FROM secrets; --';

Patches

The problem is resolved in v4.18.2.

Workarounds

Do not use the simple protocol or do not place a minus directly before a placeholder.

Is GHSA-m7wr-2xf7-cm9p in any of your client repos?

Checking one package by hand is fine. Checking it across forty client projects is not. NPMscan reads the lockfiles in every GitHub repo you pick, finds each project with an affected github.com/jackc/pgx, and gives you the command that fixes it.

More advisories for github.com/jackc/pgx

  • LowCVE-2026-41889SQL Injection via placeholder confusion with dollar quoted string literals in github.com/jackc/pgx · 22 Jun 2026
  • LowCVE-2026-41889pgx: SQL Injection via placeholder confusion with dollar quoted string literals · 22 Apr 2026
  • LowCVE-2024-27304SQL injection in github.com/jackc/pgproto3 and github.com/jackc/pgx · 14 Mar 2024
  • HighCVE-2024-27304pgx SQL Injection via Protocol Message Size Overflow · 4 Mar 2024
github.com/jackc/pgx security overview

References

Advisory data from OSV.dev (opens OSV.dev in a new tab), refreshed daily.