reopen: pip-compile DBT requires contradictory packages #2674

[TjrGithub]

A new bug because I don't have the permissions to reopen #2674. I've got it reproduced as requested - the detailed steps are at jazzband/pip-tools#1196. Would you please verify that this is indeed not a DBT bug? Thank you.

[jtcohen6]

I see your comment on that issue:

# bug disappears without psycopg2

That may be it. By default, dbt requires psycopg2-binary, though this behavior can be overridden via an environment variable (DBT_PSYCOPG2_NAME). You can read about our rationale for that behavior here. It may well be that pip-compile cannot reconcile psycopg2 and psycopg2-binary dependencies.

In any case, this isn't a bug in dbt or a behavior that we're going to change. While we are committed to ensuring that pip install dbt works properly, we can't make any guarantees about third-party software such as pip-compile.