Bump psycopg from 3.1.8 to 3.1.18

[dependabot[bot]]

Bumps psycopg from 3.1.8 to 3.1.18.

Changelog

Sourced from psycopg's changelog.

.. currentmodule:: psycopg

.. index:: single: Release notes single: News

psycopg release notes

Future releases

Psycopg 3.2 (unreleased) ^^^^^^^^^^^^^^^^^^^^^^^^

• Add support for integer, floating point, boolean NumPy scalar types__ (:ticket:[#332](https://github.com/psycopg/psycopg/issues/332)).
• Add !timeout and !stop_after parameters to Connection.notifies() (:ticket:340).
• Add :ref:raw-query-cursors to execute queries using placeholders in PostgreSQL format ($1, $2...) (:ticket:[#560](https://github.com/psycopg/psycopg/issues/560)).
• Add psycopg.capabilities object to :ref:inspect the libpq capabilities <capabilities> (:ticket:[#772](https://github.com/psycopg/psycopg/issues/772)).
• Add ~rows.scalar_row to return scalar values from a query (:ticket:[#723](https://github.com/psycopg/psycopg/issues/723)).
• Prepared statements are now :ref:compatible with PgBouncer <pgbouncer>. (:ticket:[#589](https://github.com/psycopg/psycopg/issues/589)).
• Add ~Connection.set_autocommit() on sync connections, and similar transaction control methods available on the async connections.
• Add support for libpq functions to close prepared statements and portals introduced in libpq v17 (:ticket:[#603](https://github.com/psycopg/psycopg/issues/603)).
• Add support for libpq encrypted and non-blocking query cancellation functions introduced in libpq v17 (:ticket:[#754](https://github.com/psycopg/psycopg/issues/754)).
• The !context parameter of sql objects ~sql.Composable.as_string() and ~sql.Composable.as_bytes() methods is now optional (:ticket:[#716](https://github.com/psycopg/psycopg/issues/716)).
• Disable receiving more than one result on the same cursor in pipeline mode, to iterate through ~Cursor.nextset(). The behaviour was different than in non-pipeline mode and not totally reliable (:ticket:[#604](https://github.com/psycopg/psycopg/issues/604)). The Cursor now only preserves the results set of the last ~Cursor.execute(), consistently with non-pipeline mode.
• Add ~Connection.cancel_safe() for encrypted and non-blocking cancellation If possible, use such method internally upon KeyboardInterrupt and Copy termination (:ticket:[#754](https://github.com/psycopg/psycopg/issues/754)).
• Add support for libpq function to retrieve results in chunks introduced in libpq v17 (:ticket:[#793](https://github.com/psycopg/psycopg/issues/793)).

.. __: https://numpy.org/doc/stable/reference/arrays.scalars.html#built-in-scalar-types

Psycopg 3.1.19 (unreleased) ^^^^^^^^^^^^^^^^^^^^^^^^^^^

... (truncated)

Commits

• 8585a23 chore: bump psycopg package version to 3.1.18
• ab646b7 fix(c): drop spurious loop break in pipeline_communicate
• bebfe97 chore: bump cibuildwheel version
• 89394a6 chore: bump checkout action to v4
• ed579e5 docs: fix tickets format
• d4a4e8e Merge branch 'musl-ctypes' into maint-3.1
• 8bc51e6 docs: mention musl-ctypes workaround in news file
• afb040a fix: add libc.so fallback for musl systems to the ctypes impl
• 06ef0d9 test: drop ineffective marker on fixture
• b955118 Merge branch 'fix-interval-overflow' into maint-3.1
• Additional commits viewable in compare view

Dependabot will resolve any conflicts with this PR as long as you don't alter it yourself. You can also trigger a rebase manually by commenting @dependabot rebase.

---

Dependabot commands and options

You can trigger Dependabot actions by commenting on this PR: - `@dependabot rebase` will rebase this PR - `@dependabot recreate` will recreate this PR, overwriting any edits that have been made to it - `@dependabot merge` will merge this PR after your CI passes on it - `@dependabot squash and merge` will squash and merge this PR after your CI passes on it - `@dependabot cancel merge` will cancel a previously requested merge and block automerging - `@dependabot reopen` will reopen this PR if it is closed - `@dependabot close` will close this PR and stop Dependabot recreating it. You can achieve the same result by closing it manually - `@dependabot show 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)

[dependabot[bot]]

Superseded by #860.