Tags: won087/psycopg2
Tags
Psycopg 2.9 released What's new in psycopg 2.9 ------------------------- - ``with connection`` starts a transaction on autocommit transactions too (:ticket:`psycopg#941`). - Timezones with fractional minutes are supported on Python 3.7 and following (:ticket:`psycopg#1272`). - Escape table and column names in `~cursor.copy_from()` and `~cursor.copy_to()`. - Connection exceptions with sqlstate ``08XXX`` reclassified as `~psycopg2.OperationalError` (a subclass of the previously used `~psycopg2.DatabaseError`) (:ticket:`psycopg#1148`). - Include library dirs required from libpq to work around MacOS build problems (:ticket:`psycopg#1200`). Other changes: - Dropped support for Python 2.7, 3.4, 3.5 (:tickets:`psycopg#1198, psycopg#1000, psycopg#1197`). - Dropped support for mx.DateTime. - Use `datetime.timezone` objects by default in datetime objects instead of `~psycopg2.tz.FixedOffsetTimezone`. - The `psycopg2.tz` module is deprecated and scheduled to be dropped in the next major release. - Provide :pep:`599` wheels packages (manylinux2014 tag) for i686 and x86_64 platforms. - Provide :pep:`600` wheels packages (manylinux_2_24 tag) for aarch64 and ppc64le platforms. - Wheel package compiled against OpenSSL 1.1.1k and PostgreSQL 13.3. - Build system for Linux/MacOS binary packages moved to GitHub action.
Psycopg 2.8.6 released What's new in psycopg 2.8.6 --------------------------- New features: - Fixed memory leak changing connection encoding to the current one (:ticket:`psycopg#1101`). - Fixed search of mxDateTime headers in virtualenvs (:ticket:`psycopg#996`). - Added missing values from errorcodes (:ticket:`psycopg#1133`). - `cursor.query` reports the query of the last :sql:`COPY` opearation too (🎫`psycopg#1141`). - `~psycopg2.errorcodes` map and `~psycopg2.errors` classes updated to PostgreSQL 13. - Added wheel packages for ARM architecture (:ticket:`psycopg#1125`). - Wheel package compiled against OpenSSL 1.1.1g.
Psycopg 2.8.5 released What's new in psycopg 2.8.5 ^^^^^^^^^^^^^^^^^^^^^^^^^^^ - Fixed use of `!connection_factory` and `!cursor_factory` together (:ticket:`psycopg#1019`). - Added support for `~logging.LoggerAdapter` in `~psycopg2.extras.LoggingConnection` (:ticket:`psycopg#1026`). - `~psycopg2.extensions.Column` objects in `cursor.description` can be sliced (:ticket:`psycopg#1034`). - Added AIX support (:ticket:`psycopg#1061`). - Fixed `~copy.copy()` of `~psycopg2.extras.DictCursor` rows (:ticket:`psycopg#1073`).
Psycopg 2.8.4 released What's new in psycopg 2.8.4 ^^^^^^^^^^^^^^^^^^^^^^^^^^^ - Fixed building with Python 3.8 (:ticket:`psycopg#854`). - Don't swallow keyboard interrupts on connect when a password is specified in the connection string (:ticket:`psycopg#898`). - Don't advance replication cursor when the message wasn't confirmed (:ticket:`psycopg#940`). - Fixed inclusion of ``time.h`` on linux (:ticket:`psycopg#951`). - Fixed int overflow for large values in `~psycopg2.extensions.Column.table_oid` and `~psycopg2.extensions.Column.type_code` (:ticket:`psycopg#961`). - `~psycopg2.errorcodes` map and `~psycopg2.errors` classes updated to PostgreSQL 12. - Wheel package compiled against OpenSSL 1.1.1d and PostgreSQL at least 11.4.
Psycopg 2.8.3 released What's new in psycopg 2.8.3 --------------------------- - Added *interval_status* parameter to `~psycopg2.extras.ReplicationCursor.start_replication()` method and other facilities to send automatic replication keepalives at periodic intervals (:ticket:`psycopg#913`). - Fixed namedtuples caching introduced in 2.8 (:ticket:`psycopg#928`).
Psycopg 2.8.2 released What's new in psycopg 2.8.2 --------------------------- - Fixed `~psycopg2.extras.RealDictCursor` when there are repeated columns (:ticket:`psycopg#884`). - Binary packages built with openssl 1.1.1b. Should fix concurrency problems (:tickets:`psycopg#543, psycopg#836`).
Psycopg 2.8.1 released What's new in psycopg 2.8.1 --------------------------- - Fixed `RealDictRow` modifiability (:ticket:`psycopg#886`). - Fixed "there's no async cursor" error polling a connection with no cursor (:ticket:`psycopg#887`).
Psycopg 2.8 released What's new in psycopg 2.8 ------------------------- New features: - Added `~psycopg2.errors` module. Every PostgreSQL error is converted into a specific exception class (:ticket:`psycopg#682`). - Added `~psycopg2.extensions.encrypt_password()` function (:ticket:`psycopg#576`). - Added `~psycopg2.extensions.BYTES` adapter to manage databases with mixed encodings on Python 3 (:ticket:`psycopg#835`). - Added `~psycopg2.extensions.Column.table_oid` and `~psycopg2.extensions.Column.table_column` attributes on `cursor.description` items (:ticket:`psycopg#661`). - Added `connection.info` object to retrieve various PostgreSQL connection information (:ticket:`psycopg#726`). - Added `~connection.get_native_connection()` to expose the raw ``PGconn`` structure to C extensions via Capsule (:ticket:`psycopg#782`). - Added `~connection.pgconn_ptr` and `~cursor.pgresult_ptr` to expose raw C structures to Python and interact with libpq via ctypes (:ticket:`psycopg#782`). - `~psycopg2.sql.Identifier` can represent qualified names in SQL composition (:ticket:`psycopg#732`). - Added `!ReplicationCursor`.\ `~psycopg2.extras.ReplicationCursor.wal_end` attribute (:ticket:`psycopg#800`). - Added *fetch* parameter to `~psycopg2.extras.execute_values()` function (:ticket:`psycopg#813`). - `!str()` on `~psycopg2.extras.Range` produces a human-readable representation (:ticket:`psycopg#773`). - `~psycopg2.extras.DictCursor` and `~psycopg2.extras.RealDictCursor` rows maintain columns order (:ticket:`psycopg#177`). - Added `~psycopg2.extensions.Diagnostics.severity_nonlocalized` attribute on the `~psycopg2.extensions.Diagnostics` object (:ticket:`psycopg#783`). - More efficient `~psycopg2.extras.NamedTupleCursor` (:ticket:`psycopg#838`). Bug fixes: - Fixed connections occasionally broken by the unrelated use of the multiprocessing module (:ticket:`psycopg#829`). - Fixed async communication blocking if results are returned in different chunks, e.g. with notices interspersed to the results (:ticket:`psycopg#856`). - Fixed adaptation of numeric subclasses such as `~enum.IntEnum` (:ticket:`psycopg#591`). Other changes: - Dropped support for Python 2.6, 3.2, 3.3. - Dropped `psycopg1` module. - Dropped deprecated `!register_tstz_w_secs()` (was previously a no-op). - Dropped deprecated `!PersistentConnectionPool`. This pool class was mostly designed to interact with Zope. Use `!ZPsycopgDA.pool` instead. - Binary packages no longer installed by default. The 'psycopg2-binary' package must be used explicitly. - Dropped `!PSYCOPG_DISPLAY_SIZE` build parameter. - Dropped support for mxDateTime as the default date and time adapter. mxDatetime support continues to be available as an alternative to Python's builtin datetime. - No longer use 2to3 during installation for Python 2 & 3 compatibility. All source files are now compatible with Python 2 & 3 as is. - The `!psycopg2.test` package is no longer installed by ``python setup.py install``. - Wheel package compiled against OpenSSL 1.0.2r and PostgreSQL 11.2 libpq.
Psycopg 2.8 beta 2 released What's new in psycopg 2.8 ------------------------- New features: - Added `~psycopg2.errors` module. Every PostgreSQL error is converted into a specific exception class (:ticket:`psycopg#682`). - Added `~psycopg2.extensions.encrypt_password()` function (:ticket:`psycopg#576`). - Added `~psycopg2.extensions.BYTES` adapter to manage databases with mixed encodings on Python 3 (:ticket:`psycopg#835`). - Added `~psycopg2.extensions.Column.table_oid` and `~psycopg2.extensions.Column.table_column` attributes on `cursor.description` items (:ticket:`psycopg#661`). - Added `connection.info` object to retrieve various PostgreSQL connection information (:ticket:`psycopg#726`). - Added `~connection.get_native_connection()` to expose the raw ``PGconn`` structure to C extensions via Capsule (:ticket:`psycopg#782`). - Added `~connection.pgconn_ptr` and `~cursor.pgresult_ptr` to expose raw C structures to Python and interact with libpq via ctypes (:ticket:`psycopg#782`). - `~psycopg2.sql.Identifier` can represent qualified names in SQL composition (:ticket:`psycopg#732`). - Added *fetch* parameter to `~psycopg2.extras.execute_values()` function (:ticket:`psycopg#813`). - `!str()` on `~psycopg2.extras.Range` produces a human-readable representation (:ticket:`psycopg#773`). - `~psycopg2.extras.DictCursor` and `~psycopg2.extras.RealDictCursor` rows maintain columns order (:ticket:`psycopg#177`). - Added `~psycopg2.extensions.Diagnostics.severity_nonlocalized` attribute on the `~psycopg2.extensions.Diagnostics` object (:ticket:`psycopg#783`). - More efficient `~psycopg2.extras.NamedTupleCursor` (:ticket:`psycopg#838`). Bug fixes: - Fixed connections occasionally broken by the unrelated use of the multiprocessing module (:ticket:`psycopg#829`). - Fixed async communication blocking if results are returned in different chunks, e.g. with notices interspersed to the results (:ticket:`psycopg#856`). - Fixed adaptation of numeric subclasses such as `~enum.IntEnum` (:ticket:`psycopg#591`). Other changes: - Dropped support for Python 2.6, 3.2, 3.3. - Dropped `psycopg1` module. - Dropped deprecated `!register_tstz_w_secs()` (was previously a no-op). - Dropped deprecated `!PersistentConnectionPool`. This pool class was mostly designed to interact with Zope. Use `!ZPsycopgDA.pool` instead. - Binary packages no longer installed by default. The 'psycopg2-binary' package must be used explicitly. - Dropped `!PSYCOPG_DISPLAY_SIZE` build parameter. - Dropped support for mxDateTime as the default date and time adapter. mxDatetime support continues to be available as an alternative to Python's builtin datetime. - No longer use 2to3 during installation for Python 2 & 3 compatibility. All source files are now compatible with Python 2 & 3 as is. - The `!psycopg2.test` package is no longer installed by ``python setup.py install``. - Wheel package compiled against OpenSSL 1.0.2r and PostgreSQL 11.2 libpq.
PreviousNext