Bump postgresql from 42.5.0 to 42.6.0

Bumps postgresql from 42.5.0 to 42.6.0.

Release notes

v42.5.4

What's Changed

apply doc changes from PR #2743 to release/42.5.x by @davecramer in pgjdbc/pgjdbc#2753

fix: fix testGetSQLTypeQueryCache by searching for xid type. by @davecramer in pgjdbc/pgjdbc#2805

Revert "fix: fix testGetSQLTypeQueryCache by searching for xid type." by @davecramer in pgjdbc/pgjdbc#2807

Make sure that github CI runs tests on all PRs by @davecramer in pgjdbc/pgjdbc#2809

fix: fix testGetSQLTypeQueryCache by searching for xid type instead of box. by @davecramer in pgjdbc/pgjdbc#2810

Update docs for Release 42.5.4 by @davecramer in pgjdbc/pgjdbc#2812

Full Changelog: https://github.com/pgjdbc/pgjdbc/compare/REL42.5.3...REL42.5.4

v42.5.3

What's Changed

Add box to TypeInfoCache, fixes Issue #2746 by @davecramer in pgjdbc/pgjdbc#2747

update changelog and docs for release by @davecramer in pgjdbc/pgjdbc#2751

minor changes by @davecramer in pgjdbc/pgjdbc#2752

Full Changelog: https://github.com/pgjdbc/pgjdbc/compare/REL42.5.2...REL42.5.3

v42.5.2

What's Changed

Fix broken case in Maven XML snippet copied to clipboard by @dalbani in pgjdbc/pgjdbc#2682

move release date to Nov 23, update version number for next release by @davecramer in pgjdbc/pgjdbc#2677

fix: Make sure socket is closed if an exception is thrown in createSocket fixes Issue #2684 by @davecramer in pgjdbc/pgjdbc#2685

docs: specify that timeouts are in seconds and there is a maximum. Housekeeping on some tests fixes #Issue 2671 by @davecramer in pgjdbc/pgjdbc#2686

fix: Apply patch from Issue #2683 to fix hanging ssl connections by @davecramer in pgjdbc/pgjdbc#2687

style: Style only change to use diamond operator in Oid by @rbygrave in pgjdbc/pgjdbc#2691

style: Style only change, use diamond operator in PGProperty by @rbygrave in pgjdbc/pgjdbc#2692

fix - binary conversion of (very) long numeric values by @bokken in pgjdbc/pgjdbc#2697

docs: clarify binaryTransfer and add it to README by @davecramer in pgjdbc/pgjdbc#2698

docs: Document the need to encode reserved characters in the connection URL by @davecramer in pgjdbc/pgjdbc#2700

minor: set private attribute as final by @AlaaAttya in pgjdbc/pgjdbc#2704

minor: enhance readability connection of startup params by @AlaaAttya in pgjdbc/pgjdbc#2705

minor: log warning on stream close failure by @AlaaAttya in pgjdbc/pgjdbc#2708

fix: make variables private final by @davecramer in pgjdbc/pgjdbc#2707

fix: Parser does not handle version 14 function syntax Issue #2507 by @davecramer in pgjdbc/pgjdbc#2703

fix: img src in README by @david-whs in pgjdbc/pgjdbc#2712

fix binary transfer floating point overflow by @bokken in pgjdbc/pgjdbc#2710

Revert "fix binary transfer floating point overflow" by @davecramer in pgjdbc/pgjdbc#2716

add redirects fixes issue #2608 by @davecramer in pgjdbc/pgjdbc#2718

update lastEditYear by @davecramer in pgjdbc/pgjdbc#2721

Revert "update lastEditYear" by @davecramer in pgjdbc/pgjdbc#2727

fix: improve thread safety of PgResultSet#getTimestamp by @sz-liva in pgjdbc/pgjdbc#2726

Update lastyear by @davecramer in pgjdbc/pgjdbc#2728

redo PR fix_binary_transfer_floating point from brett, removed BigDecimal where possible by @davecramer in pgjdbc/pgjdbc#2719

Bump GitHub action versions, replace deprecated set-output usage by @vlsi in pgjdbc/pgjdbc#2731

docs: remove generated docs from source control by @vlsi in pgjdbc/pgjdbc#2734

add ssl redirect by @davecramer in pgjdbc/pgjdbc#2735

... (truncated)

Changelog

Sourced from postgresql's changelog.

[42.6.0] (2023-03-17 15:34:34 -0400)

Changed

fix: use PhantomReferences instead of Obejct.finalize() to track Connection leaks [PR #2847](pgjdbc/pgjdbc#2847)
The change replaces all uses of Object.finalize with PhantomReferences.
The leaked resources (Connections) are tracked in a helper thread that is active as long as
there are connections in use. By default, the thread keeps running for 30 seconds after all
the connections are released. The timeout is set with pgjdbc.config.cleanup.thread.ttl system property.
refactor:(loom) replace the usages of synchronized with ReentrantLock [PR #2635](pgjdbc/pgjdbc#2635) Fixes [Issue #1951](pgjdbc/pgjdbc#1951)

[42.5.4] (2023-02-15 10:21:04 -0500)

Fixed

fix: fix testGetSQLTypeQueryCache by searching for xid type. We used to search for box type but it is now cached. xid is not cached, this nuance is required for the test. fix OidValueCorrectnessTest BOX_ARRAY OID, by adding BOX_ARRAY to the oidTypeName map [PR #2810]((pgjdbc/pgjdbc#2810). fixes [Issue #2804](pgjdbc/pgjdbc#2804). fix: Make sure that github CI runs tests on all [PRs #2809]((pgjdbc/pgjdbc#2809)).

[42.5.3] (2023-02-03 08:24:50 -0500)

Fixed

fix: Add box to TypeInfoCache, fixes [Issue #2746](pgjdbc/pgjdbc#2746) [PR #2747](pgjdbc/pgjdbc#2747) fix: regression in PgResultSet LONG_MIN copy and paste error fixes [Issue #2748](pgjdbc/pgjdbc#2748) PR#2749

[42.5.2] (2023-01-31 14:30:46 -0500)

Changed

regression: This release has 2 known regressions which make it unusable see the notes above. We advise people to use 42.5.3 instead. docs: specify that timeouts are in seconds and there is a maximum. Housekeeping on some tests fixes #Issue 2671 [PR #2686](pgjdbc/pgjdbc#2686) docs: clarify binaryTransfer and add it to README PR# 2698 docs: Document the need to encode reserved characters in the connection URL [PR #2700](pgjdbc/pgjdbc#2700) feat: Define binary transfer for custom types dynamically/automatically fixes [Issue #2554](pgjdbc/pgjdbc#2554) [PR #2556](pgjdbc/pgjdbc#2556)

Added

fix: added gssResponseTimeout as part of [PR #2687](pgjdbc/pgjdbc#2687) to make sure we don't wait forever on a GSS RESPONSE

Fixed

fix: Ensure case of XML tags in Maven snippet is correct [PR #2682](pgjdbc/pgjdbc#2682) fix: Make sure socket is closed if an exception is thrown in createSocket fixes [Issue #2684](pgjdbc/pgjdbc#2684) [PR #2685](pgjdbc/pgjdbc#2685) fix: Apply patch from [Issue #2683](pgjdbc/pgjdbc#2683) to fix hanging ssl connections [PR #2687](pgjdbc/pgjdbc#2687) fix - binary conversion of (very) long numeric values (longer than 4 * 2^15 digits) [PR #2697](pgjdbc/pgjdbc#2697) fixes [Issue #2695](pgjdbc/pgjdbc#2695) minor: enhance readability connection of startup params [PR #2705](pgjdbc/pgjdbc#2785)

[42.5.1] (2022-11-23 10:14: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.

... (truncated)

Commits

d6a0cc2 Update CHANGELOG for release (#2851)
b656c63 Fix pks12docs (#2857)
aade7a0 chore: bump classloader-leak-test-framework to 1.1.2
5873a2c Remove stray whitespace and use code formatting (#2854)
29414ab chore: suppress warnings on implementing deprecated methods in QueryExecutorImpl
3a15db6 chore: suppress deprecation warnings on in BaseDataSource on use of FACTORY...
35431d6 chore: replace deprecated clazz.newInstance() with .getDeclaredConstructor()....
ca25d10 chore: suppress deprecations from implementing deprecated ResultSet and State...
4b29078 test: suppress warnings for setUseServerPrepare deprecation
61aee4d chore: run "Unnecessary boxing" inspection in IDEA
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)