Bump psycopg2 from 2.6.2 to 2.9.1 in /api

[dependabot-preview[bot]]

Bumps psycopg2 from 2.6.2 to 2.9.1.

Changelog

Sourced from psycopg2's changelog.

Current release

What's new in psycopg 2.9.1 ^^^^^^^^^^^^^^^^^^^^^^^^^^^

Fix regression with named sql.Placeholder (:ticket:1291).

What's new in psycopg 2.9

• with connection starts a transaction on autocommit transactions too (:ticket:[#941](https://github.com/psycopg/psycopg2/issues/941)).
• Timezones with fractional minutes are supported on Python 3.7 and following (:ticket:[#1272](https://github.com/psycopg/psycopg2/issues/1272)).
• Escape table and column names in ~cursor.copy_from() and ~cursor.copy_to().
• Connection exceptions with sqlstate 08XXX reclassified as ~psycopg2.OperationalError (a subclass of the previously used ~psycopg2.DatabaseError) (:ticket:[#1148](https://github.com/psycopg/psycopg2/issues/1148)).
• Include library dirs required from libpq to work around MacOS build problems (:ticket:[#1200](https://github.com/psycopg/psycopg2/issues/1200)).

Other changes:

• Dropped support for Python 2.7, 3.4, 3.5 (:tickets:[#1198](https://github.com/psycopg/psycopg2/issues/1198), [#1000](https://github.com/psycopg/psycopg2/issues/1000), [#1197](https://github.com/psycopg/psycopg2/issues/1197)).
• Dropped support for mx.DateTime.
• Use datetime.timezone objects by default in datetime objects instead of ~psycopg2.tz.FixedOffsetTimezone.
• The psycopg2.tz module is deprecated and scheduled to be dropped in the next major release.
• Provide :pep:599 wheels packages (manylinux2014 tag) for i686 and x86_64 platforms.
• Provide :pep:600 wheels packages (manylinux_2_24 tag) for aarch64 and ppc64le platforms.
• Wheel package compiled against OpenSSL 1.1.1k and PostgreSQL 13.3.
• Build system for Linux/MacOS binary packages moved to GitHub Actions.

What's new in psycopg 2.8.7 ^^^^^^^^^^^^^^^^^^^^^^^^^^^

• Accept empty params as ~psycopg2.connect() (:ticket:[#1250](https://github.com/psycopg/psycopg2/issues/1250)).
• Fix attributes refcount in Column initialisation (:ticket:[#1252](https://github.com/psycopg/psycopg2/issues/1252)).
• Allow re-initialisation of static variables in the C module (:ticket:[#1267](https://github.com/psycopg/psycopg2/issues/1267)).

What's new in psycopg 2.8.6 ^^^^^^^^^^^^^^^^^^^^^^^^^^^

... (truncated)

Commits

• See full diff in compare view

Dependabot will resolve any conflicts with this PR as long as you don't alter it yourself. You can also trigger a rebase manually by commenting @dependabot rebase.

---

Dependabot commands and options

You can trigger Dependabot actions by commenting on this PR:

• @dependabot rebase will rebase this PR
• @dependabot recreate will recreate this PR, overwriting any edits that have been made to it
• @dependabot merge will merge this PR after your CI passes on it
• @dependabot squash and merge will squash and merge this PR after your CI passes on it
• @dependabot cancel merge will cancel a previously requested merge and block automerging
• @dependabot reopen will reopen this PR if it is closed
• @dependabot close will close this PR and stop Dependabot recreating it. You can achieve the same result by closing it manually
• @dependabot ignore this major version will close this PR and stop Dependabot creating any more for this major version (unless you reopen the PR or upgrade to it yourself)
• @dependabot ignore this minor version will close this PR and stop Dependabot creating any more for this minor version (unless you reopen the PR or upgrade to it yourself)
• @dependabot ignore this dependency will close this PR and stop Dependabot creating any more for this dependency (unless you reopen the PR or upgrade to it yourself)
• @dependabot use these labels will set the current labels as the default for future PRs for this repo and language
• @dependabot use these reviewers will set the current reviewers as the default for future PRs for this repo and language
• @dependabot use these assignees will set the current assignees as the default for future PRs for this repo and language
• @dependabot use this milestone will set the current milestone as the default for future PRs for this repo and language
• @dependabot badge me will comment on this PR with code to add a "Dependabot enabled" badge to your readme

Additionally, you can set the following in your Dependabot dashboard:

• Update frequency (including time of day and day of week)
• Pull request limits (per update run and/or open at any time)
• Automerge options (never/patch/minor, and dev/runtime dependencies)
• Out-of-range updates (receive only lockfile updates, if desired)
• Security updates (receive only security updates, if desired)