- update to 2.9.7:
* Fix propagation of exceptions raised during module
initialization
* Fix building when pg_config returns an empty string
- Update to 2.9.5
* Alpine (musl) wheels now available
- update to 2.8.5
* Added interval_status parameter to start_replication() method
and other facilities to send automatic replication keepalives
* Fixed “there’s no async cursor” error polling a connection with
* Added errors module. Every PostgreSQL error is converted into
* Added BYTES adapter to manage databases with mixed encodings on
* Added table_oid and table_column attributes on cursor.description
* Added connection.info object to retrieve various PostgreSQL
* Fixed async communication blocking if results are returned in
* Dropped deprecated PersistentConnectionPool. Use
* Binary packages no longer installed by default. The
* Added Replication protocol support (ticket #322). Main authors are
* Added parse_dsn() and make_dsn() functions (tickets #321, #363). connect()
* Added __libpq_version__ and libpq_version() to inspect the version of the
* The attributes notices and notifies can be customized replacing them with
* Adapt network types to ipaddress objects when available. When not enabled,
convert arrays of network types to lists by default. The old Inet adapter is
* Give precedence to __conform__() over superclasses to choose an object
* Using Python C API decoding functions and codecs caching for faster
* executemany() slowness addressed by execute_batch() and execute_values()
* Added async_ as an alias for async to support Python 3.7 where async will
* Unless in autocommit, do not use default_transaction_* settings to control
the session characteristics as it may create problems with external
OBS-URL: https://build.opensuse.org/request/show/1109514
OBS-URL: https://build.opensuse.org/package/show/openSUSE:Factory/python-psycopg2?expand=0&rev=44
* Fix propagation of exceptions raised during module
initialization
* Fix building when pg_config returns an empty string
- Update to 2.9.5
* Alpine (musl) wheels now available
- update to 2.8.5
* Added interval_status parameter to start_replication() method
and other facilities to send automatic replication keepalives
* Fixed “there’s no async cursor” error polling a connection with
* Added errors module. Every PostgreSQL error is converted into
* Added BYTES adapter to manage databases with mixed encodings on
* Added table_oid and table_column attributes on cursor.description
* Added connection.info object to retrieve various PostgreSQL
* Fixed async communication blocking if results are returned in
* Dropped deprecated PersistentConnectionPool. Use
* Binary packages no longer installed by default. The
* Added Replication protocol support (ticket #322). Main authors are
* Added parse_dsn() and make_dsn() functions (tickets #321, #363). connect()
* Added __libpq_version__ and libpq_version() to inspect the version of the
* The attributes notices and notifies can be customized replacing them with
* Adapt network types to ipaddress objects when available. When not enabled,
convert arrays of network types to lists by default. The old Inet adapter is
* Give precedence to __conform__() over superclasses to choose an object
* Using Python C API decoding functions and codecs caching for faster
* executemany() slowness addressed by execute_batch() and execute_values()
* Added async_ as an alias for async to support Python 3.7 where async will
* Unless in autocommit, do not use default_transaction_* settings to control
the session characteristics as it may create problems with external
* isolation_level is now writable and entirely separated from autocommit;
OBS-URL: https://build.opensuse.org/package/show/devel:languages:python/python-psycopg2?expand=0&rev=91
- 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
