Dev-iL commented on PR #68314: URL: https://github.com/apache/airflow/pull/68314#issuecomment-4669274869
> why we need to force everything to be psycopg2 To maintain a consistent behavior w/o surprises. [v3 is not a perfect drop-in replacement for v2](https://www.psycopg.org/psycopg3/docs/basic/from_pg2.html). Silently switching the default driver airflow requires might break user code that relies on installing v2 transitively. I agree we can probably skip the update where v2 and v3 behave exactly the same - but this requires analyzing all replacements, which is not a trivial amount of work. > When we upgrade to SQLA 2.1, won't we have psycopg3 installed, and we can use whatever driver SQLA defaults to? v3 being installed is not guaranteed since [all sqla drivers are optional](https://github.com/sqlalchemy/sqlalchemy/blob/52191f42c99c2096534e5147b67a952d03d7345b/pyproject.toml#L61). Other than that, only the _default_ driver changes; v2 is still supported on 2.1 just like v3 is on 2.0. -- 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]
