038029eb2d
Italian translation for v9.3
2025-04-24 18:43:33 +05:30
a14cc1bd77
Updated message catalogs for v9.3.
2025-04-24 16:19:42 +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
75dc42cf24
Allow OAuth 2 login using the username claim if the email is absent from the user profile. #8652
2025-04-23 15:21:25 +05:30
ec3d142ad9
Fix issues while testing role permissions feature. #7310
2025-04-21 15:14:18 +05:30
280f0b0038
Revert "Rebase fork pgadmin-org/react-data-grid to get latest changes and update pgAdmin package.json"
...
It requires React 19.
This reverts commit 7307c52250
2025-04-21 15:12:27 +05:30
7307c52250
Rebase fork pgadmin-org/react-data-grid to get latest changes and update pgAdmin package.json
2025-04-21 13:48: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
934f17c65e
Ensure that the server list is alphabetically sorted in the Query Tool/PSQL workspace. #8636
2025-04-15 16:12:49 +05:30
7b1ad5fa67
Fixed an issue where changes to foreign key constraints were not detected in the schema diff. #8627
2025-04-15 11:46:12 +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
8a0eae2bb0
Fixed an issue where drag and drop function with no parameters does not work. #8613
2025-04-14 12:57:26 +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
bbef00a151
Fixed an issue where the scroll position in the Object Explorer was not retained when switching workspaces. #8497
2025-04-07 13:31:00 +05:30
627aa5d695
Added ability to use SQL in the 'DB Restriction' field. #2767
2025-04-04 15:53:12 +05:30
0d8b3c4389
Ensure that graph data is updated even when the Dashboard tab is inactive. #8556
2025-04-04 11:39:37 +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
73fefb8603
Fixed an issue where query tool is crashing on macOS 15.4 due to a locale issue. #8623
2025-04-02 15:15:23 +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
1305d9910b
Fixed an XSS vulnerability issue in the Query Tool and View/Edit Data (CVE-2025-2946). #8602
2025-03-31 11:30:26 +05:30
6a850fff10
Czech translation for version 9.2
2025-03-31 11:10:19 +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
0eb8d6c8d6
Italian translation update for v9.2
2025-03-28 12:18:00 +05:30
a2b35b35f3
Fixed an issue where the query tool data grid did not respect the default value for columns of domain type when the domain had a default value. #8483
2025-03-28 10:38:30 +05:30
f250f5de5e
Fixed an issue where delete/rename was done on the wrong file after sorting in Storage Manager. #8597
2025-03-28 10:31:11 +05:30
fa60ab0f6a
Updated message catalogs.
2025-03-27 19:23:57 +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
cb597d0acb
Fixed an issue where the upgrade_check API returned an unexpected keyword argument 'cafile' due to changes in the urllib package supporting Python v3.13. #8577
2025-03-25 11:44:23 +05:30
a5993549b8
Disable controls for shared servers that cannot be edited by the users.
2025-03-24 14:30:56 +05:30
13b44fffc7
Add an ability to configure the font family for SQL editors. #392
2025-03-24 11:08:49 +05:30
fc1a1610a3
Ensure the newly added parameters in the server dialog are incorporated into the Import/Export Servers functionality. #8514
2025-03-20 15:49:43 +05:30
47eca9a19c
Fixed an issue where updating the grantee was not correctly applying the privileges. #8546
2025-03-20 15:35:46 +05:30
f635df6ccf
Added support for post-connection SQL execution, which will be run automatically on each connection made to any database of the server. #4503
2025-03-18 16:54:38 +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
797bdb8696
Fixed directory owner update & UI issues. #8034
2025-03-17 12:22:06 +05:30
c80be9b3a3
1) Align cancel query icon properly on the Dashboard.
...
2) Update release note.
2025-03-13 16:37:24 +05:30
be534be674
Update the stop/terminate icon at all the places for better UX. #8473
2025-03-12 12:31:23 +05:30
846d0eafe6
Change session files garbage collection strategy. #8335
...
Currently GC for session files is done by the /misc/cleanup endpoint which requires browser UI
to be running. With this change, the pgAdmin server will open a separate thread at a fixed frequency
which will take care of GC independently.
2025-03-11 16:32:30 +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
df5dced926
Change icon buttons to show tooltip even when disabled. #8449
2025-03-08 11:48:08 +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
cf2328d2cd
Fixed PEP8
2025-03-04 15:49:41 +05:30
7bae1eb663
Added support for creating Directory nodes in EPAS. #8034
2025-03-03 18:45:21 +05:30
4791897578
Fixed an issue where the Schema Diff was not displaying the difference query when a table had a UNIQUE NULLS NOT DISTINCT constraint. #8479
2025-03-03 18:39:09 +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
b983b094a3
Fixed an issue where drop-down menus were hidden behind the dock. #8439
2025-02-20 12:12:29 +05:30
53077b6c04
1) Updated chart.js to 4.4.7
...
2) Fixed an issue where Default Workspace and Preferences button is disabled when
selecting any node from object explorer.
2025-02-19 16:12:17 +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
35d6277f00
Rename all '10_plus' folders to 'default' as modulewise RESQL tests are not running.
2025-02-18 13:07:03 +05:30
85290d4e61
Fixed an issue where the column order displayed was incorrect for exclusion constraints with multiple columns. #8430
2025-02-18 11:57:42 +05:30
48a26e8979
Ensure the saved passwords are decrypted with the correct encryption key for external authentication in server mode. #8435
2025-02-18 11:54:57 +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
e2a80b2465
Fixed an issue where pasting text containing JSON data into the query tool grid would result in incorrect parsing. #8296
2025-02-17 17:41:05 +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
83ade5dcc2
Update the query that fetches roles to be faster with many roles.
...
This changes the query that fetches roles from using the
pg_catalog.shobj_description function to using an explicit join on
pg_catalog.pg_shdescription. In my specific case, in a production system with
over 20k roles, this reduces the query time down from 8 minutes(!) down to
~40ms. Just in case it was a locking issue, I did use pg_activity to
investigate locks, and nothing was being blocked during the 8 minutes.
This fixes a problem that exists only for certain users, and specifically in my
case where the user that runs the query is themselves a member (directly and
indirectly) of a high number of roles. Running the existing query as a user
that has a low number of roles (and specifically, the master user in an AWS RDS
database), the existing query is fairly performant.
My best explanation as to the performance difference comes from the definition
of shobj_description
2a8a00674e/src/backend/catalog/system_functions.sql (L303-L312)https://github.com/pgadmin-org/pgadmin4/pull/8457#issue-2853052114 for
EXPLAIN ANALYZE results of the existing query and the updated query.
2025-02-17 17:20:28 +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
f63190dc93
Fixed an issue where pgAdmin does not support pg_vector column length/precision. #8181
2025-02-12 16:14:31 +05:30
58bb14253e
Revert changes from the previous commit to restore the 'Object Explorer' title.
2025-02-11 20:18: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
2c37ff2893
Fixing following SonarQube Issues:
...
1. Ternary operators should not be nested.
2. "Exception" and "BaseException" should not be raised.
2025-02-11 12:03:43 +05:30
650a15beec
Fixed an issue where the query tool was not treating IDENTITY columns as columns with default values when inserting new rows. #8341
2025-02-10 15:05:09 +05:30
2fc65589c8
Add support for one to one relationship in the ERD tool. #5128
2025-02-10 14:40:20 +05:30
bf7f8cdd73
1) Added missing GLOBALLY_DELIVERABLE config parameter in the config.py from the last commit.
...
2) Fixed API test cases for DBMS_JOB_SCHEDULER
2025-02-07 13:36:11 +05:30
ae76ea3585
Fixed Docker image entrypoint.sh email validation. #8410
...
Introduces a GLOBALLY_DELIVERABLE variable so that it can be passed to the email validator library
and ultimately allowing the email admin@localhost to be valid, as long as False is passed in.
Also:
* Adjusted the indentation of a command above it in the entrypoint.sh
* Added printing out the output of the validation library so that we can better find what the actual issue is
2025-02-07 12:34:23 +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
2f495006ea
1) Fixed an issue where the server shows disconnected on the Welcome page, even after the password was provided.
...
2) Updated the release notes and version information.
2025-02-03 14:26:57 +05:30
dd09986f71
Fixed an issue where quotes were missing in the CREATE script for the tablespace. #8408
2025-02-03 11:50:50 +05:30
41873de29e
Czech translation for version 9.0
2025-02-03 10:31:31 +05:30
92c9e59c1f
1) Update version for v9.0
...
2) Update message catalogs for v9.0
2025-01-30 18:16:05 +05:30
d5101b7568
1) Disable PSQL Workspace in Server mode.
...
2) Fixed an issue where empty binary path throwing an error instead of proper error message.
2025-01-30 17:59:18 +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
ebeb768a53
Ensure the double-click event is listened to even if the user clicks after the label.
2025-01-30 10:26:11 +05:30
228156d0b6
1) Fixed an issue where the ad-hoc server with SSH Tunnel repeatedly prompted for the password.
...
2) Fixed an issue where the SSH Tunnel password was not being saved in the External Database if its encoded length exceeded 64 characters.
3) 'Save Password' check box should be hidden for SSH Tunnel password on the Welcome page.
2025-01-29 19:43:23 +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
1317e5a921
Change the logic of setval function, so that the next nextval of sequence will return exactly the specified value. #3273
2025-01-28 17:52:21 +05:30
1e00611792
Add support for OAuth2 profile array response, which also takes care of the GitHub Private Email ID issue. #8391
2025-01-28 16:53:56 +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
684818def1
Ensure that the Server List on the Welcome page is refreshed only when there are changes in the Object Explorer.
2025-01-23 14:51:39 +05:30
5ee0328063
Fix an error during logout from pgAdmin when using OAuth2 authentication with the query tool open.
2025-01-22 21:05:06 +05:30
84a8a522e3
1) Fixed an issue where Default Privileges and Privileges not working correctly. #8369
...
2) Fixed <br/> tag visible issue.
2025-01-22 19:40:13 +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
90eff9a596
Pass an empty string for the table cell tooltip if the cell value is an object.
2025-01-20 16:53:01 +05:30
98f6b1ff12
Ensure the double-click event is not ignored in the browser tree.
2025-01-20 11:21:21 +05:30
a410b15e30
Fixed an issue where <br/> tag is visible in the error message when delete any database and it is in use.
2025-01-17 17:16:36 +05:30
72a3ed9068
Do not display the tooltip if the table cell value is an object.
2025-01-17 15:32:11 +05:30
1be0ff13db
Update prop on confirmDelete to fix TypeError. #6513
2025-01-17 14:53: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
36df6d5c8a
Fix an issue where using the binary cursor, utf-8 decode error comes up. #8199
2025-01-13 12:23:50 +05:30
a9974b418c
Fixed an issue where cell background color is removed when copied in query tool data output grid. #8273
2025-01-09 15:37:20 +05:30
de6fbe7725
Fixed a button focus issue found while testing the dialog button changes. #6513
2025-01-08 17:22:11 +05:30
172edaa227
Fix an issue where wrong information is shown after using the filter on the Dashboard> State tab. #8320
2025-01-08 12:43:50 +05:30
bac50e10f0
1) Fixed an issue where User Language is not getting changed.
...
2) Fixed an issue where Import/Export Server menu is disabled.
3) Update few JavaScript dependencies.
2025-01-07 13:55:02 +05:30
b9c7e7e9af
Remove the option "With no data (concurrently)" from Refresh MATERIALIZED VIEW context menu. #8309
2025-01-07 12:22:07 +05:30
8c461ffb86
Reverted changes for formatted exception message. #8165
2025-01-06 17:46:34 +05:30
90cdeeff0a
Modified logic for formatted exception message. #8165
2025-01-03 20:56:47 +05:30
6d45dd4491
Ensure master password pop up is not shown on setting MASTER_PASSWORD_REQUIRED to false. #8299
2025-01-03 20:50:32 +05:30
b22bfdf74b
Only the python version should be shown in the about dialog. #8249
2025-01-03 20:49:56 +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
ff1d9e20d1
Fixed an issue where error message from the database server need space between two sentences. #8165
2025-01-02 18:14:51 +05:30
d03553be7a
Fix the error occurring while loading preferences on startup. #8256
2025-01-02 18:12:24 +05:30
5dc52446f3
Fixed the issues reported while testing #8208
2025-01-02 15:47:25 +05:30
eb517e6df8
Fixed following issues for Workspace:
...
1. On the welcome page, the Password should be cleared when the user/db is changed.
2. Added a spinner when we tried to connect to the existing remote server.
3. Details should be cleared when we select the existing server but cancel when it asks for the password.
4) Return from the chageWorkspace function if clicking on the same workspace button multiple times.
2025-01-02 13:24:13 +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
700ecaef4a
Show the python version used for the pgAdmin server in the about dialog. #8249
2025-01-01 10:28:58 +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
9cd8492ec1
Fixed an issue where Schema Diff not produce difference script for Index definition with where condition. #8072
2024-12-19 16:40:18 +05:30
6df5d14a60
Fixed an issue where properties dialog throwing an error for Materialized View. #8209
2024-12-19 15:55:23 +05:30
91881ad6d3
Fixed an issue where option key was not registering in PSQL tool. #6968
2024-12-19 15:40:23 +05:30
e011ad02a5
Remove console log
2024-12-18 18:43:04 +05:30
fdf5d12196
1) Fixed schema diff workspace button is disabled for the first tab.
...
2) Adhoc servers should connect with service file and open the Query/PSQL tool.
2024-12-18 18:19:13 +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
a0cd6c6a88
Allow deleting the entry while creating/adding new label to enumeration type. #8208
2024-12-16 14:54:24 +05:30
fe6e21a08b
Enhanced pgAdmin 4 with support for Workspace layouts. #7708
2024-12-16 14:52:56 +05:30
9e58717321
Fix text wrapping issue for tags feature. #8192
2024-12-09 18:04:47 +05:30
09e13b2f37
Czech translation for version 8.14
2024-12-09 11:33:50 +05:30
60078c37a3
Add a new config MAX_SERVER_TAGS_ALLOWED to limit the number of tags on server node. #8192
2024-12-06 12:16:15 +05:30
50cf6489b9
Italian translation updated for v8.14
2024-12-06 11:34:10 +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
c841c82220
Update message catalogs for v8.14
2024-12-05 18:40:39 +05:30
22b89265d6
Ensure CSRF errors handled to return unauthorized response. #8065
2024-12-05 16:54:35 +05:30
e2c20b5022
Fixed an issue where a column name change in the edit dialog of the table node does not show the updated column name. #7892
2024-12-05 16:53:50 +05:30
bd227e03bd
Fix an issue where pgAdmin crashes on accessing the dashboard state tab when database is super busy. #7809
2024-12-05 15:00:35 +05:30
bd2a484c2f
Added support for adding tags on a server node. #8192
2024-12-05 12:18:26 +05:30
5e8a75cdf9
Added escaping for the placeholder parameters before passing it to the passexec command. #6794
2024-12-04 15:42:45 +05:30
d8ed75dbfd
Ensure correct custom SSL certificate passed in connection string. #8215
2024-12-04 15:38:27 +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
42018e69a5
Add support to deploy pgAdmin in container with readOnlyRootFilesystem to true. #7330
2024-12-03 17:50:20 +05:30
6810fa6ce6
Add support for passing connection details as placeholders in the passexec command. #6794
...
Added a fix where electron app menu was not refreshing when node selection changed.
2024-11-29 17:54:07 +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
Domenico Sgarbossa
Aditya Toshniwal
Pravesh Sharma
Yogesh Mahajan
Akshay Joshi
Rohit Bhati
Kijong Han
Khushboo Vashi
Mike Christensen
Libor M.
Anil Sahoo
Chris Bandy
Michal Charemza
Igor Serko
Kristof Hauser