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.

Psycopg 2.8 beta 1 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 (: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`).
- Fixed adaptation of numeric subclasses such as `~enum.IntEnum`
  (:ticket:`psycopg#591`).
- `!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`).

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.
- Dropped `!PSYCOPG_DISPLAY_SIZE` build parameter.
- No longer use 2to3 during installation for Python 2 & 3 compatability. 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``.

Psycopg 2.7 released

What's new in psycopg 2.7.7
---------------------------

- Cleanup of the cursor results assignment code, which might have solved
  double free and inconsistencies in concurrent usage (:tickets:`psycopg#346, psycopg#384`).
- Wheel package compiled against OpenSSL 1.0.2q.

Psycopg 2.7.6.1 released

What's new in psycopg 2.7.6.1
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

- Fixed binary package broken on OS X 10.12 (:ticket:`psycopg#807`).
- Wheel package compiled against PostgreSQL 11.1 libpq.

Psycopg 2.7.6 released

What's new in psycopg 2.7.6
---------------------------

- Close named cursors if exist, even if `~cursor.execute()` wasn't called
  (:ticket:`psycopg#746`).
- Fixed building on modern FreeBSD versions with Python 3.7 (:ticket:`psycopg#755`).
- Fixed hang trying to :sql:`COPY` via `~cursor.execute()` (🎫`psycopg#781`).
- Fixed adaptation of arrays of empty arrays (:ticket:`psycopg#788`).
- Fixed segfault accessing the `connection.readonly` and
  `connection.deferrable` repeatedly (:ticket:`psycopg#790`).
- `~psycopg2.extras.execute_values()` accepts `~psycopg2.sql.Composable`
  objects (psycopg#794).
- `~psycopg2.errorcodes` map updated to PostgreSQL 11.