89fa19de56
- update to 3.3.3: * Retain Error.pgconn when raising a single exception for multiple connection attempt errors * Return a proper error when server sends ErrorResponse for a Sync after a Parse
Dirk Mueller2026-02-23 08:44:35 +00:00
7045b19084
Accepting request 1329587 from devel:languages:python
Ana Guerrero2026-01-28 14:13:03 +00:00
7e93bafc29
- update to 3.3.2: * Add :ref:template strings queries <template-strings> (🎫#1054). * More flexible :ref:composite adaptation<adapt-composite>: it is now possible to adapt Python objects to PostgreSQL composites and back even if they are not sequences or if they take keyword arguments (🎫#932, 🎫#1202). * Cursors are now iterators, not just iterables. This means you can call next(cur) or anext(cur), which is useful as a :ref:type-safe expression <typing-fetchone> (🎫#1064). * Add Cursor.set_result() and Cursor.results() to move across the result sets of queries executed though ~Cursor.executemany() or ~Cursor.execute() with multiple statements (🎟️#1080, #1170). * Add :ref:transaction-status to report the status during and after a ~Connection.transaction() block (🎫#969). * Allow to change loaders using ~adapt.AdaptersMap.register_loader() on Cursor.adapters after a query result has been already returned (🎫#884). * Add pq.PGconn.used_gssapi attribute and Capabilities.has_used_gssapi() function (🎫#1138). * Add ConnectionInfo.full_protocol_version attribute, Capabilities.has_full_protocol_version() function (🎫#1079). * Disable default GSSAPI preferential connection in the binary package (🎫#1136). Warning Please explicitly set the gssencmode_ connection parameter or the :envvar:PGGSSENCMODE environment variable to interact reliably with the GSSAPI.
Dirk Mueller2026-01-27 07:38:13 +00:00
79e53bfe62
Accepting request 1318339 from devel:languages:python
Ana Guerrero2025-11-18 14:39:17 +00:00
fb77ebec9c
- update to 3.2.12: * Allow copy to pass different types per column, as long as the database can convert them. Regression introduced in 3.2.11 * Fix spurious readiness flags in some of the wait functions * Fix high CPU usage using the wait_c function on Windows * Fix bad data on error in binary copy (ticket #1147). * Respect Copy.set_types() in TEXT copy in C version, consistently with the Python version (ticket #1153). * Don’t raise warning, and don’t leak resources, if a builtin function is used as JSON dumper/loader function (ticket #1165). * Improve performance of Python conversion on results loading (ticket #1155).
Dirk Mueller2025-11-11 15:33:16 +00:00
8eababf5f7
Accepting request 1308108 from devel:languages:python
Ana Guerrero2025-09-30 15:41:40 +00:00
7c1c2a23ec
- update to 3.2.10: * Fix TypeError shadowing CancelledError upon task cancellation during pipeline execution (ticket #1005). * Fix memory leak when lambda/local functions are used as argument for set_json_dumps(), set_json_loads() (ticket #1108). * Fix coordination of executemany() with other concurrent operations on other cursors (ticket #1130). * Fix leak receiving notifications if the notifies() generator is not called (ticket #1091). * Using both the generator and handlers to receive notifications on the same connection is therefore deprecated and will now generate a runtime warning. * Add support for Python 3.14 (ticket #1053).
Dirk Mueller2025-09-29 21:11:15 +00:00
2c7face89f
- update to 3.2.9: * Fix DateFromTicks and TimeFromTicks return values to return a date and a time referred to the UTC timezone rather than to the local timezone. For consistency, TimestampFromTicks to return a datetime in UTC rather than in the local timezone * Fix ~Cursor.rownumber after using ~AsyncServerCursor.scroll() on AsyncServerCursor (🎫#1066). * Fix interval parsing with days or other parts and negative time in C module * Don't process further connection attempts after Ctrl-C * Fix cursors to correctly iterate over rows even if their row factory returns None (🎫#1073). * Fix ConnectionInfo.port when the port is specified as an empty string * Report all the attempts error messages in the exception raised for a connection failure (🎫#1069). * Improve logging on connection (🎫#1085). * Add support for PostgreSQL 18 libpq (🎫#1082). * Add SRID support to shapely dumpers/loaders (🎫#1028). * Add support for binary hstore (🎫#1030).
Dirk Mueller2025-05-29 09:46:43 +00:00
f4fa868854
Accepting request 1268071 from devel:languages:python
Ana Guerrero2025-04-10 19:58:35 +00:00
8033a44dac
Accepting request 1268045 from home:alarrosa:branches:devel:languages:python
Nico Krapp2025-04-09 08:54:54 +00:00
88a1a5514a
Accepting request 1223751 from devel:languages:python
Ana Guerrero2024-11-13 14:28:19 +00:00
51bb95d57a
- update to 3.2.3: * Release binary packages including PostgreSQL 17 libpq * Drop TypeDef specifications as string from public modules, as they cannot be composed by users as typing objects previously could (ticket #860). * Release Python 3.13 binary packages.
Dirk Mueller2024-11-12 16:30:37 +00:00
adaef5feff
- update to 3.2.1: * Fix packaging metadata breaking [c], [binary] dependencies * Add support for integer, floating point, boolean NumPy scalar types (ticket #332). * Add timeout and stop_after parameters to Connection.notifies() * Allow dumpers to return None, to be converted to NULL (ticket * Add Raw query cursors to execute queries using placeholders in PostgreSQL format ($1, $2…) (tickets #560, #839). * Add capabilities object to inspect the libpq capabilities * Add scalar_row to return scalar values from a query * Add cancel_safe() for encrypted and non-blocking cancellation when using libpq v17. Use such method internally to implement KeyboardInterrupt and copy termination * The context parameter of sql objects as_string() and as_bytes() methods is now optional * Add set_autocommit() on sync connections, and similar transaction control methods available on the async connections. * Add a size parameter to stream() to enable results retrieval in chunks instead of row-by-row ------------------------------------------------------------------
Dirk Mueller2024-08-31 12:28:28 +00:00
e0bd4651c9
Accepting request 1174407 from devel:languages:python
Ana Guerrero2024-05-16 15:16:23 +00:00
d677bcb999
- update to 3.1.19: * Fix unaligned access undefined behaviour in C extension (ticket #734). * Fix excessive stripping of error message prefixes (ticket #752). * Allow to specify the connect_timeout connection parameter as float (ticket #796). * Improve COPY performance on macOS (ticket #745).
Dirk Mueller2024-05-16 08:38:12 +00:00
bdf2f8358b
Accepting request 1158426 from devel:languages:python
Ana Guerrero2024-03-17 21:14:45 +00:00
800873575d
- update to 3.1.18: * Fix possible deadlock on pipeline exit (ticket #685). * Fix overflow loading large intervals in C module (ticket #719). * Fix compatibility with musl libc distributions affected by CPython issue #65821 (ticket #725).
Dirk Mueller2024-03-16 09:44:45 +00:00
aa006bb96c
Accepting request 1138870 from devel:languages:python
Ana Guerrero2024-01-15 21:15:37 +00:00
840e074d8c
Accepting request 1138839 from home:alarrosa:branches:devel:languages:python
Markéta Machová2024-01-15 14:03:43 +00:00
7b62420ad9
- update to 3.1.16: * version only update
Dirk Mueller2024-01-05 17:49:58 +00:00
eeb84410a9
Accepting request 1133195 from devel:languages:python
Ana Guerrero2023-12-15 20:48:25 +00:00
479590ee1c
- update to 3.1.15: * Fix use of service in connection string * Fix async connection to hosts resolving to multiple IP addresses * Respect the PGCONNECT_TIMEOUT environment variable to determine the connection timeout. * Psycopg 3.1.14 * Fix interaction with gevent (ticket #527). * Add support for PyPy (ticket #686). - Initial release of 3.1.9
Dirk Mueller2023-12-14 21:11:14 +00:00
90b99d9dc9
Accepting request 1128591 from devel:languages:python
Ana Guerrero2023-11-24 22:35:14 +00:00
408df0f436
Accepting request 1128588 from home:alarrosa:branches:devel:languages:python
Dirk Mueller2023-11-24 14:08:37 +00:00
622a6e81de
Accepting request 1098280 from devel:languages:python
Ana Guerrero2023-07-17 17:22:59 +00:00
Ana Guerrero
Dirk Mueller
Dominique Leuenberger
Nico Krapp
Markéta Machová
Steve Kowalik