1
0
mirror of synced 2026-10-23 07:08:55 +03:00

8697 Commits

Author SHA1 Message Date
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