593b111fdf
Add all missing options to the Import/Export Data functionality, and update the syntax of the COPY command to align with the latest standards. #8583
...
Add support for exporting table data based on a custom query. #8681
2025-04-30 17:51:04 +05:30
78d9aa5b76
Fixed issue found while testing PostGIS spatial type constructor support. #2256
2025-04-25 11:13:18 +05:30
d468c16ca2
Fixed more issues found while testing role permissions feature. #7310
2025-04-23 15:47:51 +05:30
b08e90ea88
Add support for type constructors for PostGIS spatial types. #2256
2025-04-23 15:35:42 +05:30
ec3d142ad9
Fix issues while testing role permissions feature. #7310
2025-04-21 15:14:18 +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
8b4df8beb1
Change the shortcut for canceling a running query as it conflicts with the shortcut to open a new query tool. #8628
2025-04-14 13:46:59 +05:30
f98a74b526
Fixed an issue where the user management tab is not opening in the classic layout. #8651
2025-04-14 13:32:05 +05:30
18f47a59c5
Fixed an issue where the query tool went blank when converting history dates to the appropriate locale format. #8632
2025-04-14 12:43:05 +05:30
31b1af2f84
Fixed an issue where filtering on a view caused an error. #8630
2025-04-09 19:00:32 +05:30
2de2c30545
Fixed an issue where Ctrl/Cmd+A in cell editor would select all rows. #8572
2025-04-08 18:29:05 +05:30
51897dc804
Fixed an issue where shift + click on rows/columns for range selection did not work in the query tool data output window. #5266
2025-04-08 12:43:05 +05:30
627aa5d695
Added ability to use SQL in the 'DB Restriction' field. #2767
2025-04-04 15:53:12 +05:30
8031c35160
Fixed an issue where the debugger hangs when stepping into nested function/procedure. #8443
2025-04-03 19:20:28 +05:30
10b15b3986
Added support for font ligatures. #8629
2025-04-03 19:06:40 +05:30
af6c1a24cf
1) Upgraded Gunicorn to version 23.0.0 to address a security vulnerability present in Gunicorn.
...
2) Resolved an issue where an empty PSQL panel would open if the psql utility was not found in the binary path.
2025-04-01 16:33:50 +05:30
cfca6f6218
Fixed issues while testing multiple popups issue. #8316
2025-03-31 14:28:56 +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
6b9f002366
Fixed an issue where user management tab was not focussed when opened from a non default workspace. #8574
2025-03-28 15:31:51 +05:30
1d3e0a4455
Revert the fix for #8006
2025-03-27 12:32:46 +05:30
82c5febde6
Font family should fallback to Source Code Pro if not valid. #392
...
Update user management docs.
2025-03-27 11:03:39 +05:30
9ab451e163
Open user management in a separate tab instead of a dialog to enhance UI/UX. #8574
2025-03-25 12:33:49 +05:30
13b44fffc7
Add an ability to configure the font family for SQL editors. #392
2025-03-24 11:08:49 +05:30
b2669930f5
Ensure that modal dialogs are not triggered more than once to avoid duplicates. #8316
2025-03-18 15:58:16 +05:30
be534be674
Update the stop/terminate icon at all the places for better UX. #8473
2025-03-12 12:31:23 +05:30
f9af74529c
Fixed an issue where geometries in the geometry viewer will render partially when the container was resized. #8462
2025-03-10 18:44:24 +05:30
73b437c0f5
Added support to automatically open a file after it is downloaded in the desktop mode. #4194
2025-03-10 11:38:13 +05:30
1590df8dfd
Change the stop/terminate icon at all the places for better UX. #8473
2025-03-07 11:26:13 +05:30
5ee33cf162
Fixed an issue where the PSQL terminal displays keyname for non alphanumeric keys. #8437
2025-03-05 18:31:49 +05:30
7a25da9b06
Add support for restoring plain SQL database dumps. #5871
2025-03-05 18:22:44 +05:30
b59495603a
1) By Default 'Open in a new tab?' should be false.
...
2) Updated version for release v9.1
3) Updated the release note
2025-02-25 16:50:45 +05:30
636821f2ac
Added an option to open the file in a new tab within the query tool. #1235
2025-02-21 14:45:41 +05:30
a0ddfad655
Fixed an issue where deleting rows in the query tool would delete all rows in the table when 'Select All Remaining Rows' was used. #8460
2025-02-18 17:34:24 +05:30
96128f6a15
1) Enable the ability to close the 'Welcome' tab in the Query Tool/PSQL Workspace. #8436
...
2) Fixed an issue where the User Management and Change Password dialogs were hidden when selecting a menu while a workspace other than 'Default' was active. #8418
3) Revert the change of OS from Ubuntu 22.04 to 24.04 for github action failure.
2025-02-17 18:28:56 +05:30
6dd91c8277
Fixed an issue where the ERD tool fails to open a saved file containing parent-child relationship within the same table. #8389
...
Fixed an issue in ERD where link notation end-points were not rendering occasionally.
---------
Co-authored-by: Aditya Toshniwal <aditya.toshniwal@enterprisedb.com>
2025-02-17 17:37:30 +05:30
740a50680e
Fix the following SonarQube issues:
...
1. Do not use the Array index in keys
2. Visible, non-interactive elements with click handlers must have at least one keyboard listener.
3. Add replacement fields or use a normal string instead of an f-string.
4. Add a parameter to the parent lambda function
2025-02-13 11:56:10 +05:30
eb7c3ef361
Workspace Layout Update - Enhanced Query Tool and PSQL Behaviour:
...
With these changes, the Query Tool and PSQL tabs will now open in the same active workspace where the action is initiated.
2025-02-11 15:36:03 +05:30
2fc65589c8
Add support for one to one relationship in the ERD tool. #5128
2025-02-10 14:40:20 +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
1607875a08
Fixed issues for Workspaces:
...
1) Unable to add ad-hoc server with External Database.
2) Server list not updating when password is saved on the Welcome page.
3) Icons for Query Tool and PSQL missing on the Welcome page.
4) Error when removing connection parameters.
2025-01-29 17:14:25 +05:30
22b7ae6cdc
1) Fixed an issue where loadingText message is not shown in SchemaView.
...
2) Fixed SonarQube Bugs and Code Smells.
2025-01-24 13:58:21 +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
168aaa227a
Update the server list on welcome page when workspace is changed to get the latest server connection info. #7708
2025-01-20 18:45:51 +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
bf69b16f1f
1) Added the MAINTAIN privilege for PostgreSQL version 17 and above. #8332
...
2) Updated JavaScript Dependecies.
2025-01-14 14:18:07 +05:30
de6fbe7725
Fixed a button focus issue found while testing the dialog button changes. #6513
2025-01-08 17:22:11 +05:30
6dab60d9e4
Fixed an issue where copying query tool output cell is not working if any SQL text is selected. #8273
...
Rebase react-data-grid fork to latest.
2025-01-03 14:03:33 +05:30
657bf08fb8
Fixed an issue where keys like Backspace, Enter, and Input keys were shown as text in the PSQL tool. #6968
2025-01-03 12:22:24 +05:30
964d211260
Copyright updated for 2025
2025-01-01 11:26:42 +05:30
7a9a45b065
Fixed an issue where tooltip on a dropdown button is blocking access to dropdown menu. #8255
2025-01-01 10:31:48 +05:30
bcd6f3f429
Fix a formatting issue in View/Edit tool generated SQL where some filters are applied. #8254
2024-12-30 11:56:24 +05:30
91881ad6d3
Fixed an issue where option key was not registering in PSQL tool. #6968
2024-12-19 15:40:23 +05:30
8af25ba0c1
Change button labels and color in delete confirmation dialog for all objects to improve UX. #6513
2024-12-18 17:25:36 +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
e84f4cd35b
Fix an issue where view/edit tool is not opening in workspace layout.
...
Fixed few other theme related issues.
2024-12-17 17:03:37 +05:30
fe6e21a08b
Enhanced pgAdmin 4 with support for Workspace layouts. #7708
2024-12-16 14:52:56 +05:30
621a48c642
More fixes related to query tool prompting for unsaved changes when there are no changes. #8127
2024-12-05 19:03:31 +05:30
bd2a484c2f
Added support for adding tags on a server node. #8192
2024-12-05 12:18:26 +05:30
256d1e55c8
Fixed an issue where doing Ctrl/Cmd+C on a selected text in a cell editor of data output in the query tool copied the complete text. #8157
2024-12-04 11:32:01 +05:30
190574b3af
Fix issues more scenarios related to crypt key missing on backend server restart. #8065
2024-11-29 12:05:46 +05:30
657b0f82ec
Fixed an issue where query tool throws syntax error if a newly added row is untouched and saved. #8028
...
Fixed an issue where auto-width of wide columns in data output is incorrectly calculated. #8158
2024-11-28 14:18:13 +05:30
88e515093c
Show auto-complete column names in filtered rows dialog of table and filter options of view/edit data tool. #3751
...
Allow setting NULL ordering for columns in view/edit data filter dialog. #3317
2024-11-28 10:13:57 +05:30
9ef5a53790
Add a user preference to enable/disable alternating row background colors in the data output of query tool. #8134
...
Fixed some theme related issues.
2024-11-27 11:23:13 +05:30
ea693396b8
Update MUI from v5 to v6
2024-11-25 16:36:21 +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
042888f5d7
Fixed an issue where ERD auto-layout should: #6592 ( #8167 )
...
- Always generate right-angled links
- Switch port to Left/Right for the best link route.
2024-11-22 16:26:50 +05:30
f23fe38e0b
Update release notes.
2024-11-21 10:59:08 +05:30
321366489d
Fixed an issue where query tool should show results and messages only from the last executed query. #8010
...
Fixed an issue where query tool should not prompt for unsaved changes when there are no changes. #8127
2024-11-21 10:52:43 +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
c5d5fbdafd
Fixed an issue where Ctrl/Cmd + A was not selecting all data in query tool data grid. #5099
2024-11-14 16:56:03 +05:30
9a8d520abd
Fix few issues found in menu rendering code and GUI test cases
2024-11-14 14:49:07 +05:30
00d3aaa1fd
Refactor menu building code to support sub-menus of any depth
2024-11-14 13:36:42 +05:30
f9d881ffa6
Fix GUI test cases failing because of previous commit
2024-11-08 18:09:39 +05:30
6fcc4ae6a2
More fixes for issues found while testing query tool pagination changes. #1780
2024-11-08 15:48:24 +05:30
3417186df7
Fix issues found while testing pagination changes. #1780
2024-11-07 18:02:39 +05:30
772c6ecd84
Remove the dependency on python packages eventlet and greenlet. #8102
2024-11-07 16:45:18 +05:30
a9bfa8a71d
Fix multiple issues related to debugger params dialog input. #7883
...
- Handle multiple possible values for a boolean parameter.
- Disable value input when "Use default" is enabled.
2024-10-29 16:01:46 +05:30
4d7fc8be52
Resolved issues reported during testing of #7655 .
2024-10-18 13:05:59 +05:30
5d008f0525
Fixed an issue where the query tool was crashing when an empty geometry was being rendered. #7655
2024-10-17 14:13:40 +05:30
b0d4200aa0
Few UX improvements in query tool pagination. #1780
2024-10-15 16:25:39 +05:30
7d12dc3b80
Remove unused variable from Debugger.
2024-10-10 17:54:15 +05:30
7a7782a350
Fixed an issue in the debugger where function arguments of the character data type were being truncated. #8007
2024-10-10 15:25:08 +05:30
b649094d36
Fix the issue where rows do not retain shading when scrolling. #8013
2024-10-10 15:19:24 +05:30
509c696aa3
Fixed an issue where the copy shortcut was not working in the Query Tool data grid. #7920
2024-10-09 17:06:51 +05:30
9169d3d4bf
Fixed an issue where cursor selection is not visible in the PSQL tool. #7957
2024-10-09 14:42:30 +05:30
d736f4266c
Fixed an issue where default EOL in the query tool should be based on the OS. #7393
2024-10-03 17:29:58 +05:30
c6d7a0a8da
Add missing eslint React rules and fix the linter errors.
2024-10-01 16:32:04 +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
f8fb78be11
1) Alternate the background color of rows to enhance readability. #2874
...
2) Make the background color for the serial number and header cells distinct. #7863
2024-10-01 12:21:44 +05:30
f0ecc95ca9
Fixed an issue to allow the Enter key to save data in the result grid text editor. #5307
2024-09-27 12:18:07 +05:30
0e63914ab3
Fixed an issue where the copy shortcut CTRL +C was not working in the Query Tool data grid. #7920
2024-09-27 12:17:21 +05:30
4cb0f87dfd
Added support for auto-detecting and setting the End-of-line character (LF/CRLF) in the query tool editor. #7393
2024-09-24 16:39:08 +05:30
1f53baee8f
Fixed the dynamic column updation in the Unique & Primary Keys while creating a table.
...
* Updated the columns for the unique and primary keys while creating a table.
Use the 'editable' option for a Cell instead of 'disabled'.
* Don't need to define the hidden member as fields in GridHeaderSchema
* Updated the columns for the exclusion constraints while creating a
table.
* Signaled the relevant field, when column options have changed, for all
the children of a table.
* Use current snapshot of data for the GrigFormHeadeer
* Fixed the styling for the search input box
* Don't check for the 'colOptions.editable' flag, as it could be
indirect call as well.
2024-09-19 18:57:09 +05:30
38d4728333
Fixed an issue where the query is not getting executed after giving a password and connecting to the server on the not saved password server. #6502
2024-09-18 20:55:29 +05:30
b0cd028ff8
Fixed an issue introduced due to reloading of the tree due to changes in particular preferences ( #7942 )
...
* Fix an issue - when the object browser tree is being recreated due to reloading for changes in some of the preferences. Tree object returns object from the previous instance as 'selected', but - it does not have the 'treeNodeInfo' available. In this special case - we would consider that there is no node selected at that particular moment, and pass information accordingly.
* Fixed 'New Connection' dialog issue after connecting a disconnected server.
* Disable the 'Add' button in the GridHeader with form, when 'canAdd'
flag is set to false.
* Convert the access path to string array for correct comparision.
* Check the access path type before comparison.
When language is 'c', set the 'code' block read-only.
* Enabled 'Strict' control for EPAS >= 95
2024-09-18 20:55:01 +05:30
441cc57bb8
Don't show 'Types of objects' for the 'Cluster' operation. Fixes #7884
2024-09-18 07:48:09 +05:30
a361fd94ff
Fixed an issue where the query gets executed automatically when the query tool opened using Create Script, Schema Diff.
2024-09-18 07:47:20 +05:30
315d1a40a4
Fixes issues #7884
...
* Introduced a 'exclude' option in the 'Field' to exclude it from the
change completely. Use the option 'exclude' to add field
'notNullColumns', which will be excluded from the data, but - can be
used to force rerender the 'Not Null Columns' select control on
change of it.
* Fixed the linter issue
* Rerender the cell as well, when dependent changes values. (#7884 )
* Listen for the depenent changes even for the non-visible controls
* Use 'useRef' on every rendering to avoid the React 'Something wrong' page
2024-09-16 17:55:43 +05:30
Akshay Joshi
Pravesh Sharma
Aditya Toshniwal
Rohit Bhati
Kijong Han
Khushboo Vashi
Mike Christensen
Yogesh Mahajan
Anil Sahoo
Ashesh Vashi