Commit Graph

2319 Commits (master)

Author SHA1 Message Date
Pravesh Sharma 2fc65589c8
Add support for one to one relationship in the ERD tool. #5128 2025-02-10 14:40:20 +05:30
Akshay Joshi 0b46bdf901 1) Updated Javascript and Python dependencies.
2) Added release note for v9.1
2025-02-07 11:52:08 +05:30
Akshay Joshi 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
Akshay Joshi 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
Kristof Hauser 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
Akshay Joshi 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
Akshay Joshi cd86ce08cf Fixed an issue where pgadmin cannot install into path with non ASCII characters. #5204 2025-01-20 16:04:07 +05:30
Akshay Joshi 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
Akshay Joshi 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
Akshay Joshi 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
Akshay Joshi 90cdeeff0a Modified logic for formatted exception message. #8165 2025-01-03 20:56:47 +05:30
Aditya Toshniwal 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
Akshay Joshi 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
Akshay Joshi 964d211260 Copyright updated for 2025 2025-01-01 11:26:42 +05:30
Aditya Toshniwal c83d997f2f Make depedabot use Python v3.8.
Update release notes.
2025-01-01 10:42:49 +05:30
Akshay Joshi 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
Akshay Joshi 6df5d14a60 Fixed an issue where properties dialog throwing an error for Materialized View. #8209 2024-12-19 15:55:23 +05:30
Akshay Joshi 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
Akshay Joshi 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
Yogesh Mahajan eef20dc5a9
Correct the documentation for the MFA configuration. #8142 2024-12-17 11:50:25 +05:30
Akshay Joshi ba58b140d4 Updated version of liblz4 in Docker file. 2024-12-16 14:58:47 +05:30
Akshay Joshi fe6e21a08b
Enhanced pgAdmin 4 with support for Workspace layouts. #7708 2024-12-16 14:52:56 +05:30
Akshay Joshi 72a4f93e4f Updated version for release v8.14 2024-12-09 11:51:07 +05:30
Yogesh Mahajan 1cf9ced260
Fixed the issues reported while testing #7330. 2024-12-06 12:08:24 +05:30
Akshay Joshi c841c82220 Update message catalogs for v8.14 2024-12-05 18:40:39 +05:30
Khushboo Vashi 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
Akshay Joshi 413202899f Update release note. 2024-12-05 12:23:29 +05:30
Aditya Toshniwal bd2a484c2f
Added support for adding tags on a server node. #8192 2024-12-05 12:18:26 +05:30
Aditya Toshniwal 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
Khushboo Vashi 46c7562ed2
Update release note. 2024-12-03 17:52:39 +05:30
Yogesh Mahajan 42018e69a5
Add support to deploy pgAdmin in container with readOnlyRootFilesystem to true. #7330 2024-12-03 17:50:20 +05:30
Pravesh Sharma 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
Aditya Toshniwal 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
Aditya Toshniwal 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
Pravesh Sharma 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
Aditya Toshniwal da530824d6 Fixed an issue where indent with space was not aligning to next tab position. #7486 2024-11-25 16:42:07 +05:30
Khushboo Vashi 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
Akshay Joshi ec197c68b8 Updated release note. 2024-11-21 15:58:26 +05:30
Yogesh Mahajan 026c0d2389
Ensure the crypt key is retrieved correctly on backend server restart. #8065 2024-11-21 15:55:38 +05:30
Akshay Joshi 032583e280 Updated release note. 2024-11-21 11:56:30 +05:30
Aditya Toshniwal f23fe38e0b Update release notes. 2024-11-21 10:59:08 +05:30
Aditya Toshniwal 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
Akshay Joshi 64399901ad Added release note for 8.14 2024-11-14 13:23:58 +05:30
Pravesh Sharma 0aba9703cd
Added support for a builtin locale provider in the Database dialog. #8095 2024-11-14 13:20:01 +05:30
Aditya Toshniwal 947dbf6d0a Update release notes. 2024-11-07 22:02:18 +05:30
Aditya Toshniwal 44dc78f4df - Update few JS dependencies.
- Update runtime documentation page.
2024-11-04 13:47:30 +05:30
Akshay Joshi 25c3142586 Updated python packages. 2024-11-02 17:39:15 +05:30
Aditya Toshniwal a44424d5fa Update release notes 2024-10-31 19:23:49 +05:30
Khushboo Vashi 8b354aec1d
Update Release Notes. 2024-10-19 10:48:18 +05:30
Akshay Joshi f819841430 Update the release note. 2024-10-17 17:33:08 +05:30
Akshay Joshi 867b2a5149 Updated version for release v8.13 2024-10-14 16:20:54 +05:30
Akshay Joshi 17883fbd84 Use PG17 as the default in the container. #8022 2024-10-10 15:55:43 +05:30
Rohit Bhati b649094d36
Fix the issue where rows do not retain shading when scrolling. #8013 2024-10-10 15:19:24 +05:30
Aditya Toshniwal 8c45dea975 Fixed an issue where graphical explain keeps the node details open even after plan changed. #7993 2024-10-10 10:50:11 +05:30
Aditya Toshniwal 9169d3d4bf Fixed an issue where cursor selection is not visible in the PSQL tool. #7957 2024-10-09 14:42:30 +05:30
Tomas Dabašinskas f1e48b719d
Fix a typo in docs for google oauth2
It should probably be `userinfo`, not `useinfo` 🙂
2024-10-07 19:05:46 +05:30
Akshay Joshi 081bebaf80 Update release note. 2024-10-07 11:47:31 +05:30
Akshay Joshi 6c3f0a4606 1) Updated French Translation.
2) Updated release note.
2024-10-04 12:26:37 +05:30
Akshay Joshi 485c654c6e Updated release note. 2024-10-01 16:16:47 +05:30
Aditya Toshniwal 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
Akshay Joshi 28eb2c0b4b Update release note. 2024-09-27 16:25:51 +05:30
Akshay Joshi 0ab5e0d4ef Update release note. 2024-09-24 19:44:28 +05:30
Rohit Bhati 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
Akshay Joshi b757d26933 1) Update JS and Python dependencies from Dependabot.
2) Added new release note file.
2024-09-23 16:33:20 +05:30
Khushboo Vashi a0aa185518 Fixed a security issue where the OAuth2 client ID and secret exposed through the web browser (CVE-2024-9014). #7945 2024-09-20 08:45:37 +05:30
Aditya Toshniwal 53cdc80df2 Add a new config variable - ALLOW_SPECIAL_EMAIL_DOMAINS to allow special domains for pgAdmin user emails. #6222 2024-09-19 10:51:06 +05:30
Aditya Toshniwal 100f59f78b Fixed an issue where "Quit App" confirmation modal in desktop app is not respecting "Confirm on close or refresh?". #7890 2024-09-18 16:43:57 +05:30
Akshay Joshi acb0eb2141 Update version for release v8.12 2024-09-16 17:57:07 +05:30
Akshay Joshi d81bd595aa Updated release note 2024-09-11 13:07:13 +05:30
Akshay Joshi d8381918a7 Updated release note. 2024-09-09 14:35:41 +05:30
Khushboo Vashi 6563067892
Update release notes. 2024-09-02 15:09:34 +05:30
Akshay Joshi 61413c1902 Update release note. 2024-08-30 12:27:03 +05:30
Pravesh Sharma f88ca891fa
Added feature to restore preferences to their default values. #1900 2024-08-30 12:24:24 +05:30
Aditya Toshniwal 1a1734cf5c Allow running non-continuous selected SQL code blocks in the query tool. #7293 2024-08-29 12:41:58 +05:30
Akshay Joshi 96ce010635 Added release note for v8.12 2024-08-22 17:47:40 +05:30
Aditya Toshniwal ba87cbecfd Update release notes. 2024-08-19 15:17:24 +05:30
Aditya Toshniwal 242dd48cbd Improve code highlighting in query editor. #7748 2024-08-14 16:48:51 +05:30
Aditya Toshniwal b00ea3cd99 Update release notes. 2024-08-14 11:12:30 +05:30
Akshay Joshi 00e2480b7b
1) Fixed an issue where refreshing the Schema Diff tool opened in a new tab caused an error. #7499
2) Fixed an issue where the Generate Script ignored filter conditions when a parent node was selected. #7682
2024-08-08 13:02:38 +05:30
Khushboo Vashi f98e3fa1fd
Update release note. 2024-08-07 14:50:55 +05:30
Akshay Joshi 88f033e2a8 Update release note 2024-08-01 11:38:23 +05:30
Akshay Joshi d39fe78239 Added release note for v8.11 2024-07-31 11:34:29 +05:30
Pravesh Sharma 0399d0be15
Updated the documentation for web server authentication. #7728 2024-07-31 11:26:19 +05:30
Akshay Joshi 8cf15ea17c Change the release date in the release note. 2024-07-24 15:47:42 +05:30
Khushboo Vashi bc10fa5c03 Fix an issue where a cloud instance deployment fails due to wrong import. 2024-07-24 15:34:30 +05:30
Akshay Joshi eff63931f2 Update message catalogs. 2024-07-19 15:23:19 +05:30
Rohit Bhati 8030bc708b
Add support for highlighting selection matches in the query editor. #7530 2024-07-18 17:51:20 +05:30
Khushboo Vashi fd78faf0cc
Update release notes. 2024-07-18 14:30:45 +05:30
Khushboo Vashi c9cc5257c7 Fix Server Log minor UI issues. 2024-07-18 09:40:49 +05:30
Aditya Toshniwal 3b4fa40253 Update release notes. 2024-07-17 18:22:51 +05:30
Rohit Bhati 9ee896aac4
Add a keyboard shortcut to close active tab panel. #6572 2024-07-17 18:19:36 +05:30
Akshay Joshi 64d7c2c62d Update release notes. 2024-07-16 17:52:15 +05:30
Aditya Toshniwal cd6ff48cc0 Fix query tool, ERD closing issue in Electron. #7494 2024-07-10 15:01:35 +05:30
Khushboo Vashi 8578acd915
Update release notes. 2024-07-09 12:57:48 +05:30
Anil Sahoo 5c5b61c4db
Fixed an issue where paste operation in query tool data grid should skip bytea columns and put the value as NULL instead. #3199 2024-07-09 10:33:29 +05:30
Khushboo Vashi 4f415f9768
Added support for viewing PostgreSQL Server Logs in Text, CSV and JSON formats. #3981 2024-07-03 16:17:29 +05:30
Akshay Joshi 93b5bc6bf8 Update release note. 2024-07-03 11:54:49 +05:30
Akshay Joshi 576dc55615
Fixed the permission denied issue for functions of the pgstattuple extension when accessing statistics with a non-admin user. #7035 2024-07-02 11:47:43 +05:30
Aditya Toshniwal f8fa1cf6d6
- Fix few SonarQube issues.
- Cleanup NW.js related stuff.
2024-07-02 10:34:30 +05:30
Akshay Joshi 6f8cde67a6 Update release note. 2024-06-28 15:09:34 +05:30
Akshay Joshi ccd84b7c2a Update JS packages. 2024-06-27 14:08:01 +05:30
Akshay Joshi 3be2221948 Ensure that pgAdmin 4 is compatible with PostgreSQL v17. #7537 2024-06-27 13:18:26 +05:30
Akshay Joshi 9933a9a9e5 Update version for release v8.9 2024-06-24 20:10:25 +05:30
Aditya Toshniwal 44d40f0785 Fixed an issue where delete button in Users data was enabled for incorrect rows. #7616 2024-06-24 10:31:47 +05:30
Akshay Joshi 3e7a220225 Fixed an issue where the schema diff incorrectly marked tables as different due to schema-qualified trigger functions in the trigger definitions. #7523 2024-06-20 16:55:38 +05:30
Aditya Toshniwal 31a91409a0 Fixed incorrect sorting of size in statistics tab. #7542 2024-06-19 18:27:43 +05:30
Aditya Toshniwal 20caa63508 Fixed an issue where query tool auto-complete stops working after connection change. #7593 2024-06-19 17:55:40 +05:30
Akshay Joshi 2b04f3ca1d Fixed incorrect handling of the code smell for the reject API call 2024-06-17 18:22:38 +05:30
Aditya Toshniwal c3d6f8887a Fixed an issue where syntax highlighting is incorrect for C-Style escape string. #7485 2024-06-17 17:05:36 +05:30
Aditya Toshniwal 439d6cb28f Fixed an issue where backslash breaks syntax highlighting. #7528 2024-06-17 16:16:15 +05:30
Akshay Joshi 5866da8194 Fixed SonarQube code smells. 2024-06-13 18:48:02 +05:30
Aditya Toshniwal ad34ee2699 Fixed new line indentation in query editor and add a user preference to disable it. #7295 2024-06-13 18:06:13 +05:30
Akshay Joshi dea5335ce5 Fixed the following SonarQube code smells:
1) Do not use the Array index in keys.
2) Import from the same module should be merged.
3) Mutable variables should not be exported.
4) Variables should not be initialized to undefined.
5) startswith or endswith method should be used.
6) Unwrap this unnecessarily grouped subpattern.

Additionally, addressed many other SonarQube rules.
2024-06-12 18:09:06 +05:30
Rohit Bhati 288fd7ed12
Add support for comments on RLS policy object. #7414 2024-06-12 17:18:55 +05:30
Aditya Toshniwal 056aff4742 Revert the changes done for removing support for Python 3.7 2024-06-12 16:23:27 +05:30
Yogesh Mahajan 6357672387
Provide an option to set the theme based on the OS theme. #5932 2024-06-12 16:18:37 +05:30
Aditya Toshniwal bdf4f39b2b - Update release notes.
- Update more JS packages.
2024-06-11 15:28:21 +05:30
Akshay Joshi 6b9e3f5d1c Update release note. 2024-06-07 15:54:41 +05:30
Akshay Joshi a46f99d360 1) Partially fixed the issue with inserting characters at the end of the line by setting 'Underline query at cursor?' to false by default.
2) Update release note.
2024-06-04 18:18:16 +05:30
Akshay Joshi 29a526626f Fixed an issue where the size displayed as 'NaN B' for all databases in the statistics tab. #7524 2024-06-03 17:10:11 +05:30
Akshay Joshi 2fb5b26adb Update release note. 2024-05-31 11:26:15 +05:30
Khushboo Vashi 2ab2d6b57c Fix the issue where the query tool documentation screen-shot displays the incorrect function key. #7507 2024-05-28 12:10:14 +05:30
Akshay Joshi 8f8f8ec79a Update version for release v8.7 2024-05-27 16:14:43 +05:30
Anil Sahoo 6690b16f8a
Added support for executing the query at the cursor position in the query tool. #6841 2024-05-27 16:11:59 +05:30
Akshay Joshi 908d7e88b6 Updated release note. 2024-05-24 15:33:59 +05:30
Rohit Bhati 4e3ec91d23
Added support for the 'Add to macros' feature and fixed various usability issues. #4735 2024-05-24 15:30:31 +05:30
Akshay Joshi 6c7bc1c815 Ensure that Schema Diff does not indicate a table as different when the trigger names are the same but the trigger function body is different. #5762 2024-05-21 16:04:25 +05:30
Aditya Toshniwal dd45f06d50
Added support for viewing PGD Clusters. #7215 2024-05-20 16:54:49 +05:30
Aditya Toshniwal 9647482791 Fixed incorrect highlighting for C-Style escape strings in SQL editor. #7485 2024-05-20 10:13:30 +05:30
Akshay Joshi 95466b9d6c Update release note. 2024-05-15 15:30:45 +05:30
Pravesh Sharma 1c44cfb714
Update the documentation for preferences dialog and keyboard shortcuts. #7349, #7458 2024-05-15 15:21:23 +05:30
Akshay Joshi 2dcaf0b4ed Update release note 2024-05-15 13:11:28 +05:30
Aditya Toshniwal 0e786c519e Replace the current FontAwesome based PSQL tool icon with MUI Terminal icon. #7472 2024-05-14 11:05:27 +05:30
Aditya Toshniwal 3b20cad5bb Fixed an issue where drag and drop publication and subscription name in SQL editors was not working. #6086 2024-05-09 15:34:44 +05:30
Akshay Joshi 9edc1d225e Fixed an issue of the pgAdmin window size increasing each time it was reopened. #6464 2024-05-07 17:35:03 +05:30
Akshay Joshi 1c458b82cd Update release note. 2024-05-06 11:22:12 +05:30
Aditya Toshniwal b85d8c1446
Changes in Query Tool, Debugger, and ERD Tool shortcuts to remove the use of Accesskey which will allow them to be customized. #7192 2024-05-06 11:15:44 +05:30
Khushboo Vashi f4761f55f7 Fixed Multi-Factor Authentication bypass vulnerability (CVE-2024-4215). #7425 2024-04-29 13:41:02 +05:30
Pravesh Sharma e18a8bf620
Fixed issue found during testing of #7163. 2024-04-29 13:12:21 +05:30
Akshay Joshi 92bb931b0a Fixed an issue where incorrect select/exec scripts were generated for functions/procedures. #7334 2024-04-25 17:24:02 +05:30
Khushboo Vashi 10ba029980 Fixed an issue where connection to the database is not automatically re-established after connectivity drop. #7372 2024-04-24 14:37:33 +05:30
Akshay Joshi 9f6ddd3cf9 Fixed violates check constraint issue when creating a pgAgent schedule. #7390 2024-04-23 17:27:11 +05:30
Khushboo Vashi 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
Akshay Joshi 3e0ade5a59 Fixed an issue where pressing backspace should remove the spaces and not the entire tab width, on enabling 'Use spaces?' in the preferences. #7317 2024-04-22 12:33:38 +05:30
Akshay Joshi b475be93fa Update yarn.lock file 2024-04-18 12:46:00 +05:30
Aditya Toshniwal 29ccdb3242 Fixed an issue where debugger was not scrolling automatically on stepping. #7275 2024-04-16 15:33:42 +05:30
Akshay Joshi 0546e79aed Made adjustments to ensure the correct version of Authlib is used. #7362 2024-04-16 12:56:42 +05:30
Akshay Joshi 60497df04b Updated release note. 2024-04-15 11:54:31 +05:30
Pravesh Sharma f143aa05a3
Added support for excluding multiple tables while taking Backup. #7163 2024-04-15 11:50:08 +05:30
Aditya Toshniwal e612140473 Update release notes. 2024-04-10 18:00:57 +05:30