NewYour coding agent can read the release notes before it upgrades.Set up the MCP server →
Go modules, #920 by repository stars
Latest stable
v1.5.0
Last release 12 days ago
10 Nov 2026
Ships on a steady schedule
a new release about every 8 days
Nearly every release is documented
notes for 58 of the last 60 stable releases
Nothing withdrawn
no release was ever pulled
3 years old
1253 releases · first in 2023
Drag across the ruler to compare, or tap a release to open it.
Nothing published for this version
Nothing published for this version
Nothing published for this version
Nothing published for this version
Your coding agent can read these notes before it upgrades. Set up the MCP server →
Nothing published for this version
Nothing published for this version
Nothing published for this version
Nothing published for this version
Nothing published for this version
Nothing published for this version
Nothing published for this version
Nothing published for this version
Nothing published for this version
Nothing published for this version
Nothing published for this version
Nothing published for this version
Nothing published for this version
Nothing published for this version
2914: Tests for foreign keys with different encodings Relies on https://github.com/dolthub/dolt/pull/11285
COALESCE() use with mixed types, and simplified implementation to use the DoltgresType.ConvertType() function instead of directly using the assignment cast.See full diff in compare view 
[//]: # (dependabot-automerge-end)@dependabot rebase will rebase this PR@dependabot recreate will recreate this PR, overwriting any edits that have been made to it@dependabot show <dependency name> ignore conditions will show all of the ignore conditions of the specified dependency@dependabot ignore this major version will close this PR and stop Dependabot creating any more for this major version (unless you reopen the PR or upgrade to it yourself)@dependabot ignore this minor version will close this PR and stop Dependabot creating any more for this minor version (unless you reopen the PR or upgrade to it yourself)@dependabot ignore this dependency will close this PR and stop Dependabot creating any more for this dependency (unless you reopen the PR or upgrade to it yourself)
You can disable automated security fix PRs for this repo from the Security Alerts page.
</details>…tps://docs.github.com/en/github/managing-security-vulnerabilities/about-dependabot-security-updates#about-compatibility-scores) Dependabot will resolv…
@dependabot rebase.
[//]: # (dependabot-automerge-start)
[//]: # (dependabot-automerge-end)@dependabot rebase will rebase this PR@dependabot recreate will recreate this PR, overwriting any edits that have been made to it@dependabot show <dependency name> ignore conditions will show all of the ignore conditions of the specified dependency@dependabot ignore this major version will close this PR and stop Dependabot creating any more for this major version (unless you reopen the PR or upgrade to it yourself)@dependabot ignore this minor version will close this PR and stop Dependabot creating any more for this minor version (unless you reopen the PR or upgrade to it yourself)@dependabot ignore this dependency will close this PR and stop Dependabot creating any more for this dependency (unless you reopen the PR or upgrade to it yourself)
You can disable automated security fix PRs for this repo from the Security Alerts page.
</details>$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 "postgres-like" 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>See full diff in <a href="https://github.com/jackc/pgx/commits/v5.9.2">compare view</a></li>
</ul>
</details>
<br />Nothing published for this version
Nothing published for this version
Nothing published for this version
Nothing published for this version
Nothing published for this version
Nothing published for this version
Nothing published for this version
Nothing published for this version
Nothing published for this version
Nothing published for this version
Nothing published for this version
Nothing published for this version
Nothing published for this version
2881: Bug fixes: JSONB serialization/deserialization Fixes a customer reported issue where tables created with JSON columns before the introduction of
2876: Bug fixes for round tripping JSONB values with legacy ExtendedEnc format Schemas created before support for adaptive encoding use the EncodingEx
EncodingExt format and persist that in their schema. When reading JSONB values from this encoding, there were bugs when serializing JSON number values.…tps://docs.github.com/en/github/managing-security-vulnerabilities/about-dependabot-security-updates#about-compatibility-scores) Dependabot will resolv…
coalesce with a Doltgres-specific implementation
The coalesce implementation in GMS does not properly handle Doltgres types. This PR adds a small Doltgres-specific implementation that properly handles Doltgres types.
Fixes: https://github.com/dolthub/doltgresql/issues/2332dolt_backup() to backup and restore Doltgres databases. Also includes a fix for Doltgres specific objects, like sequences, to ensure they get included in backups.c.id).
By checking if a token is preceded by a dot (.), we can accurately skip variable substitution for field identifiers. A regression test for this specific issue has been added to create_function_plpgsql_test.go.CREATE CAST and DROP CAST, as well as fixes a number of bug that were surfaced by the tests (some fixed through other PRs, such as full type initialization, while others such as nested composite types in created functions are fixed here).DISTINCT with sort order in array_agg function
Fixes: https://github.com/dolthub/doltgresql/issues/2334JSONB use with dolt_patch()
Depends on: https://github.com/dolthub/dolt/pull/11153IndexNameGenerator interface
Extends PgDatabase with custom logic for generating index names in the same pattern as Postgres.
Depends on:
CREATE TEMPORARY TABLE ... ON COMMIT
Related to: https://github.com/dolthub/doltgresql/issues/2786collections were being reloaded twice for every query that involved looking up a table/view even if the RootValue hadn't changed. At the very least this PR should halve the number of LoadAllCollections.DoltgresDatabaseProvider
Adds DoltgresDatabaseProvider and PgDatabase that wrap types from Dolt and allow Doltgres to provide customized behavior.
I've spot checked the failing regression tests and they all appear to show existing problems that we weren't detecting before.
Depends on:
@dependabot rebase.
[//]: # (dependabot-automerge-start)
[//]: # (dependabot-automerge-end)@dependabot rebase will rebase this PR@dependabot recreate will recreate this PR, overwriting any edits that have been made to it@dependabot show <dependency name> ignore conditions will show all of the ignore conditions of the specified dependency@dependabot ignore this major version will close this PR and stop Dependabot creating any more for this major version (unless you reopen the PR or upgrade to it yourself)@dependabot ignore this minor version will close this PR and stop Dependabot creating any more for this minor version (unless you reopen the PR or upgrade to it yourself)@dependabot ignore this dependency will close this PR and stop Dependabot creating any more for this dependency (unless you reopen the PR or upgrade to it yourself)
You can disable automated security fix PRs for this repo from the Security Alerts page.
</details>@dependabot rebase.
[//]: # (dependabot-automerge-start)
[//]: # (dependabot-automerge-end)@dependabot rebase will rebase this PR@dependabot recreate will recreate this PR, overwriting any edits that have been made to it@dependabot show <dependency name> ignore conditions will show all of the ignore conditions of the specified dependency@dependabot ignore this major version will close this PR and stop Dependabot creating any more for this major version (unless you reopen the PR or upgrade to it yourself)@dependabot ignore this minor version will close this PR and stop Dependabot creating any more for this minor version (unless you reopen the PR or upgrade to it yourself)@dependabot ignore this dependency will close this PR and stop Dependabot creating any more for this dependency (unless you reopen the PR or upgrade to it yourself)
You can disable automated security fix PRs for this repo from the Security Alerts page.
</details>@dependabot rebase.
[//]: # (dependabot-automerge-start)
[//]: # (dependabot-automerge-end)@dependabot rebase will rebase this PR@dependabot recreate will recreate this PR, overwriting any edits that have been made to it@dependabot show <dependency name> ignore conditions will show all of the ignore conditions of the specified dependency@dependabot ignore this major version will close this PR and stop Dependabot creating any more for this major version (unless you reopen the PR or upgrade to it yourself)@dependabot ignore this minor version will close this PR and stop Dependabot creating any more for this minor version (unless you reopen the PR or upgrade to it yourself)@dependabot ignore this dependency will close this PR and stop Dependabot creating any more for this dependency (unless you reopen the PR or upgrade to it yourself)
You can disable automated security fix PRs for this repo from the Security Alerts page.
</details>$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 "postgres-like" 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>See full diff in <a href="https://github.com/jackc/pgx/commits/v5.9.2">compare view</a></li>
</ul>
</details>
<br />
You can trigger a rebase of this PR by commenting @dependabot rebase.
[//]: # (dependabot-automerge-start)
[//]: # (dependabot-automerge-end)@dependabot rebase will rebase this PR@dependabot recreate will recreate this PR, overwriting any edits that have been made to it@dependabot show <dependency name> ignore conditions will show all of the ignore conditions of the specified dependency@dependabot ignore this major version will close this PR and stop Dependabot creating any more for this major version (unless you reopen the PR or upgrade to it yourself)@dependabot ignore this minor version will close this PR and stop Dependabot creating any more for this minor version (unless you reopen the PR or upgrade to it yourself)@dependabot ignore this dependency will close this PR and stop Dependabot creating any more for this dependency (unless you reopen the PR or upgrade to it yourself)
You can disable automated security fix PRs for this repo from the Security Alerts page.
</details>Note Automatic rebases have been disabled on this pull request as it has been open for over 30 days.
ORDER BY on JSONB columns. Postgres has a particular b-tree order it uses to store JSON documents in order to efficient perform its lookups. Dolt's method for efficient JSON retrieval is quite different, and has nothing to do with the order in which documents are stored in a primary index.RETURNS TABLE (...)Nothing published for this version
Nothing published for this version
Nothing published for this version
Nothing published for this version
Nothing published for this version
Nothing published for this version
Nothing published for this version
Nothing published for this version
Nothing published for this version
Nothing published for this version
Nothing published for this version
Nothing published for this version
Nothing published for this version
Nothing published for this version
Nothing published for this version
Nothing published for this version
Nothing published for this version
Nothing published for this version
Nothing published for this version
Nothing published for this version
Nothing published for this version
Nothing published for this version
Nothing published for this version
One column per quarter.