Bump sqlalchemy[postgresql_psycopg2binary] from 1.4.8 to 1.4.9

[dependabot-preview[bot]]

Bumps sqlalchemy[postgresql_psycopg2binary] from 1.4.8 to 1.4.9.

Release notes

Sourced from sqlalchemy[postgresql_psycopg2binary]'s releases.

1.4.9

Released: April 17, 2021

orm

• [orm] [usecase] Established support for _orm.synoynm() in conjunction with hybrid property, assocaitionproxy is set up completely, including that synonyms can be established linking to these constructs which work fully. This is a behavior that was semi-explicitly disallowed previously, however since it did not fail in every scenario, explicit support for assoc proxy and hybrids has been added.

  References: #6267

• [orm] [performance] [bug] [regression] [sql] Fixed a critical performance issue where the traversal of a _sql.select() construct would traverse a repetitive product of the represented FROM clauses as they were each referred towards by columns in the columns clause; for a series of nested subqueries with lots of columns this could cause a large delay and significant memory growth. This traversal is used by a wide variety of SQL and ORM functions, including by the ORM _orm.Session when it's configured to have "table-per-bind", which while this is not a common use case, it seems to be what Flask-SQLAlchemy is hardcoded as using, so the issue impacts Flask-SQLAlchemy users. The traversal has been repaired to uniqify on FROM clauses which was effectively what would happen implicitly with the pre-1.4 architecture.

  References: #6304

• [orm] [bug] [regression] Fixed regression where an attribute that is mapped to a _orm.synonym() could not be used in column loader options such as _orm.load_only().

  References: #6272

sql

• [sql] [bug] [regression] Fixed regression where an empty in statement on a tuple would result in an error when compiled with the option literal_binds=True.

  References: #6290

postgresql

• [postgresql] [bug] [regression] [sql] Fixed an argument error in the default and PostgreSQL compilers that would interfere with an UPDATE..FROM or DELETE..FROM..USING statement

... (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.

If all status checks pass Dependabot will automatically merge this pull request.

---

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](https://app.dependabot.com): - 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)

[codecov[bot]]

Codecov Report

Merging #823 (9349580) into master (cf211a9) will not change coverage. The diff coverage is n/a.

@@           Coverage Diff           @@
##           master     #823   +/-   ##
=======================================
  Coverage   93.24%   93.24%           
=======================================
  Files          11       11           
  Lines        1525     1525           
  Branches      179      179           
=======================================
  Hits         1422     1422           
  Misses         72       72           
  Partials       31       31           

---

Continue to review full report at Codecov.

Legend - Click here to learn more Δ = absolute <relative> (impact), ø = not affected, ? = missing data Powered by Codecov. Last update cf211a9...9349580. Read the comment docs.

[dependabot-preview[bot]]

One of your CI runs failed on this pull request, so Dependabot won't merge it.

• codecov/project

Dependabot will still automatically merge this pull request if you amend it and your tests pass.