- 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
- Added JSON adaptation.
- Added support for PostgreSQL 9.2 range types.
- `connection` and `cursor` objects can be used in ``with`` statements as
context managers as specified by recent DBAPI extension.
- Added `psycopg2.extensions.Diagnostics` object to get extended info from
a database error. Many thanks to Matthew Woodcraft for the implementation
(ticket #149).
- Added `connection.cursor_factory` attribute to customize the default
object returned by `connection.cursor()`.
- Added support for backward scrollable cursors. Thanks to Jon Nelson for
the initial patch (ticket #108).
- Added a simple way to customize casting of composite types into Python
objects other than namedtuples. Many thanks to Ronan Dunklau and Tobias
Oberstein for the feature development.
- `connection.reset()` implemented using `DISCARD ALL` on server versions
supporting it.
- Properly cleanup memory of broken connections (ticket #148).
- Fixed bad interaction of ``setup.py`` with other dependencies in
Distribute projects on Python 3 (ticket #153).
- Added support for Python 3.3.
- Dropped support for Python 2.4. Please use Psycopg 2.4.x if you need it.
- `psycopg2.errorcodes` map updated to PostgreSQL 9.2.
- Dropped Zope adapter from source repository. ZPsycopgDA now has its own
project at <http://github.com/psycopg/ZPsycopgDA>.
- Changes from 2.4.6:
- Fixed 'cursor()' arguments propagation in connection subclasses and
overriding of the 'cursor_factory' argument. Thanks to Corry Haines for
the report and the initial patch (ticket #105).
- Dropped GIL release during string adaptation around a function call
OBS-URL: https://build.opensuse.org/package/show/devel:languages:python/python-psycopg2?expand=0&rev=36
