- Update to 2.9.5
* Add support for Python 3.11.
* Add support for rowcount in MERGE statements in binary packages
(ticket`#1497`).
* Wheel package compiled against OpenSSL 1.1.1r and PostgreSQL 15 libpq.
- Update to 2.9.4
* Fix `~psycopg2.extras.register_composite()`,
`~psycopg2.extras.register_range()` with customized search_path
(ticket`#1487`).
* Handle correctly composite types with names or in schemas requiring escape.
* Find ``pg_service.conf file in the ``/etc/postgresql-common`` directory in
binary packages (ticket`1365`).
* `~psycopg2.errorcodes` map and `~psycopg2.errors` classes updated to
PostgreSQL 15.
* Wheel package compiled against OpenSSL 1.1.1q and PostgreSQL 14.4
OBS-URL: https://build.opensuse.org/request/show/1032036
OBS-URL: https://build.opensuse.org/package/show/devel:languages:python/python-psycopg2?expand=0&rev=85
- Update to 2.9.1
- Fix regression with named `sql.Placeholder` (🎫`1291`).
- Update to 2.9.0
- ``with connection`` starts a transaction on autocommit transactions too
(🎫`#941`).
- Timezones with fractional minutes are supported on Python 3.7 and following
(🎫`#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`) (🎫`#1148`).
- Include library dirs required from libpq to work around MacOS build problems
(🎫`#1200`).
- Dropped support for Python 2.7, 3.4, 3.5 (🎫`#1198, #1000, #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.
OBS-URL: https://build.opensuse.org/request/show/924846
OBS-URL: https://build.opensuse.org/package/show/devel:languages:python/python-psycopg2?expand=0&rev=82
- update to 2.8.6:
* Fixed memory leak changing connection encoding to the current one
* Fixed search of mxDateTime headers in virtualenvs (🎫`#996`).
* Added missing values from errorcodes (🎫`#1133`).
* `cursor.query` reports the query of the last :sql:`COPY` opearation too
* `~psycopg2.errorcodes` map and `~psycopg2.errors` classes updated to PostgreSQL 13.
* Added wheel packages for ARM architecture (🎫`#1125`).
* Wheel package compiled against OpenSSL 1.1.1g.
OBS-URL: https://build.opensuse.org/request/show/835010
OBS-URL: https://build.opensuse.org/package/show/openSUSE:Factory/python-psycopg2?expand=0&rev=37
* Fixed memory leak changing connection encoding to the current one
* Fixed search of mxDateTime headers in virtualenvs (🎫`#996`).
* Added missing values from errorcodes (🎫`#1133`).
* `cursor.query` reports the query of the last :sql:`COPY` opearation too
* `~psycopg2.errorcodes` map and `~psycopg2.errors` classes updated to PostgreSQL 13.
* Added wheel packages for ARM architecture (🎫`#1125`).
* Wheel package compiled against OpenSSL 1.1.1g.
OBS-URL: https://build.opensuse.org/package/show/devel:languages:python/python-psycopg2?expand=0&rev=80
- update to 2.8.4:
- Fixed building with Python 3.8 (🎫`#854`).
- Don't swallow keyboard interrupts on connect when a password is specified
in the connection string (🎫`#898`).
- Don't advance replication cursor when the message wasn't confirmed
(🎫`#940`).
- Fixed inclusion of ``time.h`` on linux (🎫`#951`).
- Fixed int overflow for large values in `~psycopg2.extensions.Column.table_oid`
and `~psycopg2.extensions.Column.type_code` (🎫`#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.
OBS-URL: https://build.opensuse.org/request/show/780392
OBS-URL: https://build.opensuse.org/package/show/openSUSE:Factory/python-psycopg2?expand=0&rev=32
- Fixed building with Python 3.8 (🎫`#854`).
- Don't swallow keyboard interrupts on connect when a password is specified
in the connection string (🎫`#898`).
- Don't advance replication cursor when the message wasn't confirmed
(🎫`#940`).
- Fixed inclusion of ``time.h`` on linux (🎫`#951`).
- Fixed int overflow for large values in `~psycopg2.extensions.Column.table_oid`
and `~psycopg2.extensions.Column.type_code` (🎫`#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.
OBS-URL: https://build.opensuse.org/package/show/devel:languages:python/python-psycopg2?expand=0&rev=70
- Update to 2.8.3
* Added interval_status parameter to start_replication() method
and other facilities to send automatic replication keepalives
at periodic intervals
* Fixed RealDictCursor when there are repeated columns
* Fixed RealDictRow modifiability
* Fixed “there’s no async cursor” error polling a connection with
no cursor
2.8.0
* Added errors module. Every PostgreSQL error is converted into
a specific exception class
* Added encrypt_password() function
* Added BYTES adapter to manage databases with mixed encodings on
Python 3
* Added table_oid and table_column attributes on cursor.description
items
* Added connection.info object to retrieve various PostgreSQL
connection information
* str() on Range produces a human-readable representation
* Fixed async communication blocking if results are returned in
different chunks
* Fixed adaptation of numeric subclasses such as IntEnum
* Dropped support for Python 2.6, 3.2, 3.3.
* Dropped deprecated register_tstz_w_secs()
* Dropped deprecated PersistentConnectionPool. 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.
OBS-URL: https://build.opensuse.org/request/show/707666
OBS-URL: https://build.opensuse.org/package/show/devel:languages:python/python-psycopg2?expand=0&rev=64
- Update to 2.7.7:
* Cleanup of the cursor results assignment code, which might have solved
double free and inconsistencies in concurrent usage (🎟️`#346, #384`).
* Close named cursors if exist, even if execute() wasn't called (ticket #746).
* Fixed building on modern FreeBSD versions with Python 3.7 (ticket #755).
* Fixed hang trying to COPY via execute() in asynchronous connections (ticket #781).
* Fixed adaptation of arrays of empty arrays (ticket #788).
* Fixed segfault accessing the connection.readonly and connection.deferrable attributes repeatedly (ticket #790).
* execute_values() accepts sql.Composable objects (ticket #794).
* errorcodes map updated to PostgreSQL 11.
* Allow non-ascii chars in namedtuple fields (regression introduced fixing ticket #211).
* Fixed adaptation of arrays of arrays of nulls (ticket #325).
* Fixed building on Solaris 11 and derivatives such as SmartOS and illumos (ticket #677).
* Maybe fixed building on MSYS2 (as reported in ticket #658).
* Allow string subclasses in connection and other places (ticket #679).
* Don't raise an exception closing an unused named cursor (ticket #716).
OBS-URL: https://build.opensuse.org/request/show/681339
OBS-URL: https://build.opensuse.org/package/show/openSUSE:Factory/python-psycopg2?expand=0&rev=27
* Cleanup of the cursor results assignment code, which might have solved
double free and inconsistencies in concurrent usage (🎟️`#346, #384`).
* Close named cursors if exist, even if execute() wasn't called (ticket #746).
* Fixed building on modern FreeBSD versions with Python 3.7 (ticket #755).
* Fixed hang trying to COPY via execute() in asynchronous connections (ticket #781).
* Fixed adaptation of arrays of empty arrays (ticket #788).
* Fixed segfault accessing the connection.readonly and connection.deferrable attributes repeatedly (ticket #790).
* execute_values() accepts sql.Composable objects (ticket #794).
* errorcodes map updated to PostgreSQL 11.
* Allow non-ascii chars in namedtuple fields (regression introduced fixing ticket #211).
* Fixed adaptation of arrays of arrays of nulls (ticket #325).
* Fixed building on Solaris 11 and derivatives such as SmartOS and illumos (ticket #677).
* Maybe fixed building on MSYS2 (as reported in ticket #658).
* Allow string subclasses in connection and other places (ticket #679).
* Don't raise an exception closing an unused named cursor (ticket #716).
OBS-URL: https://build.opensuse.org/package/show/devel:languages:python/python-psycopg2?expand=0&rev=60
- update to version 2.7.4:
- Moving away from installing the wheel package by default.
Packages installed from wheel raise a warning on import. Added package
``psycopg2-binary`` to install from wheel instead (🎫`#543`).
- Convert fields names into valid Python identifiers in
`~psycopg2.extras.NamedTupleCursor` (🎫`#211`).
- Fixed Solaris 10 support (🎫`#532`).
- `cursor.mogrify()` can be called on closed cursors (🎫`#579`).
- Fixed setting session characteristics in corner cases on autocommit
connections (🎫`#580`).
- Fixed `~psycopg2.extras.MinTimeLoggingCursor` on Python 3 (🎫`#609`).
- Fixed parsing of array of points as floats (🎫`#613`).
- Fixed `~psycopg2.__libpq_version__` building with libpq >= 10.1
(🎫`632`).
- Fixed `~cursor.rowcount` after `~cursor.executemany()` with :sql:`RETURNING`
statements (🎫`633`).
- Fixed compatibility problem with pypy3 (🎫`#649`).
- Wheel packages compiled against PostgreSQL 10.1 libpq and OpenSSL 1.0.2n.
- Wheel packages for Python 2.6 no more available (support dropped from
wheel building infrastructure).
- update to version 2.7.3.2:
- not relevant
- update to version 2.7.3.1:
- not relevant
OBS-URL: https://build.opensuse.org/request/show/578950
OBS-URL: https://build.opensuse.org/package/show/devel:languages:python/python-psycopg2?expand=0&rev=54
- update version to 2.7.3:
- Restored default :sql:`timestamptz[]` typecasting to Python `!datetime`.
Regression introduced in Psycopg 2.7.2 (🎫`#578`).
- Fixed inconsistent state in externally closed connections
(🎟️`#263, #311, #443`). Was fixed in 2.6.2 but not included in
2.7 by mistake.
- Fixed Python exceptions propagation in green callback (🎫`#410`).
- Don't display the password in `connection.dsn` when the connection
string is specified as an URI (🎫`#528`).
- Return objects with timezone parsing "infinity" :sql:`timestamptz`
(🎫`#536`).
- Dropped dependency on VC9 runtime on Windows binary packages
(🎫`#541`).
- Fixed segfault in `~connection.lobject()` when *mode*\=\ `!None`
(🎫`#544`).
- Fixed `~connection.lobject()` keyword argument *lobject_factory*
(🎫`#545`).
- Fixed `~psycopg2.extras.ReplicationCursor.consume_stream()`
*keepalive_interval* argument (🎫`#547`).
- Maybe fixed random import error on Python 3.6 in multiprocess
environment (🎫`#550`).
- Fixed random `!SystemError` upon receiving abort signal (🎫`#551`).
- Accept `~psycopg2.sql.Composable` objects in
`~psycopg2.extras.ReplicationCursor.start_replication_expert()`
(🎫`554`).
- Parse intervals returned as microseconds from Redshift (🎫`#558`).
- Added `~psycopg2.extras.Json` `!prepare()` method to consider connection
params when adapting (🎫`#562`).
- `~psycopg2.errorcodes` map updated to PostgreSQL 10 beta 1.
OBS-URL: https://build.opensuse.org/request/show/515213
OBS-URL: https://build.opensuse.org/package/show/devel:languages:python/python-psycopg2?expand=0&rev=52
* Fixed inconsistent state in externally closed connections (tickets #263, #311, #443).
* Report the server response status on errors (such as ticket #281).
* Raise NotSupportedError on unhandled server response status (ticket #352).
* Allow overriding string adapter encoding with no connection (ticket #331).
* The wait_select callback allows interrupting a long-running query in an interactive shell using Ctrl-C (ticket #333).
* Fixed PersistentConnectionPool on Python 3 (ticket #348).
* Fixed segfault on repr() of an uninitialized connection (ticket #361).
* Allow adapting bytes using QuotedString on Python 3 (ticket #365).
* Added support for setuptools/wheel (ticket #370).
* Fix build on Windows with Python 3.5, VS 2015 (ticket #380).
* Fixed errorcodes.lookup initialization thread-safety (ticket #382).
* Fixed read() exception propagation in copy_from (ticket #412).
* Fixed possible NULL TZ decref (ticket #424).
* errorcodes map updated to PostgreSQL 9.5.
* Lists consisting of only None are escaped correctly (ticket #285).
* Fixed deadlock in multithread programs using OpenSSL (ticket #290).
* Correctly unlock the connection after error in flush (ticket #294).
* Fixed MinTimeLoggingCursor.callproc() (ticket #309).
* Added support for MSVC 2015 compiler (ticket #350).
OBS-URL: https://build.opensuse.org/package/show/devel:languages:python/python-psycopg2?expand=0&rev=42
