chore(deps): update dependency apache-airflow-providers-postgres to v5.12.0

[renovate-bot]

This PR contains the following updates:

Package	Change	Age	Adoption	Passing	Confidence
apache-airflow-providers-postgres (changelog)	==5.5.1 -> ==5.12.0

---

Configuration

📅 Schedule: Branch creation - "before 4am on the first day of the month" (UTC), Automerge - At any time (no schedule defined).

🚦 Automerge: Disabled by config. Please merge this manually once you are satisfied.

♻ Rebasing: Never, or you tick the rebase/retry checkbox.

🔕 Ignore: Close this PR and you won't be reminded about this update again.

---

• [ ] If you want to rebase/retry this PR, check this box

---

This PR was generated by Mend Renovate. View the repository job log.

[forking-renovate[bot]]

Edited/Blocked Notification

Renovate will not automatically rebase this PR, because it does not recognize the last commit author and assumes somebody else may have edited the PR.

You can manually request rebase by checking the rebase/retry box above.

⚠️ Warning: custom changes will be lost.

[davidcavazos]

ERROR: Cannot install apache-airflow-providers-postgres==5.12.0 because these package versions have conflicting dependencies.

The conflict is caused by:
    The user requested apache-airflow-providers-postgres==5.12.0
    The user requested (constraint) apache-airflow-providers-postgres==5.5.1

[davidcavazos]

Updating this was way trickier than expected. It turns out that we have to stick with the autogenerated constraints.txt files from Apache Airflow. The ones for the latest Apache Airflow versions require Python 3.9 and there are pandas dependency conflicts within the constraint file itself, so I went with Airflow 2.9.2 which was the latest one that worked.

[davidcavazos]

It turns out that scipy still requires Python >= 3.10, so I'm updating to 3.12 and see if it works.

[davidcavazos]

Some dependencies still don't support 3.12, so downgrading to 3.11