@@ -13,40 +13,48 @@ Current release
1313Psycopg 3.2
1414^^^^^^^^^^^
1515
16+ .. rubric :: New top-level features
17+
1618- Add support for integer, floating point, boolean `NumPy scalar types `__
1719 (:ticket: `#332 `).
1820- Add `!timeout ` and `!stop_after ` parameters to `Connection.notifies() `
1921 (:ticket: `340 `).
2022- Allow dumpers to return `!None `, to be converted to NULL (:ticket: `#377 `).
2123- Add :ref: `raw-query-cursors ` to execute queries using placeholders in
2224 PostgreSQL format (`$1 `, `$2 `...) (:tickets: `#560, #839 `).
23- - Add `psycopg. capabilities ` object to :ref: `inspect the libpq capabilities
25+ - Add `capabilities ` object to :ref: `inspect the libpq capabilities
2426 <capabilities>` (:ticket: `#772 `).
2527- Add `~rows.scalar_row ` to return scalar values from a query (:ticket: `#723 `).
26- - Prepared statements are now :ref: `compatible with PgBouncer <pgbouncer >`.
27- (:ticket: `#589 `).
28+ - Add `~Connection.cancel_safe() ` for encrypted and non-blocking cancellation
29+ when using libpq v17. Use such method internally to implement
30+ `!KeyboardInterrupt ` and `~cursor.copy ` termination (:ticket: `#754 `).
31+ - The `!context ` parameter of `sql ` objects `~sql.Composable.as_string() ` and
32+ `~sql.Composable.as_bytes() ` methods is now optional (:ticket: `#716 `).
2833- Add `~Connection.set_autocommit() ` on sync connections, and similar
2934 transaction control methods available on the async connections.
35+ - Add a `size ` parameter to `~Cursor.stream() ` to enable results retrieval in
36+ chunks instead of row-by-row (:ticket: `#794 `).
37+
38+ .. rubric :: New libpq wrapper features
39+
3040- Add support for libpq functions to close prepared statements and portals
3141 introduced in libpq v17 (:ticket: `#603 `).
3242- Add support for libpq encrypted and non-blocking query cancellation
3343 functions introduced in libpq v17 (:ticket: `#754 `).
34- - The `!context ` parameter of `sql ` objects `~sql.Composable.as_string() ` and
35- `~sql.Composable.as_bytes() ` methods is now optional (:ticket: `#716 `).
44+ - Add support for libpq function to retrieve results in chunks introduced in
45+ libpq v17 (:ticket: `#793 `).
46+ - Add support for libpq function to change role passwords introduced in
47+ libpq v17 (:ticket: `#818 `).
48+
49+ .. rubric :: Other changes
50+
51+ - Prepared statements are now :ref: `compatible with PgBouncer <pgbouncer >`.
52+ (:ticket: `#589 `).
3653- Disable receiving more than one result on the same cursor in pipeline mode,
3754 to iterate through `~Cursor.nextset() `. The behaviour was different than
3855 in non-pipeline mode and not totally reliable (:ticket: `#604 `).
3956 The `Cursor ` now only preserves the results set of the last
4057 `~Cursor.execute() `, consistently with non-pipeline mode.
41- - Add `~Connection.cancel_safe() ` for encrypted and non-blocking cancellation
42- If possible, use such method internally upon `KeyboardInterrupt ` and `Copy `
43- termination (:ticket: `#754 `).
44- - Add support for libpq function to retrieve results in chunks introduced in
45- libpq v17 (:ticket: `#793 `).
46- - Add a `size ` parameter to `~Cursor.stream() ` to enable results retrieval by
47- chunks instead of row-by-row (:ticket: `#794 `).
48- - Add support for libpq function to change role passwords introduced in
49- libpq v17 (:ticket: `#818 `).
5058
5159.. __ : https://numpy.org/doc/stable/reference/arrays.scalars.html#built-in-scalar-types
5260
0 commit comments