Bump postgresql from 9.3-1102-jdbc41 to 42.2.19

[dependabot-preview[bot]]

Bumps postgresql from 9.3-1102-jdbc41 to 42.2.19.

Changelog

Sourced from postgresql's changelog.

[42.2.19] (2021-02-18)

Notable Changes

• Now the driver uses SASLprep normalization for SCRAM authentication fixing some issues with spaces in passwords.
• If closeOnCompletion is called on an existing statement and the statement is executed a second time it will fail.

Changed

• Fix: Actually close unclosed results. Previously was not closing the first unclosed result fixes #1903 (#1905) There is a small behaviour change here as a result. If closeOnCompletion is called on an existing statement and the statement is executed a second time it will fail.

Added

• Verify code via forbidden-apis (jdk-internal and jdk-non-portable signatures) [PR #2012](pgjdbc/pgjdbc#2012)

Fixed

• Fix: properly set cancel socket timeout (#2044)
• Fix "Required class information missing" when old org.jboss:jandex parses pgjdbc classes [issue 2008][https://github-redirect.dependabot.com/pgjdbc/pgjdbc/issues/2008]
• Fix PGCopyInputStream returning the last row twice when reading with CopyOut API [issue 2016][https://github-redirect.dependabot.com/pgjdbc/pgjdbc/issues/2016]
• Fix Connnection.isValid() to not wait longer than existing network timeout [PR #2040](pgjdbc/pgjdbc#2040)
• Fix Passwords with spaces (ASCII and non-ASCII) now work with SCRAM authentication (driver now uses SASLprep normalization) [PR #2052](pgjdbc/pgjdbc#2052)
• Fix DatabaseMetaData.getTablePrivileges() to include views, materialized views, and foreign tables [PR #2049](pgjdbc/pgjdbc#2049)

[42.2.18]

Fixed

• Unfortunately changing the default of gssEncMode to ALLOW was not enough. The GSSEncMode Enum was not changed as well fixed in #1920

[42.2.17]

Changed

• Change default of gssEncMode to ALLOW. PostgreSQL can deal with PREFER but there are cloud providers that did not implement the protocol properly. Libpq gets around this by checking for a GSS credential cache before attempting the connection. This is possible in JDK 8 and up, but not JDK6, or JDK7 fixes Issue #1868 [PR #1913](pgjdbc/pgjdbc#1913)

Added

• Add smallserial metadata [PR #899(pgjdbc/pgjdbc#899)

Fixed

• Avoid NullPointerException when receiving PGbox, PGcircle, PGline, PGlseg, PGpath, PGpoint, PGpolygon, and PGmoney [PR 1873] (pgjdbc/pgjdbc#1873).
• The driver returns enum and jsonb arrays elements as String objects (like in 42.2.14 and earlier versions) PR 1879.
• PgTokenizer was ignoring last empty token [PR #1882](pgjdbc/pgjdbc#1882)
• Remove osgi from karaf fixes Issue #1891 [PR #1902](pgjdbc/pgjdbc#1902)

[42.2.16] (2020-08-20)

Known issues

• The driver returns enum and jsonb arrays elements are returned as PGobject instances (fixed in 42.2.17)

Fixed

• Arrays sent in binary format are now sent as 1 based. This was a regression for multi-dimensional arrays as well as text/varchar, oid and bytea arrays. Since 42.2.0 single dimensional arrays were stored 0 based. They are now sent 1 based which is the SQL standard, and the default for Postgres when sent as strings such as '{1,2,3}'. Fixes issue 1860 in PR 1863.

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

[dependabot-preview[bot]]

Superseded by #183.