7c2b773ad1
Allow the user to set a master password if an error occurs while accessing the OS secret storage.
2025-06-25 17:11:52 +05:30
08d250e5ef
1. Fixed issues reported while testing changes for editor preferences. #2659
...
2. Updated preferences docs.
2025-06-19 16:09:39 +05:30
f07eabedbe
Ensure that restored query tool tabs display the correct title. #3319
2025-06-19 12:12:54 +05:30
1e0e9c4f7d
1) Open preferences in a new tab instead of a dialog for better user experience. #6743
...
2) Add a search box to enable searching within the preferences tab. #2864
2025-06-12 19:03:54 +05:30
814250aade
Added role-based restrictions for editing server connections. #1947
2025-06-10 12:19:41 +05:30
4cd331f0ca
Fixed an issue where the Columns node was not visible under Catalog Objects. #8834
2025-06-06 12:34:20 +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
7504f6216a
Fixed an issue where the Schema Diff Tool incorrectly reported differences due to variations in the order of the privileges. #8032
2025-05-29 19:08:56 +05:30
4e8f29f328
Fixed an issue where light theme briefly appears when pgAdmin loads or tools open, even when a dark or system UI theme is preferred. #8711
2025-05-20 10:36:29 +05:30
78d9aa5b76
Fixed issue found while testing PostGIS spatial type constructor support. #2256
2025-04-25 11:13:18 +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
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
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
627aa5d695
Added ability to use SQL in the 'DB Restriction' field. #2767
2025-04-04 15:53:12 +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
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
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
a5993549b8
Disable controls for shared servers that cannot be edited by the users.
2025-03-24 14:30:56 +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
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
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
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
f63190dc93
Fixed an issue where pgAdmin does not support pg_vector column length/precision. #8181
2025-02-12 16:14:31 +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
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
dd09986f71
Fixed an issue where quotes were missing in the CREATE script for the tablespace. #8408
2025-02-03 11:50:50 +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
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
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
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
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
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
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
b9c7e7e9af
Remove the option "With no data (concurrently)" from Refresh MATERIALIZED VIEW context menu. #8309
2025-01-07 12:22:07 +05:30
5dc52446f3
Fixed the issues reported while testing #8208
2025-01-02 15:47:25 +05:30
964d211260
Copyright updated for 2025
2025-01-01 11:26:42 +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
Akshay Joshi
Pravesh Sharma
Yogesh Mahajan
Aditya Toshniwal
Rohit Bhati
Anil Sahoo
Michal Charemza