build(deps): bump org.postgresql:postgresql from 42.7.1 to 42.7.3 in /backend

[dependabot[bot]]

Bumps org.postgresql:postgresql from 42.7.1 to 42.7.3.

Release notes

Sourced from org.postgresql:postgresql's releases.

v42.7.3

Changes

• bump version to 42.7.4 @​davecramer (#3164)
• fix Issue boolean types not handled in SimpleQuery mode @​davecramer (#3146)
• The Gradle config enforces 17+ @​OrangeDog (#3147)
• Fix 2 changelog entry titles @​crunchyjohn (#3142)
• chore: ensure CI jobs include tests for all the values of preferQueryMode, ssl, xa, gss @​vlsi (#3137)
• update jdbc website security page with latest security advisory @​davecramer (#3135)

v42.7.2

Security

CVE-2024-1597 and Security Advisory addressed. The vulnerability occurs only in non-default preferQueryMode=simple mode and only if a negative place holder -? is used. See the security advisory for details

What's Changed

• perf: avoid autoboxing bind indexes by @​bokken in pgjdbc/pgjdbc#1244
• add: Add PasswordUtil for encrypting passwords client side by @​sehrope in pgjdbc/pgjdbc#3082
• refactor: document that encodePassword will zero out the password array, and remove driver's default encodePassword by @​vlsi in pgjdbc/pgjdbc#3084
• change: Use simple query for isValid. Using Extended query sends two messages by @​davecramer in pgjdbc/pgjdbc#3101

Full Changelog: https://github.com/pgjdbc/pgjdbc/compare/REL42.7.1...REL42.7.2

Changelog

Sourced from org.postgresql:postgresql's changelog.

[42.7.3] (2024-04-14 14:51:00 -0400)

Changed

• chore: gradle config enforces 17+ [PR #3147](pgjdbc/pgjdbc#3147)

Fixed

• fix: boolean types not handled in SimpleQuery mode [PR #3146](pgjdbc/pgjdbc#3146)
  • make sure we handle boolean types in simple query mode
  • support uuid as well
  • handle all well known types in text mode and change else if to switch
• fix: released new versions of 42.2.29, 42.3.10, 42.4.5, 42.5.6, 42.6.2 to deal with NoSuchMethodError on ByteBuffer#position when running on Java 8

[42.7.2] (2024-02-21 08:23:00 -0500)

Security

• security: SQL Injection via line comment generation, it is possible in SimpleQuery mode to generate a line comment by having a placeholder for a numeric with a - such as -?. There must be second placeholder for a string immediately after. Setting the parameter to a -ve value creates a line comment. This has been fixed in this version fixes CVE-2024-1597. Reported by Paul Gerste. See the security advisory for more details. This has been fixed in versions 42.7.2, 42.6.1 42.5.5, 42.4.4, 42.3.9, 42.2.28.jre7. See the security advisory for work arounds.

Changed

• fix: Use simple query for isValid. Using Extended query sends two messages checkConnectionQuery was never ever set or used, removed [PR #3101](pgjdbc/pgjdbc#3101)
• perf: Avoid autoboxing bind indexes by @​bokken in [PR #1244](pgjdbc/pgjdbc#1244)
• refactor: Document that encodePassword will zero out the password array, and remove driver's default encodePassword by @​vlsi in [PR #3084](pgjdbc/pgjdbc#3084)

Added

• feat: Add PasswordUtil for encrypting passwords client side [PR #3082](pgjdbc/pgjdbc#3082)

Commits

• 818953a fix Issue # 3145 boolean types not handled in SimpleQuery mode (#3146)
• 0e8ab63 The Gradle config enforces 17+ (#3147)
• b591b9f Fix 2 changelog entry titles (#3142)
• 81844e6 chore: ensure CI jobs include tests for all the values of preferQueryMode
• 2fada9e update security page (#3135)
• 388f027 fix: typo password_encrypton -> password_encryption in the error message
• 9cde4f5 Update site for release of 42.7.2 (#3133)
• df14e53 update version and last year modified
• 06abfb7 Merge pull request from GHSA-24rp-q3w6-vc56
• 93b0fcb Merge pull request from GHSA-24rp-q3w6-vc56
• 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 show <dependency name> ignore conditions will show all of the ignore conditions of the specified dependency
• @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)