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)).
Add support for libpq function to change role passwords introduced in
libpq v17 (:ticket:[#818](https://github.com/psycopg/psycopg/issues/818)).
You can trigger a rebase of this PR 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)
Bumps psycopg from 3.1.17 to 3.1.19.
Changelog
Sourced from psycopg's changelog.
... (truncated)
Commits
780068d
chore: bump psycopg package version to 3.1.19040489c
chore(crdb): upgrade types to v23.1163f366
ci(macos): test and build macOS packages on M1 runners01d5dab
Merge branch 'fix-745' into maint-3.128fc73e
perf(copy): only flush at every row on copy on macOS963c5f8
Improve performance of copyc9486b3
test(copy): add minimal copy benchmark framework3398945
Merge branch 'fix-734' into maint-3.1cfc0782
fix(c): solve undefined behaviour caused by unaligned access611738f
ci: add test to check for misaligned memory accessYou can trigger a rebase of this PR 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