Dev-iL commented on code in PR #69526:
URL: https://github.com/apache/airflow/pull/69526#discussion_r3556351878
##########
providers/postgres/docs/changelog.rst:
##########
@@ -44,6 +44,17 @@ Breaking changes
``apache-airflow-providers-postgres[asyncpg]`` and set
``[database] sql_alchemy_conn_async = postgresql+asyncpg://...``
explicitly.
+.. note::
+ The default synchronous metadata-database driver is now ``psycopg``
(psycopg3), mirroring the
+ async default above. ``psycopg2-binary`` is no longer installed by
default; it moved from a hard
+ dependency to the new ``[psycopg2]`` optional extra.
Review Comment:
You made me think - the default SQLA in 2.11 is 1.4, which [doesn't even
support the psycopg v3
driver](https://docs.sqlalchemy.org/en/14/dialects/postgresql.html#dialect-postgresql),
meaning that both this and the asyncpg change (which already merged, but not
yet released) will require more-significant changes beyond adding an extra
(i.e. upgrade to SQLA2).
So the problem might be worse than what you describe.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
