559c6cfa65
Added GENERIC_PLAN, MEMORY, SERIALIZE option to EXPLAIN/EXPLAIN ANALYZE command. #6456
2025-08-01 12:40:07 +05:30
56d5cab13e
Ensure that reconnect dialogs are shown when restoring pgAdmin sessions for the Query Tool or View/Edit Data, if the server password was not saved. #8901
2025-07-21 15:11:12 +05:30
ea085cd009
Fix pagination issues in the query tool data output when using a server-side cursor.
2025-07-18 17:54:06 +05:30
8c662424b2
Display a confirmation message for the server-side cursor transaction status when closing the query tool.
...
Resolve the pagination issue by fetching an additional row to determine the availability of the next record set when using a server-side cursor.
2025-07-15 11:51:14 +05:30
1195f14327
Improved the application restore which includes: #8901
...
1. Leverage rc-dock layout to restore the application state.
2. Move the save and load file endpoints to the file manager module.
3. Ensure that the order and layout of tabs is maintained on restore.
4. Persist the changed title of tabs on restore.
2025-07-15 11:21:57 +05:30
f207818afa
Implemented a server-side cursor to enhance performance when retrieving large datasets. #5797
2025-07-02 12:47:01 +05:30
51d3fe54f3
Ensure proper error message shown if any error occurs while restoring psql tool.
2025-06-27 13:35:24 +05:30
68e559c613
Added support to preserve the workspace, query windows, and pgAdmin state during an abrupt shutdown or restart. #3319
2025-06-05 16:50:38 +05:30
af84d6b1e0
Handle result grid data changes in View/Edit Data mode by automatically reconnecting to the server if a disconnection occurs. #8608
2025-05-13 11:35:58 +05:30
97984eb3ec
Fix an issue where, after a database disconnection, the server would disconnect, and the reconnect dialog would repeatedly appear when clicking the Execute button. #8607
2025-05-08 15:48:49 +05:30
695f870ce1
Fixed an issue where the query tool returns "cannot unpack non-iterable Response object" when running any query with a database name change. #8607
2025-05-02 10:57:43 +05:30
e8cb962890
Add Cache-Control no-cache,no-store,must-revalidate header to dynamically generated utils.js file. #3688
2025-04-16 11:23:35 +05:30
7d8a915ee0
Add support for custom roles and role permissions management in pgAdmin. #7310
2025-04-15 11:25:31 +05:30
627aa5d695
Added ability to use SQL in the 'DB Restriction' field. #2767
2025-04-04 15:53:12 +05:30
75be0bc22d
Fixed a remote code execution issue in the Query Tool and Cloud Deployment (CVE-2025-2945). #8603
2025-03-31 11:33:37 +05:30
efd0dd2ac0
1) Fixed an issue where selecting all rows and copying using shortcut only, the first attempt fails to copy.
...
2) Fixed an issue where a single row is copied first and then clicked on "Select All", the previously copied row's highlight color changes.
3) Fixed an issue where non-shared servers are visible in the Existing Servers list on the Welcome page and New Connection dialog.
2025-02-05 10:26:51 +05:30
e7888c5265
Fixed an issue where the server without a saved password did not persist the user's latest filter dialog input after disconnection. #6044
2025-01-30 11:10:25 +05:30
133a59c71b
Fixed an issue where filter dialog save fails when the PostgreSQL server/database connection is lost. #6044
2025-01-22 10:06:56 +05:30
1216f075ce
Fixed an issue where PSQL tool is not opening if database name have HTML characters in the name. #8365
2025-01-17 14:53:24 +05:30
964d211260
Copyright updated for 2025
2025-01-01 11:26:42 +05:30
185e0f61e2
Close the connection and delete adhoc server if all it's Query tool and PSQL connections are closed.
2024-12-17 17:57:25 +05:30
fe6e21a08b
Enhanced pgAdmin 4 with support for Workspace layouts. #7708
2024-12-16 14:52:56 +05:30
f4cba74bf6
Fixed an issue where querying a foreign table gives the error 'ForeignTableCommand' object has no attribute 'auto_commit'. #7384
2024-11-25 14:40:26 +05:30
8be65ceb7b
Fixed an issue related to the query tool update connection after the server disconnected from the object explorer. #7865
2024-11-19 15:44:40 +05:30
3417186df7
Fix issues found while testing pagination changes. #1780
2024-11-07 18:02:39 +05:30
6322674d98
Replace infinite scrolling with pagination in query tool data output for better UX and performance. #1780
2024-10-01 14:47:12 +05:30
8bae604129
Fix the query tool restore connection issue on the server disconnection from the left side object explorer. #6502
2024-09-02 15:06:11 +05:30
0511554db9
The following issues have been fixed:
...
1) White screen issue after closing the Macro dialog.
2) Schema Diff database and schema selection issue.
3) CSV download issue.
2024-07-24 12:54:20 +05:30
bfcdcdc4f1
Add a precautionary check for the query tool connection cursor to fix the error 'NoneType' object has no attribute '_query'. #7660
2024-07-18 14:24:50 +05:30
22cdb86aab
Fix issue with missing new added records in download file. #5345
2024-07-02 11:48:13 +05:30
b5b0538fe3
Fixed an issue where canceling a query without privilege does not display any message on query tool. #7480
2024-05-31 11:19:44 +05:30
4e3ec91d23
Added support for the 'Add to macros' feature and fixed various usability issues. #4735
2024-05-24 15:30:31 +05:30
f4761f55f7
Fixed Multi-Factor Authentication bypass vulnerability (CVE-2024-4215). #7425
2024-04-29 13:41:02 +05:30
f88c89f3eb
Fixed an issue when closing the materialized view data second tab; it raises the error that the 'MViewCommand' object has no attribute 'auto_commit'.
2024-04-26 15:53:15 +05:30
84c024f6fa
Fixed an issue when closing the view data second tab; it raises the error that the 'ViewCommand' object has no attribute 'auto_commit'. #7384
2024-04-23 14:45:15 +05:30
a02ebe192b
Fixed rollback and commit button activation on execute button click. #7248
2024-03-27 16:38:42 +05:30
0e0cbc40b8
Fixed SonarQube code smell Replace the unused local variable with '_'.
2024-01-24 18:33:43 +05:30
5248055a01
Fixed an issue where auto commit/rollback setting not persisting across query tool connection change. #7091
2024-01-01 15:34:40 +05:30
740ce15bd7
Update copyright notices for 2024
2024-01-01 14:13:48 +05:30
ec12dc5288
Fixed the following issues found in testing #5908 :
...
1. Filter buttons remain highlighted after promotion but the button is disabled.
2. Data changes are getting committed even when Auto commit is turned off on the promoted query tool window.
2023-12-27 13:36:20 +05:30
04580652ab
Allow users to convert View/Edit table into a Query tool to enable editing the SQL generated. #5908
2023-12-19 15:52:57 +05:30
a01b0973fc
Fixed an issue where syntax error was not highlighting for explain query. #6887
2023-12-11 10:57:17 +05:30
0b707be615
Fixed restoration of query tool database connection after dropping and re-creating the database with the same name. #6487
2023-11-01 15:27:18 +05:30
862f101772
Significant changes to use ReactJS extensively.
...
1. Replace the current layout library wcDocker with ReactJS based rc-dock. #6479
2. Have close buttons on individual panel tabs instead of common. #2821
3. Changes in the context menu on panel tabs - Add close, close all and close others menu items. #5394
4. Allow closing all the tabs, including SQL and Properties. #4733
5. Changes in docking behaviour of different tabs based on user requests and remove lock layout menu.
6. Fix an issue where the scroll position of panels was not remembered on Firefox. #2986
7. Reset layout now will not require page refresh and is done spontaneously.
8. Use the zustand store for storing preferences instead of plain JS objects. This will help reflecting preferences immediately.
9. The above fix incorrect format (no indent) of SQL stored functions/procedures. #6720
10. New version check is moved to an async request now instead of app start to improve startup performance.
11. Remove jQuery and Bootstrap completely.
12. Replace jasmine and karma test runner with jest. Migrate all the JS test cases to jest. This will save time in writing and debugging JS tests.
13. Other important code improvements and cleanup.
2023-10-23 17:43:17 +05:30
6e3ee1c607
Fix an issue where servers are not listed in add new connection dialog.
2023-10-18 11:43:42 +05:30
aa973fc8ae
Added support to select/deselect objects in the Backup dialog. #642
2023-09-13 11:07:28 +05:30
c72e2f159d
Fix the query tool issue 'pgAdminThread' object has no attribute 'native_id'. #6660
2023-08-08 11:00:52 +05:30
b55164c454
Fix the query tool issue where raise Notice from func/proc or code blocks are no longer displayed live. #6420
2023-08-07 17:19:08 +05:30
bd4e14da89
Added new/missing parameters to pg_restore. #6562
2023-07-13 13:01:48 +05:30
8dd8d1d03a
Fixed an issue where ERD Tool can't load the saved pgerd file from Shared Storage. #6558
2023-07-13 11:06:46 +05:30
Akshay Joshi
Yogesh Mahajan
Khushboo Vashi
Rohit Bhati
Anil Sahoo
Aditya Toshniwal
Pravesh Sharma
Nikhil Mohite
San Lin Naing