Test psycopg2 build version jobs fail when direct references is set for branch testing

[VersusFacit]

When we make changes in a base adapter or similar that require us to test against a specific ref of dbt-postgres, the build steps labeled Test psycopg2 build version will break.

We need to dig into why this is happening and find a way to get our builds reliably green even when testing branches.

This will be a bigger problem if we migrate other adapters to hatch in the near future.

Steps to Reproduce

1. Add to pyproject.toml

[tool.hatch.metadata]
allow-direct-references = true

2. Edit some reference in the pyproject.toml to point to a specific ref of a repo
3. Watch as these metadata jobs