Kundan
ea293b335e
Fix the Statistics node failing to list its children in Object Explorer. #10310 ( #10639 )
...
pgAdmin renders its templates with trim_blocks, which removes the newline
after a block tag. nodes.sql ended its WHERE clause with a conditional, so
with neither a statistics id nor schema_diff set, which is what expanding
the Statistics collection sends, the SQL ran into "::oidORDER BY" and the
server rejected it.
Give each condition its own line ending in plain text, and add a test that
renders the template for every parameter combination and runs it.
2026-10-22 18:18:27 +05:30
dependabot[bot]
a623526cb7
Javascript dependency: Bump electron-store in /runtime ( #10627 )
...
Bumps [electron-store](https://github.com/sindresorhus/electron-store ) from 11.0.2 to 12.0.0.
- [Release notes](https://github.com/sindresorhus/electron-store/releases )
- [Commits](https://github.com/sindresorhus/electron-store/compare/v11.0.2...v12.0.0 )
---
updated-dependencies:
- dependency-name: electron-store
dependency-version: 12.0.0
dependency-type: direct:production
update-type: version-update:semver-major
...
Signed-off-by: dependabot[bot] <support@github.com >
Co-authored-by: dependabot[bot] <49699333+dependabot[bot]@users.noreply.github.com>
2026-10-22 13:30:16 +02:00
dependabot[bot]
39aed6083b
Javascript dependency: Bump electron ( #10626 )
...
Bumps the runtime-javascript-minor-and-patch group in /runtime with 1 update: [electron](https://github.com/electron/electron ).
Updates `electron` from 44.5.1 to 44.7.0
- [Release notes](https://github.com/electron/electron/releases )
- [Commits](https://github.com/electron/electron/compare/v44.5.1...v44.7.0 )
---
updated-dependencies:
- dependency-name: electron
dependency-version: 44.7.0
dependency-type: direct:development
update-type: version-update:semver-minor
dependency-group: runtime-javascript-minor-and-patch
...
Signed-off-by: dependabot[bot] <support@github.com >
Co-authored-by: dependabot[bot] <49699333+dependabot[bot]@users.noreply.github.com>
2026-10-22 13:29:52 +02:00
dependabot[bot]
05b2864d32
Python dependency: Update flask-socketio requirement ( #10628 )
...
Updates the requirements on [flask-socketio](https://code.miguelgrinberg.com/miguelgrinberg/flask-socketio ) to permit the latest version.
---
updated-dependencies:
- dependency-name: flask-socketio
dependency-version: 5.7.0
dependency-type: direct:production
...
Signed-off-by: dependabot[bot] <support@github.com >
Co-authored-by: dependabot[bot] <49699333+dependabot[bot]@users.noreply.github.com>
2026-10-22 13:29:19 +02:00
dependabot[bot]
8c5dd5eadb
Javascript dependency: Bump follow-redirects in /web ( #10638 )
...
Bumps [follow-redirects](https://github.com/follow-redirects/follow-redirects ) from 1.16.0 to 1.16.1.
- [Release notes](https://github.com/follow-redirects/follow-redirects/releases )
- [Commits](https://github.com/follow-redirects/follow-redirects/compare/v1.16.0...v1.16.1 )
---
updated-dependencies:
- dependency-name: follow-redirects
dependency-version: 1.16.1
dependency-type: indirect
...
Signed-off-by: dependabot[bot] <support@github.com >
Co-authored-by: dependabot[bot] <49699333+dependabot[bot]@users.noreply.github.com>
2026-10-22 13:29:15 +02:00
dependabot[bot]
b345337ddc
Javascript dependency: Bump follow-redirects in /runtime ( #10637 )
...
Bumps [follow-redirects](https://github.com/follow-redirects/follow-redirects ) from 1.16.0 to 1.16.1.
- [Release notes](https://github.com/follow-redirects/follow-redirects/releases )
- [Commits](https://github.com/follow-redirects/follow-redirects/compare/v1.16.0...v1.16.1 )
---
updated-dependencies:
- dependency-name: follow-redirects
dependency-version: 1.16.1
dependency-type: indirect
...
Signed-off-by: dependabot[bot] <support@github.com >
Co-authored-by: dependabot[bot] <49699333+dependabot[bot]@users.noreply.github.com>
2026-10-22 13:29:10 +02:00
Dave Page
b8afe34fbb
Keep external pages out of the desktop runtime's privileged windows and confine non-prompted downloads to the downloads directory. #10614 ( #10616 )
2026-10-16 09:38:54 +01:00
Dave Page
7f21dc4610
Reconnect a lost Query Tool connection as the user and role it was changed to. #10613 ( #10622 )
2026-10-16 03:21:58 +01:00
Dave Page
ac76a81ad2
Revert the Query Tool execute option checkboxes when changing an option fails. #10600 ( #10621 )
2026-10-16 02:29:02 +01:00
Dave Page
5f9909e109
Free Query Tool autocomplete objects when an idle session's connections are released. #10612 ( #10625 )
2026-10-16 02:26:16 +01:00
Dave Page
31a5c5418c
Keep the Query Tool execute options when its transaction is re-created. #10598 ( #10599 )
2026-10-16 01:07:38 +01:00
Dave Page
cc1e1ef184
Remove the dead tree 'loadfail' handler from browser.js. #10601 ( #10620 )
2026-10-16 00:59:08 +01:00
Dave Page
1402f7d9cd
Fix the Jest addNewDatagridRow helper so schema UI specs actually add a row. #10602 ( #10624 )
2026-10-16 00:46:52 +01:00
Dave Page
6594977cc3
Fix Schema Diff treating a function whose input argument was renamed as two unrelated functions. #10597 ( #10623 )
2026-10-16 00:30:56 +01:00
Dave Page
b98470f327
Allow shift + click to extend the cell range selection in the Query Tool results grid. #8647 ( #10617 )
2026-10-15 22:27:56 +01:00
Dave Page
35307612fc
Fix formatting a view's SQL being treated as a column change that drops and re-creates the view. #9838 ( #10591 )
2026-10-15 22:21:26 +01:00
Dave Page
8b381912a8
Fix Azure and Google authentication in the cloud deployment wizard. #9921 ( #10609 )
2026-10-15 21:25:00 +01:00
Dave Page
ab749c630c
Report a failed autocomplete reconnect in the Query Tool instead of ignoring it. #10604 ( #10606 )
2026-10-15 20:53:26 +01:00
Dave Page
1cac42d986
Keep Query Tool execution disabled until a restored tab's execute options reach the server. #10618 ( #10619 )
2026-10-15 20:49:10 +01:00
Dave Page
f73b51f912
Fix modal dialogs being hidden from assistive technology by aria-hidden on the application root. #9865 ( #10587 )
2026-10-15 19:40:21 +01:00
Dave Page
733cd5ba5e
Allow the emailed MFA code to be re-entered after an invalid code is entered. #6671 ( #10589 )
2026-10-15 19:30:20 +01:00
Dave Page
8877330705
Fix Query Tool autocomplete objects being shared between sessions that use the same transaction id. #10607 ( #10608 )
2026-10-15 18:20:52 +01:00
Dave Page
8d8bcf3748
Fix the Query Tool not re-running the query after reconnecting at a password prompt. #10603 ( #10605 )
2026-10-15 18:02:30 +01:00
Dave Page
7828c9b2a1
Restore the per-tab toolbar options when Query Tool tabs are restored on relaunch. #9603 ( #10593 )
2026-10-15 17:29:43 +01:00
Dave Page
09afc34c0e
Fix Schema Diff treating functions that differ only in OUT arguments or return type as unrelated objects. #6652 ( #10595 )
2026-10-15 17:23:43 +01:00
Dave Page
2477a94b32
Fix a flaky Jest test for the connection parameter value dropdown. ( #10610 )
2026-10-15 15:06:27 +01:00
Dave Page
bbb5cc250b
Connect the server when changing the Query Tool connection after it was disconnected. #8144 ( #10588 )
2026-10-15 14:50:25 +01:00
Dave Page
33fab95a73
Fix a database's label staying at '[Disconnecting...]' when disconnecting it fails. #9624 ( #10590 )
2026-10-15 14:49:51 +01:00
Dave Page
755cfec19e
Show fill factor, toast tuple target and parallel workers in the table Properties panel. #9212 ( #10594 )
2026-10-15 12:34:34 +01:00
Dave Page
5711c4dd5a
Keep the AI Assistant's intermediate responses instead of replacing them with placeholder messages. #9818 ( #10592 )
2026-10-15 12:20:18 +01:00
Dave Page
a6374d1ccd
Re-sort renamed server groups and other nodes in the Object Explorer instead of waiting for a reload. #8015 ( #10586 )
2026-10-15 11:45:52 +01:00
Dave Page
78afe89752
Fix Query Tool autocomplete running as the wrong user, or failing, after changing the connection to a different user. #7619 ( #10582 )
2026-10-15 10:42:16 +01:00
Dave Page
70c6777b5e
Fix ERD tables becoming immovable after a Shift-drag selection. #9890 ( #10581 )
2026-10-15 10:38:55 +01:00
Dave Page
7c5b0b7da7
Fix modal dialogs losing keyboard focus to a tool iframe loading in the background. #9784 ( #10583 )
2026-10-15 10:38:39 +01:00
Dave Page
472965ec40
Fix the server context menu showing database options after the tree state is restored. #7612 ( #10580 )
2026-10-15 10:38:24 +01:00
Dave Page
610cad0e0e
Select the adjacent tab when the active tab is closed, rather than the left-most. #9130 ( #10578 )
2026-10-15 10:38:10 +01:00
Dave Page
72ab768b94
Fix the parameter value dropdown keeping stale options when the parameter name is changed. #9630 ( #10579 )
2026-10-15 10:37:52 +01:00
Sanskar Kharya
5063c76a06
Preserve explicit 24-hour mode in date-time picker popups. #10584 ( #10596 )
2026-10-15 10:36:29 +01:00
Dave Page
607c9eccbf
Remove unused Google API documents, Babel locale data and packaging tools from the packages. #9331 ( #10576 )
2026-10-14 18:20:56 +01:00
Dave Page
e8f7a18c98
Allow the login page to be skipped when OAuth2 is the only authentication source. #9975 ( #10575 )
2026-10-14 17:19:12 +01:00
Dave Page
a00cd1dd43
Fix Query Tool state save/restore failing on installations with a legacy SECRET_KEY. #10573 ( #10574 )
2026-10-14 17:17:46 +01:00
Dave Page
b6a4c7fe15
Document running the container with rootless Podman, and the PUID and PGID environment variables. #9524 ( #10572 )
...
* Document running the container with rootless Podman, and the PUID and PGID environment variables. #9524
* Note that the U volume option is recursive and does not relabel for SELinux.
2026-10-14 15:44:33 +01:00
Dave Page
d699acab0b
Clarify the configuration files documentation. #5369 ( #10571 )
...
* Document that config_local.py is lost on upgrade on macOS. #5369
* Retitle the config_py docs page to 'Configuration Files', as it covers all four configuration files. #5369
2026-10-14 14:27:01 +01:00
Hari Prasad
5f6d72c686
Add numpad zoom shortcuts to the Desktop View menu. #10503 ( #10533 )
2026-10-14 13:24:34 +01:00
Dave Page
50209794d7
Require SSL for pgEdge Starfleet hosts and warn when libpq cannot connect to them. ( #10569 )
...
Starfleet endpoints drop SSL connections that arrive without SNI, which
libpq only sends from version 14, and never answer a non-SSL connection.
The cloud wizard now warns when pgAdmin's libpq is older than 14, and
the Register Server dialog defaults sslmode to require for *.pgedge.cloud
hosts, since with prefer any failed SSL attempt is retried without SSL
and reported only as a timeout.
2026-10-14 12:57:08 +01:00
Sanskar Kharya
5515b54d53
Move the 'Returns a set?' option to the Definition tab in the Function dialog. #9264 ( #10565 )
...
Also update the documentation and screenshots to match.
2026-10-14 12:08:07 +01:00
Dave Page
a0b4c09772
Fix server update ignoring the connected-server check, and Connection.reset() never reconnecting. ( #10567 )
2026-10-14 11:37:03 +01:00
Dave Page
0389ee789a
Bundle Python 3.13.16 in the Windows and macOS packages. ( #10566 )
...
Python 3.14 has to wait: the Windows build needs pywinpty, which is held
at 2.0.x for andfoy/pywinpty#545 , and 2.0.x cannot be built for 3.14.
Note that beside both pins.
2026-10-14 10:45:54 +01:00
Dave Page
26a7d92b0b
Fix the Linux packages shipping a stray copy of Python as venv/bin/𝜋thon. #10414 ( #10564 )
...
Python 3.14's venv module creates a "𝜋thon" symlink next to python,
python3 and python3.X (CPython gh-119535). The hash bang fixup runs
"sed -i" over venv/bin/*, which replaces every symlink with a regular
copy of its target; the python* links are recreated afterwards, but the
new alias was not, so packages built against Python 3.14 shipped a full
copy of the interpreter under that name, and dpkg on Ubuntu 26.04 fails
to unpack it. Nothing uses the alias, so remove it when the venv is
created.
2026-10-13 14:56:32 +01:00
Sanskar Kharya
e02150e634
Fix the Dashboard Logs tab failing on multi-byte characters split across read chunks. #10511 ( #10526 )
...
The Logs tab reads the current log file in fixed-size byte ranges with
pg_read_file(), which raises 'invalid byte sequence' (SQLSTATE 22021)
when a range boundary falls inside a multi-byte character, so Tabular
format failed on logs containing non-ASCII text. The ranges are now read
with pg_read_binary_file(), transported as hex and decoded in pgAdmin
using the server encoding. Tabular reads fetch a few bytes of overlap so
a character split at a page boundary is shown whole on one page, and
genuinely invalid bytes are shown as replacement characters rather than
raising an error. For the EUC family of server encodings a page boundary
can still garble one character, as lead and trail bytes share ranges.
- Keep valid text after an invalid byte near the end of the file, trimming only a character still being written.
- Treat a truncated character in the CJK codecs as incomplete rather than invalid.
- Correct the encoding limitation comment, as GBK and GB18030 are not server encodings.
2026-10-13 13:23:44 +01:00