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?
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
go get github.com/jackc/pgx@v4.18.2- Affected
- <4.18.2
- Fixed in
- 4.18.2
go get github.com/jackc/pgx/v4@v4.18.2Details
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
References
Advisory data from OSV.dev (opens OSV.dev in a new tab), refreshed daily.