Psycopg 2.9.3 released

What's new in psycopg 2.9.3
^^^^^^^^^^^^^^^^^^^^^^^^^^^

- Alpine (musl) wheels now available (:ticket:`psycopg#1148`).

Psycopg 2.9.1 released

What's new in psycopg 2.9.2
^^^^^^^^^^^^^^^^^^^^^^^^^^^

- Raise `ValueError` for dates >= Y10k (:ticket:`psycopg#1307`).
- `~psycopg2.errorcodes` map and `~psycopg2.errors` classes updated to
  PostgreSQL 14.
- Add preliminary support for Python 3.11 (:tickets:`psycopg#1376, psycopg#1386`).
- Wheel package compiled against OpenSSL 1.1.1l and PostgreSQL 14.1
  (:ticket:`psycopg#1388`).

Release Psycopg 2.9.1 binary packages for Python 3.10

Only for Linux and macOS. Windows packages not ready yet as missing
Appveyor support.

Psycopg 2.9.1 released

What's new in psycopg 2.9.1
^^^^^^^^^^^^^^^^^^^^^^^^^^^

Fix regression with named `sql.Placeholder` (:ticket:`1291`).

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`).