This PR contains the following updates:
| Package | Type | Update | Change |
|---|---|---|---|
| [github.com/lib/pq](https://github.com/lib/pq) | require | minor | `v1.10.9` -> `v1.11.1` |
---
### Release Notes
<details>
<summary>lib/pq (github.com/lib/pq)</summary>
### [`v1.11.1`](https://github.com/lib/pq/blob/HEAD/CHANGELOG.md#v1111-2025-01-29)
[Compare Source](https://github.com/lib/pq/compare/v1.11.0...v1.11.1)
This fixes two regressions present in the v1.11.0 release:
- Fix build on 32bit systems, Windows, and Plan 9 ([#​1253]).
- Named \[]byte types and pointers to \[]byte (e.g. `*[]byte`, `json.RawMessage`)
would be treated as an array instead of bytea ([#​1252]).
[#​1252]: https://github.com/lib/pq/pull/1252
[#​1253]: https://github.com/lib/pq/pull/1253
### [`v1.11.0`](https://github.com/lib/pq/blob/HEAD/CHANGELOG.md#v1110-2025-01-28)
[Compare Source](https://github.com/lib/pq/compare/v1.10.9...v1.11.0)
This version of pq requires Go 1.21 or newer.
pq now supports only maintained PostgreSQL releases, which is PostgreSQL 14 and
newer. Previously PostgreSQL 8.4 and newer were supported.
##### Features
- The `pq.Error.Error()` text includes the position of the error (if reported
by PostgreSQL) and SQLSTATE code ([#​1219], [#​1224]):
```
pq: column "columndoesntexist" does not exist at column 8 (42703)
pq: syntax error at or near ")" at position 2:71 (42601)
```
- The `pq.Error.ErrorWithDetail()` method prints a more detailed multiline
message, with the Detail, Hint, and error position (if any) ([#​1219]):
```
ERROR: syntax error at or near ")" (42601)
CONTEXT: line 12, column 1:
10 | name varchar,
11 | version varchar,
12 | );
^
```
- Add `Config`, `NewConfig()`, and `NewConnectorConfig()` to supply connection
details in a more structured way ([#​1240]).
- Support `hostaddr` and `$PGHOSTADDR` ([#​1243]).
- Support multiple values in `host`, `port`, and `hostaddr`, which are each
tried in order, or randomly if `load_balance_hosts=random` is set ([#​1246]).
- Support `target_session_attrs` connection parameter ([#​1246]).
- Support [`sslnegotiation`] to use SSL without negotiation ([#​1180]).
- Allow using a custom `tls.Config`, for example for encrypted keys ([#​1228]).
- Add `PQGO_DEBUG=1` print the communication with PostgreSQL to stderr, to aid
in debugging, testing, and bug reports ([#​1223]).
- Add support for NamedValueChecker interface ([#​1125], [#​1238]).
##### Fixes
- Match HOME directory lookup logic with libpq: prefer $HOME over /etc/passwd,
ignore ENOTDIR errors, and use APPDATA on Windows ([#​1214]).
- Fix `sslmode=verify-ca` verifying the hostname anyway when connecting to a DNS
name (rather than IP) ([#​1226]).
- Correctly detect pre-protocol errors such as the server not being able to fork
or running out of memory ([#​1248]).
- Fix build with wasm ([#​1184]), appengine ([#​745]), and Plan 9 ([#​1133]).
- Deprecate and type alias `pq.NullTime` to `sql.NullTime` ([#​1211]).
- Enforce integer limits of the Postgres wire protocol ([#​1161]).
- Accept the `passfile` connection parameter to override `PGPASSFILE` ([#​1129]).
- Fix connecting to socket on Windows systems ([#​1179]).
- Don't perform a permission check on the .pgpass file on Windows ([#​595]).
- Warn about incorrect .pgpass permissions ([#​595]).
- Don't set extra\_float\_digits ([#​1212]).
- Decode bpchar into a string ([#​949]).
- Fix panic in Ping() by not requiring CommandComplete or EmptyQueryResponse in
simpleQuery() ([#​1234])
- Recognize bit/varbit ([#​743]) and float types ([#​1166]) in ColumnTypeScanType().
- Accept `PGGSSLIB` and `PGKRBSRVNAME` environment variables ([#​1143]).
- Handle ErrorResponse in readReadyForQuery and return proper error ([#​1136]).
- CopyIn() and CopyInSchema() now work if the list of columns is empty, in which
case it will copy all columns ([#​1239]).
- Treat nil \[]byte in query parameters as nil/NULL rather than `""` ([#​838]).
- Accept multiple authentication methods before checking AuthOk, which improves
compatibility with PgPool-II ([#​1188]).
[`sslnegotiation`]: https://www.postgresql.org/docs/current/libpq-connect.html#LIBPQ-CONNECT-SSLNEGOTIATION
[#​595]: https://github.com/lib/pq/pull/595
[#​745]: https://github.com/lib/pq/pull/745
[#​743]: https://github.com/lib/pq/pull/743
[#​838]: https://github.com/lib/pq/pull/838
[#​949]: https://github.com/lib/pq/pull/949
[#​1125]: https://github.com/lib/pq/pull/1125
[#​1129]: https://github.com/lib/pq/pull/1129
[#​1133]: https://github.com/lib/pq/pull/1133
[#​1136]: https://github.com/lib/pq/pull/1136
[#​1143]: https://github.com/lib/pq/pull/1143
[#​1161]: https://github.com/lib/pq/pull/1161
[#​1166]: https://github.com/lib/pq/pull/1166
[#​1179]: https://github.com/lib/pq/pull/1179
[#​1180]: https://github.com/lib/pq/pull/1180
[#​1184]: https://github.com/lib/pq/pull/1184
[#​1188]: https://github.com/lib/pq/pull/1188
[#​1211]: https://github.com/lib/pq/pull/1211
[#​1212]: https://github.com/lib/pq/pull/1212
[#​1214]: https://github.com/lib/pq/pull/1214
[#​1219]: https://github.com/lib/pq/pull/1219
[#​1223]: https://github.com/lib/pq/pull/1223
[#​1224]: https://github.com/lib/pq/pull/1224
[#​1226]: https://github.com/lib/pq/pull/1226
[#​1228]: https://github.com/lib/pq/pull/1228
[#​1234]: https://github.com/lib/pq/pull/1234
[#​1238]: https://github.com/lib/pq/pull/1238
[#​1239]: https://github.com/lib/pq/pull/1239
[#​1240]: https://github.com/lib/pq/pull/1240
[#​1243]: https://github.com/lib/pq/pull/1243
[#​1246]: https://github.com/lib/pq/pull/1246
[#​1248]: https://github.com/lib/pq/pull/1248
</details>
---
### Configuration
📅 **Schedule**: Branch creation - At any time (no schedule defined), Automerge - At any time (no schedule defined).
🚦 **Automerge**: Enabled.
♻ **Rebasing**: Whenever PR is behind base branch, or you tick the rebase/retry checkbox.
🔕 **Ignore**: Close this PR and you won't be reminded about this update again.
---
- [ ] <!-- rebase-check -->If you want to rebase/retry this PR, check this box
---
This PR has been generated by [Renovate Bot](https://github.com/renovatebot/renovate).
<!--renovate-debug:eyJjcmVhdGVkSW5WZXIiOiI0MS4xNDAuMSIsInVwZGF0ZWRJblZlciI6IjQxLjE0MC4xIiwidGFyZ2V0QnJhbmNoIjoibWFzdGVyIiwibGFiZWxzIjpbInJlbm92YXRlL2F1dG9tZXJnZSIsInJlbm92YXRlL2dvbGFuZyJdfQ==-->
Blocking a user prevents them from interacting with repositories, such as opening or commenting on pull requests or issues. Learn more about blocking a user.
This PR contains the following updates:
v1.10.9->v1.11.1Release Notes
lib/pq (github.com/lib/pq)
v1.11.1Compare Source
This fixes two regressions present in the v1.11.0 release:
Fix build on 32bit systems, Windows, and Plan 9 (#1253).
Named []byte types and pointers to []byte (e.g.
*[]byte,json.RawMessage)would be treated as an array instead of bytea (#1252).
v1.11.0Compare Source
This version of pq requires Go 1.21 or newer.
pq now supports only maintained PostgreSQL releases, which is PostgreSQL 14 and
newer. Previously PostgreSQL 8.4 and newer were supported.
Features
The
pq.Error.Error()text includes the position of the error (if reportedby PostgreSQL) and SQLSTATE code (#1219, #1224):
The
pq.Error.ErrorWithDetail()method prints a more detailed multilinemessage, with the Detail, Hint, and error position (if any) (#1219):
Add
Config,NewConfig(), andNewConnectorConfig()to supply connectiondetails in a more structured way (#1240).
Support
hostaddrand$PGHOSTADDR(#1243).Support multiple values in
host,port, andhostaddr, which are eachtried in order, or randomly if
load_balance_hosts=randomis set (#1246).Support
target_session_attrsconnection parameter (#1246).Support
sslnegotiationto use SSL without negotiation (#1180).Allow using a custom
tls.Config, for example for encrypted keys (#1228).Add
PQGO_DEBUG=1print the communication with PostgreSQL to stderr, to aidin debugging, testing, and bug reports (#1223).
Add support for NamedValueChecker interface (#1125, #1238).
Fixes
Match HOME directory lookup logic with libpq: prefer $HOME over /etc/passwd,
ignore ENOTDIR errors, and use APPDATA on Windows (#1214).
Fix
sslmode=verify-caverifying the hostname anyway when connecting to a DNSname (rather than IP) (#1226).
Correctly detect pre-protocol errors such as the server not being able to fork
or running out of memory (#1248).
Fix build with wasm (#1184), appengine (#745), and Plan 9 (#1133).
Deprecate and type alias
pq.NullTimetosql.NullTime(#1211).Enforce integer limits of the Postgres wire protocol (#1161).
Accept the
passfileconnection parameter to overridePGPASSFILE(#1129).Fix connecting to socket on Windows systems (#1179).
Don't perform a permission check on the .pgpass file on Windows (#595).
Warn about incorrect .pgpass permissions (#595).
Don't set extra_float_digits (#1212).
Decode bpchar into a string (#949).
Fix panic in Ping() by not requiring CommandComplete or EmptyQueryResponse in
simpleQuery() (#1234)
Recognize bit/varbit (#743) and float types (#1166) in ColumnTypeScanType().
Accept
PGGSSLIBandPGKRBSRVNAMEenvironment variables (#1143).Handle ErrorResponse in readReadyForQuery and return proper error (#1136).
CopyIn() and CopyInSchema() now work if the list of columns is empty, in which
case it will copy all columns (#1239).
Treat nil []byte in query parameters as nil/NULL rather than
""(#838).Accept multiple authentication methods before checking AuthOk, which improves
compatibility with PgPool-II (#1188).
Configuration
📅 Schedule: Branch creation - At any time (no schedule defined), Automerge - At any time (no schedule defined).
🚦 Automerge: Enabled.
♻ Rebasing: Whenever PR is behind base branch, or you tick the rebase/retry checkbox.
🔕 Ignore: Close this PR and you won't be reminded about this update again.
This PR has been generated by Renovate Bot.