[PR #5967] [CLOSED] Bump github.com/jackc/pgx/v5 from 5.5.5 to 5.9.2 #27223

Open
opened 2026-08-05 07:08:23 -04:00 by saavagebueno · 0 comments
Owner

📋 Pull Request Information

Original PR: https://github.com/netbirdio/netbird/pull/5967
Author: @dependabot[bot]
Created: 4/22/2026
Status: Closed

Base: mainHead: dependabot/go_modules/github.com/jackc/pgx/v5-5.9.2


📝 Commits (1)

  • c0c052a Bump github.com/jackc/pgx/v5 from 5.5.5 to 5.9.2

📊 Changes

2 files changed (+9 additions, -9 deletions)

View changed files

📝 go.mod (+3 -3)
📝 go.sum (+6 -6)

📄 Description

Bumps github.com/jackc/pgx/v5 from 5.5.5 to 5.9.2.

Changelog

Sourced from github.com/jackc/pgx/v5's changelog.

5.9.2 (April 18, 2026)

Fix SQL Injection via placeholder confusion with dollar quoted string literals (GHSA-j88v-2chj-qfwx)

SQL injection can occur when:

  1. The non-default simple protocol is used.
  2. A dollar quoted string literal is used in the SQL query.
  3. That query contains text that would be would be interpreted outside as a placeholder outside of a string literal.
  4. The value of that placeholder is controllable by the attacker.

e.g.

attackValue := `$tag$; drop table canary; --`
_, err = tx.Exec(ctx, `select $tag$ $1 $tag$, $1`, pgx.QueryExecModeSimpleProtocol, attackValue)

This is unlikely to occur outside of a contrived scenario.

5.9.1 (March 22, 2026)

  • Fix: batch result format corruption when using cached prepared statements (reported by Dirkjan Bussink)

5.9.0 (March 21, 2026)

This release includes a number of new features such as SCRAM-SHA-256-PLUS support, OAuth authentication support, and PostgreSQL protocol 3.2 support.

It significantly reduces the amount of network traffic when using prepared statements (which are used automatically by default) by avoiding unnecessary Describe Portal messages. This also reduces local memory usage.

It also includes multiple fixes for potential DoS due to panic or OOM if connected to a malicious server that sends deliberately malformed messages.

  • Require Go 1.25+
  • Add SCRAM-SHA-256-PLUS support (Adam Brightwell)
  • Add OAuth authentication support for PostgreSQL 18 (David Schneider)
  • Add PostgreSQL protocol 3.2 support (Dirkjan Bussink)
  • Add tsvector type support (Adam Brightwell)
  • Skip Describe Portal for cached prepared statements reducing network round trips
  • Make LoadTypes query easier to support on "postgres-like" servers (Jelte Fennema-Nio)
  • Default empty user to current OS user matching libpq behavior (ShivangSrivastava)
  • Optimize LRU statement cache with custom linked list and node pooling (Mathias Bogaert)
  • Optimize date scanning by replacing regex with manual parsing (Mathias Bogaert)
  • Optimize pgio append/set functions with direct byte shifts (Mathias Bogaert)
  • Make RowsAffected faster (Abhishek Chanda)
  • Fix: Pipeline.Close panic when server sends multiple FATAL errors (Varun Chawla)
  • Fix: ContextWatcher goroutine leak (Hank Donnay)
  • Fix: stdlib discard connections with open transactions in ResetSession (Jeremy Schneider)

... (truncated)

Commits
  • 0aeabbc Release v5.9.2
  • 60644f8 Fix SQL sanitizer bugs with dollar-quoted strings and placeholder overflow
  • a5680bc Merge pull request #2531 from dolmen-go/godoc-add-links
  • e34e452 doc: Add godoc links
  • 08c9bb1 Fix Stringer types encoded as text instead of numeric value in composite fields
  • 96b4dbd Remove unstable test
  • acf88e0 Merge pull request #2526 from abrightwell/abrightwell-min-proto
  • 2f81f1f Update max_protocol_version and min_protocol_version defaults
  • 4e4eaed Release v5.9.1
  • 6273188 Fix batch result format corruption when using cached prepared statements
  • Additional commits viewable in compare view

Note


Automatic rebases have been disabled on this pull request as it has been open for over 30 days.


🔄 This issue represents a GitHub Pull Request. It cannot be merged through Gitea due to API limitations.

## 📋 Pull Request Information **Original PR:** https://github.com/netbirdio/netbird/pull/5967 **Author:** [@dependabot[bot]](https://github.com/apps/dependabot) **Created:** 4/22/2026 **Status:** ❌ Closed **Base:** `main` ← **Head:** `dependabot/go_modules/github.com/jackc/pgx/v5-5.9.2` --- ### 📝 Commits (1) - [`c0c052a`](https://github.com/netbirdio/netbird/commit/c0c052acb25e22e04741492e49643ff04292da14) Bump github.com/jackc/pgx/v5 from 5.5.5 to 5.9.2 ### 📊 Changes **2 files changed** (+9 additions, -9 deletions) <details> <summary>View changed files</summary> 📝 `go.mod` (+3 -3) 📝 `go.sum` (+6 -6) </details> ### 📄 Description Bumps [github.com/jackc/pgx/v5](https://github.com/jackc/pgx) from 5.5.5 to 5.9.2. <details> <summary>Changelog</summary> <p><em>Sourced from <a href="https://github.com/jackc/pgx/blob/master/CHANGELOG.md">github.com/jackc/pgx/v5's changelog</a>.</em></p> <blockquote> <h1>5.9.2 (April 18, 2026)</h1> <p>Fix SQL Injection via placeholder confusion with dollar quoted string literals (GHSA-j88v-2chj-qfwx)</p> <p>SQL injection can occur when:</p> <ol> <li>The non-default simple protocol is used.</li> <li>A dollar quoted string literal is used in the SQL query.</li> <li>That query contains text that would be would be interpreted outside as a placeholder outside of a string literal.</li> <li>The value of that placeholder is controllable by the attacker.</li> </ol> <p>e.g.</p> <pre lang="go"><code>attackValue := `$tag$; drop table canary; --` _, err = tx.Exec(ctx, `select $tag$ $1 $tag$, $1`, pgx.QueryExecModeSimpleProtocol, attackValue) </code></pre> <p>This is unlikely to occur outside of a contrived scenario.</p> <h1>5.9.1 (March 22, 2026)</h1> <ul> <li>Fix: batch result format corruption when using cached prepared statements (reported by Dirkjan Bussink)</li> </ul> <h1>5.9.0 (March 21, 2026)</h1> <p>This release includes a number of new features such as SCRAM-SHA-256-PLUS support, OAuth authentication support, and PostgreSQL protocol 3.2 support.</p> <p>It significantly reduces the amount of network traffic when using prepared statements (which are used automatically by default) by avoiding unnecessary Describe Portal messages. This also reduces local memory usage.</p> <p>It also includes multiple fixes for potential DoS due to panic or OOM if connected to a malicious server that sends deliberately malformed messages.</p> <ul> <li>Require Go 1.25+</li> <li>Add SCRAM-SHA-256-PLUS support (Adam Brightwell)</li> <li>Add OAuth authentication support for PostgreSQL 18 (David Schneider)</li> <li>Add PostgreSQL protocol 3.2 support (Dirkjan Bussink)</li> <li>Add tsvector type support (Adam Brightwell)</li> <li>Skip Describe Portal for cached prepared statements reducing network round trips</li> <li>Make LoadTypes query easier to support on &quot;postgres-like&quot; servers (Jelte Fennema-Nio)</li> <li>Default empty user to current OS user matching libpq behavior (ShivangSrivastava)</li> <li>Optimize LRU statement cache with custom linked list and node pooling (Mathias Bogaert)</li> <li>Optimize date scanning by replacing regex with manual parsing (Mathias Bogaert)</li> <li>Optimize pgio append/set functions with direct byte shifts (Mathias Bogaert)</li> <li>Make RowsAffected faster (Abhishek Chanda)</li> <li>Fix: Pipeline.Close panic when server sends multiple FATAL errors (Varun Chawla)</li> <li>Fix: ContextWatcher goroutine leak (Hank Donnay)</li> <li>Fix: stdlib discard connections with open transactions in ResetSession (Jeremy Schneider)</li> </ul> <!-- raw HTML omitted --> </blockquote> <p>... (truncated)</p> </details> <details> <summary>Commits</summary> <ul> <li><a href="https://github.com/jackc/pgx/commit/0aeabbcf11d859229c1f0b20e710d3596c76bf27"><code>0aeabbc</code></a> Release v5.9.2</li> <li><a href="https://github.com/jackc/pgx/commit/60644f84918a8af66d14a4b0d865d4edafd955da"><code>60644f8</code></a> Fix SQL sanitizer bugs with dollar-quoted strings and placeholder overflow</li> <li><a href="https://github.com/jackc/pgx/commit/a5680bc945aa7c6ebac2778d859ee7b4ba86db60"><code>a5680bc</code></a> Merge pull request <a href="https://redirect.github.com/jackc/pgx/issues/2531">#2531</a> from dolmen-go/godoc-add-links</li> <li><a href="https://github.com/jackc/pgx/commit/e34e4524007062710c6a4fb9c8655b75a486b5cd"><code>e34e452</code></a> doc: Add godoc links</li> <li><a href="https://github.com/jackc/pgx/commit/08c9bb1f0d8fa6cc10ed8c713e68b1baa64dfe2c"><code>08c9bb1</code></a> Fix Stringer types encoded as text instead of numeric value in composite fields</li> <li><a href="https://github.com/jackc/pgx/commit/96b4dbdfd0458cb425bf8454d292a23978872cc8"><code>96b4dbd</code></a> Remove unstable test</li> <li><a href="https://github.com/jackc/pgx/commit/acf88e0065682e8948696d26fa6438669c4cabee"><code>acf88e0</code></a> Merge pull request <a href="https://redirect.github.com/jackc/pgx/issues/2526">#2526</a> from abrightwell/abrightwell-min-proto</li> <li><a href="https://github.com/jackc/pgx/commit/2f81f1fc03bef99593e92c64ad9cac954c00e8e6"><code>2f81f1f</code></a> Update <code>max_protocol_version</code> and <code>min_protocol_version</code> defaults</li> <li><a href="https://github.com/jackc/pgx/commit/4e4eaedb47b7b3cfba0a1b0a9e6a3f015764f046"><code>4e4eaed</code></a> Release v5.9.1</li> <li><a href="https://github.com/jackc/pgx/commit/62731882651a90348febb43b2119b5f8bd9272de"><code>6273188</code></a> Fix batch result format corruption when using cached prepared statements</li> <li>Additional commits viewable in <a href="https://github.com/jackc/pgx/compare/v5.5.5...v5.9.2">compare view</a></li> </ul> </details> <br /> > **Note** > Automatic rebases have been disabled on this pull request as it has been open for over 30 days. --- <sub>🔄 This issue represents a GitHub Pull Request. It cannot be merged through Gitea due to API limitations.</sub>
saavagebueno added the pull-request label 2026-08-05 07:08:23 -04:00
Sign in to join this conversation.
No Label pull-request
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: DYNR/netbird#27223