From 7f87cad26c1726565a200f85b7855bf8192e8df5 Mon Sep 17 00:00:00 2001 From: Mike Bayer Date: Mon, 27 Sep 2021 13:39:35 -0400 Subject: [PATCH] repair pg8000 changelogs; state that python 2 was dropped Change-Id: I3970682d5d7bede56618d722d9068e3998bc6560 References: #7010 --- doc/build/changelog/changelog_14.rst | 18 ++++-------------- doc/build/changelog/migration_14.rst | 13 +++++++++++++ 2 files changed, 17 insertions(+), 14 deletions(-) diff --git a/doc/build/changelog/changelog_14.rst b/doc/build/changelog/changelog_14.rst index 586ab7b70f..b2d04da9f9 100644 --- a/doc/build/changelog/changelog_14.rst +++ b/doc/build/changelog/changelog_14.rst @@ -4438,20 +4438,10 @@ This document details individual issue-level changes made throughout :tags: bug, postgresql The pg8000 dialect has been revised and modernized for the most recent - version of the pg8000 driver for PostgreSQL. Changes to the dialect - include: - - * All data types are now sent as text rather than binary. - - * Using adapters, custom types can be plugged in to pg8000. - - * Previously, named prepared statements were used for all statements. - Now unnamed prepared statements are used by default, and named - prepared statements can be used explicitly by calling the - Connection.prepare() method, which returns a PreparedStatement - object. - - Pull request courtesy Tony Locke. + version of the pg8000 driver for PostgreSQL. Pull request courtesy Tony + Locke. Note that this necessarily pins pg8000 at 1.16.6 or greater, + which no longer has Python 2 support. Python 2 users who require pg8000 + should ensure their requirements are pinned at ``SQLAlchemy<1.4``. .. change:: :tags: bug, orm diff --git a/doc/build/changelog/migration_14.rst b/doc/build/changelog/migration_14.rst index ef0ca9b01a..cca8c7e0e7 100644 --- a/doc/build/changelog/migration_14.rst +++ b/doc/build/changelog/migration_14.rst @@ -2627,6 +2627,19 @@ discriminator column:: Dialect Changes =============== +pg8000 minimum version is 1.16.6, supports Python 3 only +-------------------------------------------------------- + +Support for the pg8000 dialect has been dramatically improved, with help from +the project's maintainer. + +Due to API changes, the pg8000 dialect now requires +version 1.16.6 or greater. The pg8000 series has dropped Python 2 support as of +the 1.13 series. Python 2 users who require pg8000 should ensure their +requirements are pinned at ``SQLAlchemy<1.4``. + +:ticket:`5451` + psycopg2 version 2.7 or higher is required for the PostgreSQL psycopg2 dialect ------------------------------------------------------------------------------ -- 2.47.3