Bump psycopg from 3.1.18 to 3.1.19

[dependabot[bot]]

Bumps psycopg from 3.1.18 to 3.1.19.

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

Current release

... (truncated)

Commits

• 780068d chore: bump psycopg package version to 3.1.19
• 040489c chore(crdb): upgrade types to v23.1
• 163f366 ci(macos): test and build macOS packages on M1 runners
• 01d5dab Merge branch 'fix-745' into maint-3.1
• 28fc73e perf(copy): only flush at every row on copy on macOS
• 963c5f8 Improve performance of copy
• c9486b3 test(copy): add minimal copy benchmark framework
• 3398945 Merge branch 'fix-734' into maint-3.1
• cfc0782 fix(c): solve undefined behaviour caused by unaligned access
• 611738f ci: add test to check for misaligned memory access
• 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)