norm Bump postgresql from 42.2.23 to 42.5.1

Bumps postgresql from 42.2.23 to 42.5.1.

Changelog

Changelog

Notable changes since version 42.0.0, read the complete History of Changes.

The format is based on Keep a Changelog.

[Unreleased]

Changed

Added

Fixed

[42.5.1] (2022-11-21 15:21:59 -0500)

Security

security: StreamWrapper spills to disk if setText, or setBytea sends very large Strings or arrays to the server. createTempFile creates a file which can be read by other users on unix like systems (Not macos). This has been fixed in this version fixes CVE-2022-41946 see the security advisory for more details. Reported by Jonathan Leitschuh This has been fixed in versions 42.5.1, 42.4.3 42.3.8, 42.2.27.jre7. Note there is no fix for 42.2.26.jre6. See the security advisory for work arounds.

Fixed

fix: make sure we select array_in from pg_catalog to avoid duplicate array_in functions fixes #Issue 2548 [PR #2552](pgjdbc/pgjdbc#2552)

fix: binary decoding of bool values [PR #2640](pgjdbc/pgjdbc#2640)

perf: improve performance of PgResultSet getByte/getShort/getInt/getLong for float-typed columns [PR #2634](pgjdbc/pgjdbc#2634)

chore: fix various spelling errors [PR #2592](pgjdbc/pgjdbc#2592)

chore: Feature/urlparser improve URLParser [PR #2641](pgjdbc/pgjdbc#2592)

[42.5.0] (2022-08-23 11:20:11 -0400)

Changed

fix: revert change in [PR #1986](pgjdbc/pgjdbc#1986) where float was aliased to float4 from float8. float now aliases to float8 [PR #2598](pgjdbc/pgjdbc#2598) fixes [Issue #2597](pgjdbc/pgjdbc#2597)

[42.4.2] (2022-08-17 10:33:40 -0400)

Changed

fix: add alias to the generated getUDT() query for clarity (PR #2553)[https://github-redirect.dependabot.com/pgjdbc/pgjdbc/pull/2553]

Added

fix: make setObject accept UUID array [PR #2587](pgjdbc/pgjdbc#2587)

Fixed

fix: regression with GSS. Changes introduced to support building with Java 17 caused failures [Issue #2588](pgjdbc/pgjdbc#2588)

fix: set a timeout to get the return from requesting SSL upgrade. [PR #2572](pgjdbc/pgjdbc#2572)

feat: synchronize statement executions (e.g. avoid deadlock when Connection.isValid is executed from concurrent threads)

[42.4.1] (2022-08-01 16:24:20 -0400)

Security

fix: CVE-2022-31197 Fixes SQL generated in PgResultSet.refresh() to escape column identifiers so as to prevent SQL injection.

Previously, the column names for both key and data columns in the table were copied as-is into the generated SQL. This allowed a malicious table with column names that include statement terminator to be parsed and executed as multiple separate commands.

Also adds a new test class ResultSetRefreshTest to verify this change.

Reported by Sho Kato

... (truncated)

Commits

9008dc9 Merge pull request from GHSA-562r-vg33-8x8h
135be5a chore: bump Checkstyle to 9.3
1d7465a chore: bump Gradle to 7.5.1
4743ccf minor: Update the LeftCurly according to the updation in checkstyle
d5ed52e chore: add .git-blame-ignore-revst to hide reformatting commits from GitHub b...
98c04a0 exclude ArrayTest versions less than 9.1 (#2645)
9f90de9 revert change to PGProperty.get() to keep the API the same (#2644)
ee06e22 Feature/urlparser improve3 pr1 (#2641)
56a487c fix: binary decoding of bool values (#2640)
b738991 remove javadoc links for java 17 and above (#2637)
Additional commits viewable 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)