Skip to content

deps: update psycopg2-binary requirement from >=2.9 to >=2.9.12 - #24

Open
dependabot[bot] wants to merge 1 commit into
masterfrom
dependabot/pip/psycopg2-binary-gte-2.9.12
Open

dependabot[bot] wants to merge 1 commit into
masterfrom
dependabot/pip/psycopg2-binary-gte-2.9.12

Conversation

@dependabot

@dependabot dependabot Bot commented on behalf of github Jul 31, 2026

Copy link
Copy Markdown
Contributor

Updates the requirements on psycopg2-binary to permit the latest version.

Changelog

Sourced from psycopg2-binary's changelog.

Current release

What's new in psycopg 2.9.12 ^^^^^^^^^^^^^^^^^^^^^^^^^^^^

  • Fix infinite loop with malformed interval (:ticket:1835).

What's new in psycopg 2.9.11 ^^^^^^^^^^^^^^^^^^^^^^^^^^^^

  • Add support for Python 3.14.
  • Avoid a segfault passing more arguments than placeholders if Python is built with assertions enabled (:ticket:[#1791](https://github.com/psycopg/psycopg2/issues/1791)).
  • Add riscv64 platform binary packages (:ticket:[#1813](https://github.com/psycopg/psycopg2/issues/1813)).
  • ~psycopg2.errorcodes map and ~psycopg2.errors classes updated to PostgreSQL 18.
  • Drop support for Python 3.8.

What's new in psycopg 2.9.10 ^^^^^^^^^^^^^^^^^^^^^^^^^^^^

  • Add support for Python 3.13.
  • Receive notifications on commit (:ticket:[#1728](https://github.com/psycopg/psycopg2/issues/1728)).
  • ~psycopg2.errorcodes map and ~psycopg2.errors classes updated to PostgreSQL 17.
  • Drop support for Python 3.7.

What's new in psycopg 2.9.9 ^^^^^^^^^^^^^^^^^^^^^^^^^^^

  • Add support for Python 3.12.
  • Drop support for Python 3.6.

What's new in psycopg 2.9.8 ^^^^^^^^^^^^^^^^^^^^^^^^^^^

  • Wheel package bundled with PostgreSQL 16 libpq in order to add support for recent features, such as sslcertmode.

What's new in psycopg 2.9.7 ^^^^^^^^^^^^^^^^^^^^^^^^^^^

  • Fix propagation of exceptions raised during module initialization (:ticket:[#1598](https://github.com/psycopg/psycopg2/issues/1598)).

... (truncated)

Commits
  • 3a6d9d6 ci: include almalinux in whieel building
  • ebca6bf chore: bump to version 3.9.12
  • 0196f02 build(deps): bump pypa/cibuildwheel from 3.3.1 to 3.4.0
  • d157bdc build(deps): bump docker/setup-qemu-action from 3 to 4
  • 7fccc0f build(deps): bump actions/upload-artifact from 6 to 7
  • d52a61e chore: bump dependency libraries
  • b231d72 chore: fix building binary images
  • 6d76e84 Merge pull request #1836 from psycopg/fix-1835
  • f7e314c fix: overflow in malformed interval
  • eb905c1 docs: replace bare except clause with except Exception
  • 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.

@dependabot @github

dependabot Bot commented on behalf of github Jul 31, 2026

Copy link
Copy Markdown
Contributor Author

Labels

The following labels could not be found: dependencies. Please create it before Dependabot can add it to a pull request.

Please fix the above issues or remove invalid values from dependabot.yml.

fingoldo added a commit that referenced this pull request Jul 31, 2026
Repo had 3 open dependabot PRs sitting unmerged (#22 github-actions bump,
#23 ruff bump, #24 psycopg2-binary bump) despite CI already running green
on all of them -- nothing was wired to actually merge them.

Enabled `allow_auto_merge` at the repo level (was false) and added a
workflow that: parses the PR title's "from X.Y.Z to A.B.C" version pair,
and for same-major (minor/patch) bumps calls `gh pr merge --auto --squash`.
A major-version bump, or a title GitHub's own bump-PR format doesn't match,
is left for manual review -- dependabot can't assess whether a major bump
is actually safe.

Deliberately `pull_request` (not `pull_request_target`) and a
`user.login`-based bot check (not the spoofable `github.actor`) -- every
dependabot branch lives in this repo, never a fork, so pull_request_target's
fork-secrets-exposure surface buys nothing here; zizmor confirms 0 findings.

Deliberately no branch-protection required-checks rule added: this repo's
established workflow allows direct pushes to master, and required-checks
would block that. GitHub's native auto-merge already waits for every
check currently running on the PR to succeed before merging, so it gates
on CI without touching branch protection.

Verified: yamllint clean, actionlint clean, zizmor 0 findings (was 2 high
before switching off pull_request_target + the actor check).
Updates the requirements on [psycopg2-binary](https://github.com/psycopg/psycopg2) to permit the latest version.
- [Changelog](https://github.com/psycopg/psycopg2/blob/master/NEWS)
- [Commits](psycopg/psycopg2@2.9.6...2.9.12)

---
updated-dependencies:
- dependency-name: psycopg2-binary
  dependency-version: 2.9.12
  dependency-type: direct:development
...

Signed-off-by: dependabot[bot] <support@github.com>
@dependabot
dependabot Bot force-pushed the dependabot/pip/psycopg2-binary-gte-2.9.12 branch from d4b6f00 to f80f8a6 Compare July 31, 2026 23:23
fingoldo added a commit that referenced this pull request Sep 9, 2026
Every one of these was measured by the pip-audit-over-the-lock job added earlier this round, and none of
them was visible before it: pip-audit ran only in the advisory bundle, over the developer's INSTALLED
environment rather than what the project declares, and its output was nobody's assigned reading.

  aiohttp   >=3.14.1 -> >=3.14.3   PYSEC-2026-3545, -3546, -3547
  tornado   >=6.5.7  -> >=6.5.8    GHSA-wwv5-g3v4-889x, GHSA-8423-8fgw-73vq, CVE-2026-82397

psycopg2-binary's floor moves >=2.9 -> >=2.9.12 in the same pass. That one is not a security fix; it is a
floor that had drifted far enough to assert nothing.

The lock diff is three specifier lines and no resolved version at all: every one of these was already
resolving above the old floor, so the change closes the gap between what the project CLAIMS to support and
what it actually installs, without moving a single package. That is the whole point of a floor -- it is a
promise to users on older environments, and an unverified promise is what these had become.

These three changes are what dependabot PRs #27, #24 and #32 carry. They are applied here rather than by
merging those PRs because the PRs cannot land as they are: their checks belong to the August matrix (eight
shards, Python 3.10-3.12) that no longer exists, their heads are far behind master, and auto-merge is not
enabled on them. Updating them needs a `@dependabot rebase` comment, which is not mine to post. They will
close themselves as superseded on dependabot's next run.

There is also a reason not to merge them even if they could land: they were opened under the `pip`
ecosystem, which does not know uv.lock exists. Merging one would change pyproject.toml and leave the lock
describing the previous graph -- failing the `uv lock --check` gate immediately. That is exactly why the
ecosystem moved to `uv` earlier in this round; from now on a bump and its lock arrive together.

This branch has not been deployed

No deployments
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Labels

None yet

Projects

None yet

Development

Successfully merging this pull request may close these issues.

0 participants