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
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
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
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
627aa5d695
Added ability to use SQL in the 'DB Restriction' field. #2767
2025-04-04 15:53:12 +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
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
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
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
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
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
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
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
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
4dbfdd8740
Added an EPAS 17 resql test case for builtin locale provider. #8095
2024-11-21 11:21:05 +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
9a8d520abd
Fix few issues found in menu rendering code and GUI test cases
2024-11-14 14:49:07 +05:30
296befc881
Code refactoring at multiple places to improve re-usability
2024-11-14 14:16:38 +05:30
00d3aaa1fd
Refactor menu building code to support sub-menus of any depth
2024-11-14 13:36:42 +05:30
Aditya Toshniwal
Rohit Bhati
Akshay Joshi
Pravesh Sharma
Michal Charemza
Yogesh Mahajan
Anil Sahoo