Commit Graph

2321 Commits (master)

Author SHA1 Message Date
Akshay Joshi 9eb7c1cbea 1) Ensure that eventlet's subprocess is used for Python versions up to 3.11 and await the issue resolution for Python versions 3.12.
2) Fixed unescape sequence for Python 3.12
2023-11-02 16:03:50 +05:30
Khushboo Vashi 71e7a7c481
Update release notes. 2023-11-01 15:32:25 +05:30
Aditya Toshniwal e30d2eca90 Continue fixing multiple UI and SonarQube issues found when testing wcDocker changes. #6479 2023-10-30 16:57:01 +05:30
Aditya Toshniwal b11b2a2f50 Continue fixing multiple UI and SonarQube issues found when testing wcDocker changes. #6479 2023-10-27 15:51:45 +05:30
Akshay Joshi c5f4a56c0c Fixed an issue where Schema Diff does not work when the user language is set to any language other than English in Preferences. #6784 2023-10-26 11:49:55 +05:30
Khushboo Vashi ebc3460fce Update release notes. 2023-10-25 18:56:40 +05:30
Khushboo Vashi f2bd3933c6
Update release notes. 2023-10-23 17:50:58 +05:30
Aditya Toshniwal 862f101772
Significant changes to use ReactJS extensively.
1. Replace the current layout library wcDocker with ReactJS based rc-dock. #6479
2. Have close buttons on individual panel tabs instead of common. #2821
3. Changes in the context menu on panel tabs - Add close, close all and close others menu items. #5394
4. Allow closing all the tabs, including SQL and Properties. #4733
5. Changes in docking behaviour of different tabs based on user requests and remove lock layout menu.
6. Fix an issue where the scroll position of panels was not remembered on Firefox. #2986
7. Reset layout now will not require page refresh and is done spontaneously.
8. Use the zustand store for storing preferences instead of plain JS objects. This will help reflecting preferences immediately.
9. The above fix incorrect format (no indent) of SQL stored functions/procedures. #6720
10. New version check is moved to an async request now instead of app start to improve startup performance.
11. Remove jQuery and Bootstrap completely.
12. Replace jasmine and karma test runner with jest. Migrate all the JS test cases to jest. This will save time in writing and debugging JS tests.
13. Other important code improvements and cleanup.
2023-10-23 17:43:17 +05:30
Khushboo Vashi 6d555645e9
Update release notes. 2023-10-23 11:22:49 +05:30
Aditya Toshniwal fe753bd272 Fix doc build failure 2023-10-21 16:25:53 +05:30
Khushboo Vashi c07c153f15 Fix an issue where the browser window stuck on spinning with an Oauth user without email. #6874 2023-10-20 11:16:35 +05:30
Aditya Toshniwal b512404c85 Update release notes 2023-10-17 15:19:40 +05:30
Khushboo Vashi b4b2a4ff67 Fix an issue where user login is not working if username/email contains single quote in server mode. #6865 2023-10-17 13:49:18 +05:30
Aditya Toshniwal 47e734dbf2 Fix an issue in graphical explain plan where query tool crashes when the plan has parallel workers details and sort node is clicked for details. #6858 2023-10-16 11:40:43 +05:30
Aditya Toshniwal 3a62fc5a2a Fix issues found during testing. #6229, #6836 2023-10-12 16:58:46 +05:30
Aditya Toshniwal 10adb6a11b
Add support for setting prepare threshold in server connection. #6285 2023-10-12 16:54:06 +05:30
Aditya Toshniwal 221af6caa6 Fix an issue where scale in columns is not allowed to have value as 0 or below. #6851 2023-10-11 15:06:57 +05:30
Aditya Toshniwal e22492ad51 Fixed an issue where non-super PostgreSQL users are not able to terminate their own connections from dashboard. #6836 2023-10-11 13:43:31 +05:30
Akshay Joshi 2b8efc6361 Update release note 2023-10-11 13:34:02 +05:30
Aditya Toshniwal fc411bfc49
Allow setting custom username for shared servers, with default as username of server being shared. #6229 2023-10-11 12:56:06 +05:30
Aditya Toshniwal 5d2ce142dd Fixed an issue in ERD tool where the downloaded images have a few links cut. #4995 2023-10-04 18:23:41 +05:30
Akshay Joshi 9666bd6c8d 1) Added 'load_balance_hosts' connection string parameter for PG 16 and above. #6802
2) Added EPAS 11 support back as its EOL is in November.
2023-10-04 17:55:37 +05:30
Akshay Joshi 4309aa3ba7 Ensure that the backup works properly for PG 16 on the latest docker image. #6790 2023-09-27 17:09:49 +05:30
Khushboo Vashi c6f8918983
Update release notes. 2023-09-27 16:06:54 +05:30
Akshay Joshi 4050545f7c Fixed an issue where the wrong message 'Current database has been moved or renamed' is displayed when debugging any function. #6482 2023-09-26 18:07:25 +05:30
Khushboo Vashi 975bcd9fb0 Update release notes. 2023-09-26 15:14:55 +05:30
Yogesh Mahajan 3cd547f879
Implement column node and its features for foreign table. #640, #6373, #6674 2023-09-26 15:03:03 +05:30
Akshay Joshi 5736e173ea 1) Fixed an issue where PG 16 binaries not getting copied into the docker container.
2) Remove support for PostgreSQL 11.
2023-09-26 13:45:08 +05:30
Dave Page 5a26cad588
Use PG16 as the default in the container. 2023-09-21 15:35:44 +05:30
Akshay Joshi 61fa8b16c9 Update version for release 7.7 2023-09-18 18:57:29 +05:30
Aditya Toshniwal 02ecc82e73
Fix a security related issue where an authenticated user can run remote command using validate binary path API (CVE-2023-5002). #6763 (#6764) 2023-09-18 14:01:11 +05:30
Akshay Joshi ffec77d50b Added compression method option while creating a column. #6379 2023-09-14 11:56:00 +05:30
Nikhil Mohite aa973fc8ae
Added support to select/deselect objects in the Backup dialog. #642 2023-09-13 11:07:28 +05:30
Akshay Joshi 07d965ea46 Ensure that Materialized view size fields in Statistics should be human-readable. #6712 2023-09-06 11:31:04 +05:30
Pravesh Sharma a43b70e360
1. Added USING method while creating the table. #6378
2. Added USING method while creating the materialized view. #6400
2023-09-06 11:22:30 +05:30
Khushboo Vashi 095e11247d Update release notes. 2023-09-05 18:18:36 +05:30
Everton Seiei Arakaki 02eaf787e9
Add support for additional ID token claim checks for OAuth 2 authentication. #6736 2023-09-05 11:28:18 +05:30
Akshay Joshi c0b868b53b
Added Strategy, Locale Provider, ICU Locale, ICU Rules, and OID options while creating a database. #6383 2023-09-04 16:03:06 +05:30
Akshay Joshi c87e925991 Update release note 2023-08-25 12:51:47 +05:30
Anil Sahoo 5fb80af90e
Added all the new options of the 'WITH' clause in the subscription dialog. #4805 2023-08-25 12:48:31 +05:30
Akshay Joshi 77467209c2 1) Added release note for v7.7
2) Added exception handling while removing the test database file.
2023-08-25 11:14:54 +05:30
Yogesh Mahajan 7f5433b307
Update documentation for OAuth2 authentication redirect url.#6644 2023-08-21 12:16:18 +05:30
Yogesh Mahajan e2f32c0984
Fix doc build failure due to SQLAlchemy changes. #6208 2023-08-17 14:00:56 +05:30
Aditya Toshniwal 1adde6084f
Update release notes 2023-08-16 15:32:17 +05:30
Akshay Joshi 3c43aa12af
1) Added 'Ignore Grants' option in the schema diff tool. #5759
2) Added 'Ignore Tablespace' option in the schema diff tool. #6004
3) Ensure that Schema Diff comparison results should be displayed in the sorted order. #6595
4) Fixed an issue where the SET directive is excluded from the function header in the schema diff tool. #6651
2023-08-11 17:38:44 +05:30
Khushboo Vashi f399b30605 Update release notes. 2023-08-07 17:23:32 +05:30
Pravesh Sharma 27c7ea2ff1
Added all like options while creating a table. #6377 2023-08-07 11:20:04 +05:30
Akshay Joshi b01a93544f Added cascade option while creating an extension. #3942 2023-08-03 17:23:03 +05:30
Khushboo Vashi 48bfc66048 Generate software bill of materials as part of the package builds. #3702 2023-08-03 16:08:59 +05:30
Akshay Joshi 1a7a23de3f Added WAL option to EXPLAIN ANALYZE command. #6382 2023-08-03 15:57:12 +05:30
Aditya Toshniwal 59c4a00134 Fix an issue where query tool on shared server is throwing error if the pgAdmin config DB is external. #6252 2023-08-03 12:08:52 +05:30
Aditya Toshniwal c873217cf1
Update release notes 2023-08-03 09:45:44 +05:30
Akshay Joshi 0f86b78d87 Added support for PostgreSQL and EPAS 16 to ensure it works without any errors. #6588 2023-08-02 11:26:09 +05:30
Khushboo Vashi 31fddaf10b Update release notes. 2023-08-01 14:03:21 +05:30
Anil Sahoo 7d7b8a71c1
1. Added Expression to CREATE INDEX. #2595
2. Added support for ALTER INDEX column statistics. #6375
2023-08-01 12:37:47 +05:30
Akshay Joshi b4e6d8c6d7 1) Fixed feature tests failed due to maintenance changes.
2) Update release note.
2023-07-27 18:15:36 +05:30
Pravesh Sharma 5c2d242ff8
Added unlogged option while creating a sequence. #6376 2023-07-27 17:37:22 +05:30
Akshay Joshi a460644ae8
1) Added support for SYSTEM, CONCURRENTLY and TABLESPACE options in REINDEX. #6381
2) Added new/missing options to the VACUUM command. #6397
3) Added SKIP_LOCKED and BUFFER_USAGE_LIMIT option to Analyze command. #6415
2023-07-27 17:34:25 +05:30
Khushboo Vashi a7f06eea0b Fix an issue where inserting more than 10 rows does not work correctly in View Data; only parts end up in the table. #6582 2023-07-24 12:49:42 +05:30
Akshay Joshi fc1cd179ee Update message catalogs 2023-07-20 18:36:18 +05:30
Akshay Joshi a3c3d91515 Fixed some issues in Backup and PSQL tool 2023-07-19 20:31:29 +05:30
Akshay Joshi bd4e14da89 Added new/missing parameters to pg_restore. #6562 2023-07-13 13:01:48 +05:30
Khushboo Vashi 715fa47eb6
Fix an error 'list' object has no attribute 'strip' while attempting to populate auto-complete manually the first time. #6556 2023-07-13 10:18:38 +05:30
Akshay Joshi 940d190bc8 Fixed an issue where pgAdmin failed to setup role with hyphens in name. #6531 2023-07-12 10:36:41 +05:30
Pravesh Sharma ab0b1dd40c
Added all supported index storage parameters while creating an index. #6374 2023-07-11 18:12:53 +05:30
Akshay Joshi def1f31ba8 Ensure that Backup, Restore, and Maintenance should work properly when pgpass file is used. #6499 2023-07-11 15:34:27 +05:30
Aditya Toshniwal 613002c417
Update release notes 2023-07-10 18:34:55 +05:30
Akshay Joshi 7686280cb2 1) Added --exclude-database option for Backup Server.
2) Fixed Jasmine test cases.
2023-07-10 12:44:26 +05:30
Khushboo Vashi 115d4afd9e Fix security hotspots reported by Sonarqube. 2023-07-10 12:42:48 +05:30
Khushboo Vashi a6b8b7bfa9 Update release notes. 2023-07-10 11:27:16 +05:30
Yogesh Mahajan cb7fd7106c
Enable cluster deployment with gp3 volume for AWS & BigAnimal cloud providers. #6323 2023-07-10 11:22:24 +05:30
Akshay Joshi 9aa116bf3f
1) Added new/missing parameters to pg_dumpall (Backup Server). #6416
2) Added new/missing parameters to pg_dump (Backup Objects). #6417
2023-07-10 10:34:30 +05:30
Dave Page dd92196c40 Un-break the doc build. 2023-07-05 14:37:21 +01:00
Dave Page 6b232ba7e8 Remove unsupported PostgreSQL versions from the container.
Fixes #6532
2023-07-05 13:26:12 +01:00
Khushboo Vashi d09c3b6b21 Update release notes. 2023-07-04 11:53:12 +05:30
Khushboo Vashi 326dc2bbcc
Fix an issue where queries longer than 1 minute get stuck - Container 7.1. #6317 (#6491)
Fix an issue where queries longer than 1 minute get stuck - Container 7.1. #6317
Fix an issue where queries get stuck with auto-completion enabled. #6356
Fix an issue where queries can't complete execution. #6163
2023-07-04 10:44:46 +05:30
Dave Page cba689dcd9 Fix typo. 2023-07-03 13:29:38 +01:00
Dave Page 8f6d016df0 Clarify the LICENSE file to indicate the it is the PostgreSQL Licence.
Fixes #6423.
2023-07-03 10:24:03 +01:00
Akshay Joshi 8724fe5619 Update release note. 2023-06-30 16:10:21 +05:30
Aditya Toshniwal d6cddd8c29
Remove Bootstrap and jQuery from authentication pages and rewrite them in ReactJS. #6295 2023-06-30 16:08:33 +05:30
Akshay Joshi 8600a41185 Update release note 2023-06-29 11:18:00 +05:30
Akshay Joshi 0687c52fdc
Added support to detach partitions using concurrently and finalize. #6369 2023-06-29 10:33:39 +05:30
Aditya Toshniwal 4b477aed5d Update release notes 2023-06-22 14:02:20 +05:30
Aditya Toshniwal f7bc826262 Fix an issue where all the menus are enabled when pgAdmin is opened and no object is selected in the object explorer. #6435 2023-06-22 13:52:39 +05:30
Akshay Joshi 5a701b7c61 Update release note 2023-06-22 11:16:03 +05:30
Anil Sahoo 78db1e3c36
Added security_invoker option while creating a view. #6371 2023-06-22 11:14:03 +05:30
Aditya Toshniwal 7c6e83c6fe Fix an issue where explain plan details is showing HTML escaped characters. #6352 2023-06-21 13:45:43 +05:30
Akshay Joshi 0d926d4c7f Update release note. 2023-06-21 11:27:11 +05:30
Akshay Joshi 5d619fd455 1) Fixed Schema Diff issue.
2) Remove unsupported versions from the get_version_mapping_directories() function.
3) Updated test cases for version template loader.
2023-06-19 18:44:55 +05:30
Aditya Toshniwal a9ae7ca099 Ensure that query tool status poller is paused if the query tool is not visible/active 2023-06-19 16:28:48 +05:30
Aditya Toshniwal d21e1eb17e
Update release notes 2023-06-19 15:35:37 +05:30
Aditya Toshniwal bb570a50ae
Update release notes 2023-06-19 15:17:28 +05:30
Pravesh Sharma 36949aef99
Added option to create unique index with nulls not distinct. #6368 2023-06-19 15:09:48 +05:30
Akshay Joshi 557f33c4f9
Added support to drop databases using the 'WITH (FORCE)' option. #6367 2023-06-19 15:04:40 +05:30
Anil Sahoo 789f169135
Add Password exec command and Expiration time to server export JSON and also allow them to import. #6258 2023-06-15 11:49:06 +05:30
Akshay Joshi 251bf05692 Fixed the following SonarQube code smells:
1) Do not use Array index in keys.
2) Unnecessary escape character.
3) Rename this local variable to match the regular expression ^[_a-z][a-z0-9_]*$
4) Remove the unused local variable.
2023-06-12 18:44:31 +05:30
Nikhil Mohite 3b9eef3bb7
Updated master password documentation. 2023-06-08 18:47:50 +05:30
Akshay Joshi 4bddb5c36c 1) Update version for release 7.3
2) Update release note.
2023-06-05 13:07:32 +05:30
Akshay Joshi 149e093c88 Fixed an issue where Foreign Key with 3 or more columns are shown in the wrong order in SQL and Properties. #6345 2023-06-02 15:01:54 +05:30
Akshay Joshi 99d1c99963 Update release note 2023-06-02 12:57:45 +05:30
Anil Sahoo 7dfcc73e95
Update the publication dialog tabs and the docs. #5868 2023-05-30 16:45:13 +05:30
Aditya Toshniwal 7be7d3a024
Update release notes 2023-05-29 11:03:39 +05:30
Aditya Toshniwal 396f6c9d73
Update release notes 2023-05-25 16:26:39 +05:30
Anil Sahoo 8b7eeca545
Implement new PostgreSQL 15 features in publication dialog and SQL. #5868 2023-05-25 16:25:12 +05:30
Yogesh Mahajan 702bc8c8ce
Allow pgAdmin to retrieve master password from external script/program. #4769 2023-05-25 13:49:08 +05:30
Akshay Joshi cba3dc9457 Fixed an issue where Operators collection node throwing an error. #6325 2023-05-25 11:56:45 +05:30
Akshay Joshi dd4639d602 Fixed an issue where Foreign Key columns are shown in the wrong order in SQL and Properties. #5789 2023-05-23 11:52:19 +05:30
Aditya Toshniwal fb3b2a4635 Fix an issue where View RE-SQL is not quoting the column comments. #6280 2023-05-22 16:24:55 +05:30
Akshay Joshi db3d0c6e21 Make the 'Connect to server' dialog a modal dialog. #6043 2023-05-22 15:00:42 +05:30
Aditya Toshniwal cedfd12f6a
Add an option to hide/show empty object collection nodes. #5048 2023-05-22 14:55:01 +05:30
Aditya Toshniwal c9013a39b8
Update release notes 2023-05-22 14:11:11 +05:30
Akshay Joshi 87c1023c4f Use dependent instead of dependant in the message. #6278 2023-05-22 11:38:19 +05:30
Aditya Toshniwal 7ab096d87f
Update release notes 2023-05-22 11:10:53 +05:30
Nikhil Mohite 736879567f
Added support to use standard OS secret store to save server/ssh tunnel passwords instead of master password in pgAdmin desktop mode. #5123 2023-05-22 11:08:29 +05:30
Akshay Joshi e2b27da2ef Fixed an issue where properties not visible for FTS Parsers, FTS Templates, MViews and Rules in Catalog objects. #6127 2023-05-18 16:21:15 +05:30
Akshay Joshi 4baae7512b Ensure that name can't be empty in edit mode for Primary Key and Index. #6204 2023-05-18 15:46:56 +05:30
Akshay Joshi 6949b41fb9 Ensure that a new row should be added on top in the User Management dialog. Fixes #5817 2023-05-18 13:26:47 +05:30
Aditya Toshniwal 4fd1e16bb4
Update release notes 2023-05-17 12:13:29 +05:30
Aditya Toshniwal b9f9ad8027
Update release notes 2023-05-16 11:32:46 +05:30
Khushboo Vashi acf5eb7a26 Update release notes. 2023-05-10 15:03:32 +05:30
Khushboo Vashi 259a534a71 Update release notes. 2023-05-10 10:37:35 +05:30
Akshay Joshi 5483f70d4b Update release note 2023-05-08 11:44:41 +05:30
Aditya Toshniwal d8e00e6586 Fix a doc build issue occuring after adding release note for 7.2 2023-05-05 14:11:09 +05:30
Aditya Toshniwal 377bf554b6 Update release notes 2023-05-05 13:59:41 +05:30
Aditya Toshniwal 5c57fd0170 Update release notes 2023-05-03 15:21:01 +05:30
Akshay Joshi 14f617681f Update release note 2023-05-03 10:35:54 +05:30
Aditya Toshniwal edb74a0839 Disable NW.js dev tools shortcut on Mac as it may crash the app. #6183 2023-04-28 19:01:03 +05:30
Aditya Toshniwal e20e75aeba Fixed an issue where Reset Password is not working after upgrading to latest flask-security-too. #6191 2023-04-27 13:19:09 +05:30
Aditya Toshniwal 23eaa47fea
Update release notes 2023-04-26 15:43:37 +05:30
Pravesh Sharma 861c66d180
Ensure that when pasting a row in query tool grid, default value is used for autogenerated/serial columns. #5922 2023-04-26 15:41:10 +05:30
Akshay Joshi 6d1e918c78 Update release note 2023-04-26 11:20:49 +05:30
Aditya Toshniwal 1e7517dc98
Show object breadcrumbs path along with its comment on object hover. #2078 2023-04-26 11:18:16 +05:30
Akshay Joshi 32fb3f3c1f Update release note. 2023-04-24 14:57:47 +05:30
Akshay Joshi 0ccfa7900c The search object, query tool, and psql tool menu should not be displayed for pgAgent. #6077 2023-04-20 18:01:20 +05:30
Akshay Joshi c19fc3628c Ensure that the ERD tool should work with the external database after moving to psycopg3. #6159 2023-04-20 15:37:43 +05:30
Akshay Joshi d6ecc531e0 Added support to create an unnamed index. #3318 2023-04-20 12:35:10 +05:30
Yogesh Mahajan f1e7782ca2
Fixed error occurring while dumping the servers from CLI. #6137 2023-04-19 16:05:35 +05:30
Khushboo Vashi 47a0009d32 Ensure to quote the primary key value if needed while deleting rows from the table. #6130 2023-04-17 12:38:16 +05:30
Akshay Joshi 947630e0f0 Added support to show statistics for materialized views. #3316 2023-04-14 16:27:43 +05:30
Yogesh Mahajan 64d5457e2b
Try to fix feature test failures happening due to error occurring while deleting test databases.
* Try to fix feature test failures happening due to error occurring while deleting test databases.

* Updated ON_DEMAND_ROW_COUNT to ON_DEMAND_RECORD_COUNT missed in #3275.
2023-04-13 17:25:12 +05:30
Aditya Toshniwal ec19fc2b01
Update release notes 2023-04-13 16:51:54 +05:30
Yogesh Mahajan 993e1eb1b6
Allow on demand record count setting to be changed per user using preferences. #3275 2023-04-13 16:43:11 +05:30
Akshay Joshi d92a836647 Update python version for OSX and update the release note. 2023-04-13 15:51:49 +05:30
Khushboo Vashi 6ab102fcbc Fixed CSV export from Query Tool results does not include all columns for multiple CTEs. #6122 2023-04-11 19:09:26 +05:30
Akshay Joshi 6b31fc4552 Change the logic to prevent the config_local.py from deletion on RPM and Debian. 2023-04-10 16:56:55 +05:30
Akshay Joshi 96450fee63 Prevent deletion of 'config_local.py' for RPM and Debian 2023-04-06 19:15:01 +05:30
Akshay Joshi c1a022c40c Update release note 2023-04-04 18:31:01 +05:30
Akshay Joshi 53b9fe1c86 Update version for release 7.0 2023-04-03 16:08:17 +05:30
Aditya Toshniwal 6710969143
Rename 'Edit Object..' context menu back to 'Properties...'. #4734 2023-04-03 13:10:24 +05:30
Akshay Joshi d9fff8c480 Update Dependencies 2023-03-30 19:06:56 +05:30
Nikhil Mohite 48839983fd
Updated config file documentation for shared storage and While doing save as operation, ensure the error message is shown if access is restricted in shared storage #5014 2023-03-29 13:49:32 +05:30
Akshay Joshi ec33c3e7ec Update release note 2023-03-28 22:26:03 +05:30
Aditya Toshniwal 9924fae378
Nomenclature changes:
1. Rename "Properties..." context menu option of object to "Edit Object...".
2. Rename "Browser" tree to "Object Explorer". #4734
2023-03-28 22:20:14 +05:30
Akshay Joshi 12f82820c9 Fix an issue where Backup, Restore, and Maintenance not working if connection timeout is set in the server dialog. #5959 2023-03-27 17:41:19 +05:30
Yogesh Mahajan 51c22608b2
Update BigAnimal documentation for BigAnimal v3 API changes. #5805 2023-03-27 17:10:28 +05:30
Akshay Joshi 636ab5cbab Change the foreground color of the code mirror text for Dark Theme. #6018 2023-03-27 11:35:54 +05:30
Akshay Joshi c8945883c1 Update release note 2023-03-24 16:10:11 +05:30
Akshay Joshi 207812582d 1) Fixed RESQL test case for EPAS.
2) Update Dependencies.
2023-03-24 14:37:35 +05:30
Akshay Joshi 70b2ead852 Ensure that the schema diff tool should not allow comparison between Postgres Server and EDB Postgres Advanced Server. #5952 2023-03-24 13:03:35 +05:30
Nikhil Mohite e4eeba2aa7
Fixed the UI related issues reported during testing for Shared Storage in Server Mode. #5014 2023-03-24 11:08:27 +05:30
Akshay Joshi e03676f138 Update release note 2023-03-23 18:52:33 +05:30
Yogesh Mahajan a026353df8
Fixed the UI related issues reported during testing for Google Cloud SQL deployment. #5750 2023-03-23 11:51:21 +05:30
Aditya Toshniwal 64ddfc0eb7
Fix an issue where server foreground/background color was not getting applied after jQuery changes. #5701 2023-03-21 17:39:37 +05:30
Akshay Joshi ff5b92aaeb Update release note. 2023-03-20 18:25:25 +05:30
Nikhil Mohite 97d3b6c7db
Update documentation for shared storage. #5014 2023-03-20 14:11:57 +05:30
Akshay Joshi 5a0731587a 1) Try to fix Jenkins failure.
2) Update release note
2023-03-17 18:16:17 +05:30
Akshay Joshi e6e49091b6 Updated release note. 2023-03-16 17:26:14 +05:30
Akshay Joshi 8c8be6461c Remove pyOpenSSL from requirements 2023-03-15 12:21:43 +05:30
Akshay Joshi 0a543d0e95 Ensure that the user's storage directory is created when the users are created, as well as for those users who have not yet been created. #5824 2023-03-14 18:21:18 +05:30
Akshay Joshi 59edf50c02 Update release note 2023-03-14 13:50:00 +05:30
Akshay Joshi e32019882e Update relese note 2023-03-13 14:58:40 +05:30
Yogesh Mahajan 63c7d14638
Added capability to deploy PostgreSQL servers on Google Cloud. #5750 2023-03-13 14:56:16 +05:30
Akshay Joshi 6ab43e4582 Update release note 2023-03-13 11:52:51 +05:30
Akshay Joshi 4d5c915144 Update release note 2023-03-08 18:34:37 +05:30
Akshay Joshi 6bd0ea7a02 Fixed an issue where the file name in the query tool tab was not changing if another file is opened. #5909 2023-03-08 17:37:45 +05:30
Akshay Joshi 17f18e795f Fixed an issue where the count query should not be triggered when the estimated count is less than zero. #5904 2023-03-07 16:16:34 +05:30
Akshay Joshi ca33283930 Make 'using' and 'with check' fields a textarea in the RLS policy. #5874 2023-03-07 12:19:03 +05:30
Akshay Joshi 262d1a1c95 Update release note and version number 2023-03-06 17:10:22 +05:30
Nikhil Mohite 9da8a188fa
Added support for mounting shared storage in server mode. #5014 2023-03-06 17:03:47 +05:30
Akshay Joshi 9b7a38ac52 Ensure that the database migration does not fail with a NoSuchTableError exception. #5870 2023-03-06 15:41:02 +05:30
Akshay Joshi 948feeb11f Update release note 2023-03-02 11:04:18 +05:30
Akshay Joshi ff3555cf1d Update release notes. 2023-03-02 10:59:38 +05:30
Akshay Joshi a008f9ba79 Fixed an issue where the database server is not connected using a service file. #5889 2023-02-28 13:29:58 +05:30
Akshay Joshi 486e68b8be Update release note 2023-02-22 14:08:40 +05:30
Akshay Joshi f404fdcf8a Fixed an issue where the user can't create trigger AFTER UPDATE OF. #5790 2023-02-20 17:37:17 +05:30
Akshay Joshi e56a1f3e2d Update release note 2023-02-20 13:26:22 +05:30
Khushboo Vashi 5e0daccf76 Added support for psycopg3 along with psycopg2. #5011 2023-02-15 11:31:29 +05:30
Akshay Joshi d8c5bc4320 Ensure that content on the DDL comparison panel should get refreshed on selecting the object using the up and down arrow keys. #5747 2023-02-14 17:15:04 +05:30
Akshay Joshi e70f115b48 Update release note 2023-02-14 11:06:15 +05:30
Akshay Joshi f623d563b1 Ensure that the schema diff tool should pick up the change in the column grants. #5269 2023-02-13 17:54:38 +05:30
Akshay Joshi 0fd1e0963e Fixed an issue where pgAdmin failed to connect when the Postgres password included special characters. #5847 2023-02-13 16:49:18 +05:30
Akshay Joshi 428e432732 Update release note 2023-02-10 10:38:17 +05:30
Aditya Toshniwal 1806866bf5
Allow changing cardinality notation in ERD to use Chen notation. #5832 2023-02-10 10:27:16 +05:30
Akshay Joshi 696cb0fa05
Ensure that Grant column permission to a view is visible in the SQL tab. #5685 2023-02-10 10:26:01 +05:30
Akshay Joshi 6833fdd731 Ensure that keyboard hotkey to open query tool and search object should work properly. #5763 2023-02-06 15:58:33 +05:30
Akshay Joshi ca43f938bd 1. Ensure that the system columns should not visible in the import/export data. #5733
2. Fixed console error while attaching the partition. #5748
2023-02-02 18:14:38 +05:30
Pravesh Sharma e247867abf
Incorporated review comments for #5705 2023-02-01 14:24:49 +05:30
Akshay Joshi aa6c199e98 Added bundled PG utilities in the release note. #4320 2023-02-01 13:12:37 +05:30
Akshay Joshi ff4a409e27 Update release note 2023-01-31 13:06:29 +05:30
Akshay Joshi ea3dffe78d 1) Fixed an issue where Query history is not getting loaded with an external database. #5781
2) Change the datatype of the value column of the setting table to text instead of a string. #5746
3) Fixed an issue where the key 'passfile' is not found. #4728
2023-01-30 15:38:36 +05:30
Akshay Joshi fd1c26408b Modify the logic to show the connection string for the shared servers. #4728 2023-01-24 17:22:54 +05:30
Akshay Joshi a7cf698d09
1) Added support for setting PostgreSQL connection parameters. #4728
2) Fixed an issue where Kerberos authentication to the server is not imported/exported. #5732
3) Increase the length of the value column of the setting table. #5746
4) Upgrade Flask-Migrate to 4.0.0. #5525
2023-01-23 17:19:59 +05:30
Akshay Joshi 91049445dd Update release note 2023-01-19 15:58:44 +05:30
Akshay Joshi 10c6a4f8dc 1) Unpin Sphinx version as the issue has been fixed in v 6.1.3
2) Update release note
2023-01-17 17:30:22 +05:30
Akshay Joshi e0a3420cd9 Change the release date 2023-01-16 19:34:33 +05:30
Akshay Joshi 9dc27c44e6 Update release note 2023-01-13 12:31:59 +05:30
Akshay Joshi fbd2f969a2 Update release note 2023-01-09 18:45:36 +05:30
Akshay Joshi 2a86afc64c Update version for release 6.19 2023-01-09 12:34:13 +05:30
Khushboo Vashi 9ff015e73c
Added support of AWS provider for BigAnimal cloud deployment. #5569 2023-01-09 12:32:26 +05:30
Akshay Joshi a8724b9764 Update message catalogs 2023-01-05 17:44:35 +05:30
Akshay Joshi 014ae2ea3f Update README and release note 2023-01-04 17:30:21 +05:30
Akshay Joshi 81e2657bed Update release note 2023-01-03 10:32:42 +05:30
Akshay Joshi 98184e5835 Update copyright notices for 2023 2023-01-02 11:53:55 +05:30
Akshay Joshi 622e8b7d21 Update release note. 2023-01-02 11:14:55 +05:30
Yogesh Mahajan acc26744e3
Fixed a missing "jwks_uri" in metadata error that occurred when logging in with an oAuth2 provider like Azure or Google. #5666 2022-12-22 16:54:13 +05:30
Akshay Joshi 628b37dc4d Update release note 2022-12-22 14:26:49 +05:30
Akshay Joshi d5e6786bc7 Update release note 2022-12-22 10:37:47 +05:30
Akshay Joshi 4021107124 Update release note 2022-12-20 11:32:09 +05:30
Akshay Joshi 4d95bc0365 Update release note 2022-12-19 11:50:16 +05:30
Aditya Toshniwal cbea043ca1
Allow YouTube video demo links to be added to appropriate pgAdmin documentation. #5563 2022-12-19 10:45:45 +05:30
Akshay Joshi c07053bce5 1) Update release note.
2) Fixed a typo. #5645
2022-12-14 15:56:05 +05:30
Akshay Joshi 799b6d8f7c Use the login_required decorator in the appropriate place. #5593 2022-12-13 16:26:35 +05:30
Akshay Joshi 030a771b87 Update release note and Dependencies 2022-12-12 14:49:18 +05:30
Akshay Joshi 953fb31e14 Fixed an issue with auto-complete not working as expected with double quotes. #5551 2022-12-09 14:13:40 +05:30
Akshay Joshi 8f5a58a163 Update message catalogs. 2022-12-08 17:06:56 +05:30
Akshay Joshi 4cfcda5d2f Update release note 2022-12-06 18:17:38 +05:30
Akshay Joshi cddb24bc50 Fixed an error in the collation create script for PG-15. #5606 2022-12-06 12:50:09 +05:30
Akshay Joshi 14d29c7a92 Fixed an issue where master password was not set correctly with external config database. #5603 2022-12-05 16:21:32 +05:30
Akshay Joshi d3f5e6e931 Update release note 2022-12-05 11:08:53 +05:30
Akshay Joshi 461849c276 Ensure that only authorized and authenticated users can validate binary paths (CVE-2022-4223). #5593 2022-11-30 12:02:45 +05:30
Akshay Joshi 83bfdf9b3c Fixed an issue where the wrong schema is displayed for a foreign key in the schema diff tool. #5488 2022-11-28 17:27:21 +05:30
Akshay Joshi a737d1167c Update release note 2022-11-28 13:50:36 +05:30
Akshay Joshi 789c8e971f Update release note 2022-11-28 11:33:24 +05:30
Yogesh Mahajan d3d666d773
Ensure that DATA_DIR dependent folders/files are automatically created inside the specified DATA_DIR if they are not specified separately in the configuration file.. #5513 2022-11-28 11:32:50 +05:30
Akshay Joshi 081fab7466 Update release note 2022-11-25 11:46:33 +05:30
Akshay Joshi 9d3654bd69
Ensure that the query history date format in Desktop mode matches the format of the locale of the pgadmin server. #5495
Format the time based on pgadmin servers locale.
2022-11-24 10:48:05 +05:30
Akshay Joshi d48a2ce870 Update Dependencies 2022-11-21 10:58:25 +05:30
Aditya Toshniwal 8d74de09cc
Remove all traces of Backbone, Underscore. #5493 2022-11-21 10:54:15 +05:30
Akshay Joshi 5dca51637c Remove feature tests for JIT as there is no guarantee that this information will always be available. 2022-11-19 10:24:22 +05:30
Akshay Joshi 7db655c0c1 The container deployment document should include the server.json file format. #5452 2022-11-17 16:51:02 +05:30
Akshay Joshi ec56cb9d28 Update release note 2022-11-16 14:38:51 +05:30
Akshay Joshi 749138791a 1) Fixed an issue where the 'save_password' column threw an error for the shared server when using an external database. #5535
2) Fixed integrity error while removing server when using an external database.
3) Remove the length of the password column of the server and the shared server table.
2022-11-16 14:01:55 +05:30
Akshay Joshi aa4f992e30 Ensure that autocomplete works properly with objects starting with double quotes. #5281 2022-11-15 13:59:12 +05:30
Akshay Joshi c5e9aa6357 Ensure that the load file paths are children of the storage directory. #5522 2022-11-14 19:28:48 +05:30
Akshay Joshi 94902e7aad Update release note. 2022-11-10 16:52:44 +05:30
Akshay Joshi e770065277 Update release note 2022-11-09 17:36:57 +05:30
Akshay Joshi a8b3042b49 Update release note. 2022-11-09 11:37:20 +05:30
Aditya Toshniwal af32e3c296
Added the ability to generate ERDs for tables. #4756 2022-11-09 11:36:04 +05:30
Akshay Joshi 398675597a Fixed an issue where AutoComplete was not working correctly due to incorrect regex. #5473 2022-11-07 13:59:18 +05:30
Leon Maraite 6bc5808c53
Add the possibility to configure the OAuth2 claim which is used for the pgAdmin username. #5468
This feature provides the possibility to configure the Oauth2 claim
which should be used as a username. The key in the config.py is called
'OAUTH2_USERNAME_CLAIM'. If you don't provide a custom key, the email
is used as the username, like before. So it is completely backward
compatible.
2022-11-07 13:58:23 +05:30
Akshay Joshi 6122e3bb54 1) Fixed audit issue.
2) Update release note.
3) Update yarn.lock
2022-11-04 13:48:35 +05:30
Akshay Joshi c5e856c4b8 Updated release note. 2022-11-02 14:06:25 +05:30
Akshay Joshi 8667af879c Update release note. 2022-10-31 18:11:10 +05:30
pea-sys 4bcf0637f9
Improve PNG files by optimising them. 2022-10-31 18:06:53 +05:30
Akshay Joshi bf62b9ccb7 Update release note. 2022-10-21 09:30:31 +05:30
Akshay Joshi db5e181b4f Update release note. 2022-10-20 16:29:56 +05:30
Akshay Joshi e17c50d304
Added support for storing configurations of pgAdmin in an external database. #1832 2022-10-20 16:18:41 +05:30
Akshay Joshi 0a3a90b400 Update version for release. 2022-10-17 15:28:08 +05:30
Aditya Toshniwal 4fc0f288c7
Use SocketIO instead of REST for fetching database tables data in ERD. #5065 2022-10-17 15:24:22 +05:30
Akshay Joshi 51c7551d3f Update release note. 2022-10-15 14:49:38 +05:30
aelgn a62fc2fbff
Added support for IAM token based authentication for AWS RDS or Azure DB. #3491 2022-10-15 14:49:04 +05:30
Akshay Joshi 1d3be06cb5 Update release note. 2022-10-13 18:47:31 +05:30
Akshay Joshi 3c52139ce5 Update release note. 2022-10-12 10:08:21 +05:30
Aditya Toshniwal 794cbed57c
Added support to specify the background fill color to the table nodes in the ERD tool. #4392 2022-10-12 10:07:30 +05:30
Akshay Joshi 5b09122676 Update release notes. 2022-10-11 10:58:04 +05:30
Yogesh Mahajan 2d0f09144d
Ensure that the login form is hidden if the authentication source is OAuth2 or Kerberos. #5386 2022-10-06 17:31:15 +05:30
Khushboo Vashi e3a172e0e8
Fixed the cross-site scripting vulnerability. #5405 2022-10-06 17:30:41 +05:30
Nikhil Mohite 9002961e5d
Fixed console warning shown while updating database node from browser tree. #5332 2022-10-06 16:15:38 +05:30
Nikhil Mohite 7e51a2f517
Ensure that the result grid column should take width as pre preferences setting on first execution. #5132 2022-10-06 15:59:27 +05:30
Nikhil Mohite bb78d91d1b
Ensure that scroll bar on browser tree should be visible on windows resize #5402 2022-10-06 15:58:05 +05:30
Aditya Toshniwal b086e1fd83
Add option to generate SQL with DROP table DDL in ERD Tool. #4997 2022-10-06 09:30:45 +05:30
Dave Page 8875d8b741 Add a description of the available container tags we publish to the docs. 2022-10-05 12:05:26 +01:00
Yogesh Mahajan af97ed78ef
Fixed an exception occur while taking backup and SSL certificates/keys are not found in the specified path. #5133 2022-10-04 11:01:27 +05:30
Dave Page 992dff64af Expose the Gunicorn limit_request_line parameter in the container, with the default set to the maximum 8190.
See #5390.
2022-10-03 14:09:25 +01:00
Dave Page b8ec021a07 Add a note about sys.executable potentially needing "help" under WSGI runners.
See #5340.
2022-10-03 13:35:31 +01:00
Aditya Toshniwal 406119d96c
Allow reordering table columns using drag and drop in ERD Tool and create table. #4994 2022-10-03 11:18:22 +05:30
Yogesh Mahajan 869b90121c
Ensure that the correct value should be returned if an exception occurs while decoding the password. #5367 2022-09-30 15:08:03 +05:30
Akshay Joshi d13ee8db29 1) Remove folders that are no longer used for older database versions.
2) Fixed RESQL tests for View/MView.
2022-09-29 16:45:51 +05:30
Pravesh Sharma 9817a9b20f
Fixed an issue where user was unable to select privileges in Safari #5327 2022-09-29 16:41:11 +05:30
Nikhil Mohite 56fb24c24a
Fixed the .psqlrc issue for PSQL Tool. #5167 2022-09-29 12:29:32 +05:30
Yogesh Mahajan 5fbb8b6204
Fixed error occurring while LDAP authentication for a user with multiple email attributes. #5352 2022-09-27 15:38:48 +05:30
Pravesh Sharma add5404f5e
Fixed an issue where the prompt is not visible when clicking on the 'save results to file' button on the large data. #5338
corrected issue id

corrected order of release notes
2022-09-27 14:27:22 +05:30
Akshay Joshi 0b6b2e733a 1) Remove Python's 'Six' package completely. #5357
2) Replace deprecated @abstractproperty with @property, @abstractmethod.
2022-09-26 12:47:31 +05:30
Nikhil Mohite fc8d6d6e90
Fixed the issue while downloading the file from file manager. #5368 2022-09-26 12:10:56 +05:30
Akshay Joshi bc08512327 Ensure that the search filter should be cleared when a new row is added to the user management. #5261 2022-09-23 16:22:31 +05:30
Nikhil Mohite 45a1dee9f1
Added the close button for all the notifications of the notistack. #5212 2022-09-23 14:01:18 +05:30
Yogesh Mahajan f052ecffc0
Fixed intermittent error shown while OAuth2 login 2022-09-23 13:58:02 +05:30
Aditya Toshniwal 9a6516a8b3
Ensure that the query tool creates a new tab with the appropriate user when pressing Alt+Shift+Q. #5210 (#5350) 2022-09-23 11:19:48 +05:30
Nikhil Mohite 98c50afe8e
Ensure that the continue/start button should be disabled if the user stops the Debugger for the procedures. #5188 (#5353) 2022-09-23 11:11:23 +05:30
Pravesh Sharma 94ca48674a
made tooltip consistent across the application (#5351)
Ensure that the tooltips are consistent throughout the entire application. #5293
2022-09-23 11:11:02 +05:30
Dave Page 9ed3be335e
Update docs to replace use of patches with Pull Requests. (#5349) 2022-09-22 18:24:14 +05:30
Akshay Joshi ed1184fcf8 Ensure that the user management dialog should not allow the same email addresses
with different letter casings when creating users. #5262
2022-09-22 14:59:42 +05:30
Nikhil Mohite 0203bbc7ef Added the ability to display the selected text from the query tool in the find/replace box. #5249 2022-09-22 14:59:42 +05:30
Nikhil Mohite 3765131d21 Ensure that the default value for a column should be used if it is made empty. #5308 2022-09-22 14:59:42 +05:30
Yogesh Mahajan 83e2ee04d1 Added high availability options to AWS deployment. #5304 2022-09-22 14:59:42 +05:30
Dave Page 6d1283f92d Update the GitHub org name. 2022-09-22 10:12:08 +01:00
Dave Page 8459a45d72 Update to use GitHub for source repos. 2022-09-21 10:56:03 +01:00
Aditya Toshniwal a2a18d4b4a Fixed an error while saving changes to the ERD table. Fixes #5342 2022-09-19 16:20:07 +05:30
Aditya Toshniwal e2b00dda1b Fixes a redirect vulnerability when the user opens the pgAdmin URL. Fixes #5343 2022-09-19 15:36:10 +05:30
Yogesh Mahajan d38d0ce805 1) Fixed the error message displayed when clicking the cloud server for which deployment is in progress. Fixes #5144
2) Ensure that if big animal authentication is aborted, API calls should be stopped. Fixes #5275
2022-09-15 18:44:07 +05:30
Aditya Toshniwal 04b1e26041 Fixed an issue where server names with special characters are not displayed correctly in the process tab. Fixes #7695 2022-09-15 16:43:37 +05:30
Nikhil Mohite 769f58970e Fixed an issue where the wrong SQL displayed in difference if the user create
an RLS policy on the table without a column. Fixes #7637
2022-09-15 16:40:03 +05:30
Aditya Toshniwal 9ac233f244 Fixed an issue where ERD throws an error if variable is added to the column. Fixes #7709 2022-09-15 13:16:27 +05:30
Aditya Toshniwal 985546fff6 Fixed an issue where pgAdmin failed to start due to bin path migration. Fixes #7557 2022-09-15 13:13:38 +05:30
Akshay Joshi 16bcb7d4a2 Ensure that the browser tree should be refreshed after changing the ownership. Fixes #7607 2022-09-14 15:08:05 +05:30
Fahar Abbas eb60b3892d Updated keyboard shortcut documentation. Fixes #7446 2022-09-13 16:43:34 +05:30
Akshay Joshi 703cefd9ae Replace the language selection 'Brazilian' with 'Portuguese (Brazilian). Fixes #7693 2022-09-12 14:51:18 +05:30
Khushboo Vashi ca8b5c68fd Remove Backgrid and Backform. Fixes #6134 2022-09-10 14:22:49 +05:30
Akshay Joshi 7086719640 Fixed SonarQube issues. 2022-09-08 18:08:58 +05:30
Yogesh Mahajan 603ce21d24 Fixed an issue where textarea of the JSON Editor does not resize with dialog. Fixes #7656 2022-09-08 15:31:36 +05:30
Nikhil Mohite 0c9c57e608 1. Resolved resize window issue for DDL result panel.
2. Updated the Screenshots.
3. Updated server group title to bold.

refs #6133
2022-09-08 15:24:43 +05:30
Akshay Joshi 18b77f15dd Remove Alertify from pgAdmin completely. Fixes #7619 2022-09-08 15:16:48 +05:30
Nikhil Mohite e1942d8c9e 1) Port schema diff to React. Fixes #6133
2) Remove SlickGrid.
2022-09-07 19:20:03 +05:30
Yogesh Mahajan ad59380676 Fixed an issue with the non-visibility of columns added prior to import/export data. Fixes #7649 2022-09-07 17:40:52 +05:30
Aditya Toshniwal 0f46f070ed Port the remaining components of the ERD Tool to React. Fixes #7343
1. Make use of MUI styles and remove SCSS.
2. Use the new common components for buttons and tooltips, so that they are consistent.
3. UI design should be aligned with the query tool.
4. Remove tippyjs and Alertify dependencies.
2022-09-06 18:09:13 +05:30
Akshay Joshi 71c962f51c Fixed ModuleNotFoundError when running setup.py to load/dump servers. Fixes #7663
Patch Sent By: Karl Maximilian Daenner
2022-09-06 11:48:55 +05:30
Yogesh Mahajan 7c729d5f0e Fixed API test case for change password in the server mode. Fixes #7648 2022-09-06 11:30:21 +05:30
Akshay Joshi 317a17337d Added supported database servers in the release notes. 2022-09-05 15:30:24 +05:30
Yogesh Mahajan 9a317f3ba6 Fixed an issue where backup does not work due to parameter 'preexec_fn' no longer being supported. Fixes #7580 2022-09-02 13:12:58 +05:30
Akshay Joshi 72f819ec67 Ensure that the dump servers functionality works from setup.py. Fixes #7644 2022-08-31 14:28:48 +05:30
Akshay Joshi e58b9c767b Port search object dialog to React. Fixes #7622 2022-08-30 17:08:12 +05:30
Akshay Joshi fe0577be5f Ensure that the Import/Export server menu option is visible. Fixes #7646 2022-08-26 14:38:50 +05:30
Akshay Joshi 78757564c8 Pin Flask-SocketIO <= v5.2.0. The latest version does not support Werkzeug in production environments. Fixes #7641 2022-08-25 13:21:18 +05:30
Nikhil Mohite 5c04f1aa2e 1) Ensure that the autofocus is on the input control for the master password and server password dialogs. Fixes #7633
2) Fixed an XSS vulnerability in the Hostname/Address control in the Server Connection dialog.
2022-08-22 15:58:17 +05:30
Yogesh Mahajan 2de89dcaaf Fixed an issue where a user could not authenticate using Azure CLI on OSX. Fixes #7632 2022-08-22 14:50:18 +05:30
Aditya Toshniwal f2cc897f2f 1. Fixed an issue where copy and pasting a row in the results grid doesn't set the default for boolean. Fixes #7579
2. Fixed an issue where the History tab is getting blank and showing an error after some queries are executed. Fixes #7468
3. Fixed query tool view data crash.
2022-08-22 14:33:38 +05:30
Akshay Joshi 56e2c9db97 Ensure that If the trigger function definition is changed, drop and recreate the trigger in the schema diff. Fixes #7630 2022-08-22 11:56:11 +05:30
Akshay Joshi 0f53fc8511 Fixed Spanish translations typo. Fixes #7625
Submitted by: Alan Nevot
2022-08-22 10:20:10 +05:30
Yogesh Mahajan f873ab5374 1) Ensure that the next button should be disabled if the password did not match for Azure deployment. Fixes #7616
2) Fixed an issue where Azure cloud deployment failed. Fixes #7617
2022-08-18 18:39:52 +05:30
Akshay Joshi e455114441 1) Fixed column "none" does not exist issue, while comparing schema objects. Fixes #7591
2) Fixed an issue where schema diff did not pick up the change in RLS policy. Fixes #7596
3) Ensure that schema diff maintains view ownership when view definitions are modified. Fixes #7611
2022-08-18 13:40:28 +05:30
Aditya Toshniwal 306b184e11 1. Fixed an issue where Alt-Shift-Q didn't work after creating a new query. Fixes #7575
2. Fixed an issue where the Query Editor loses focus when saving a query (Alt+s). Fixes #7521
3. Ensure that an error is thrown if clipboard access is not provided and change the copy rows shortcut. Fixes #7452
2022-08-17 17:23:44 +05:30
Akshay Joshi da927f4897 1) Autocomplete on keypress should be set to False by default.
2) Update the documentation for the locked option in user management.
2022-08-17 14:38:37 +05:30
Khushboo Vashi d45072fae5 Ensure that rename panel should work on view/edit panels. Fixes #7540 2022-08-16 15:31:55 +05:30
Akshay Joshi ff4c5392d6 Fixed crypt key is missing issue when logout from the pgAdmin. Fixes #7614 2022-08-16 15:29:57 +05:30
Akshay Joshi 2d27a97b8c Fixed improper parsing of HTTP requests in Pallets Werkzeug v2.1.0 and below (CVE-2022-29361). Fixes #7602 2022-08-16 12:20:01 +05:30
Khushboo Vashi ae5254e8a9 Fixed an issue where the cloud deployment wizard creates the cluster with the
High Availability even if that option is not selected. Fixes #7608
2022-08-14 07:14:10 +05:30
Aditya Toshniwal e1fa1b0396 Ensure that the children of information_schema and pg_catalog node should be displayed. Fixes #7587 2022-08-11 10:53:07 +05:30
Aditya Toshniwal c2b23465cc 1) Added support to show all background processes in separate panel. Fixes #3709
2) Port process watcher to React. Fixes #7404
2022-08-11 10:49:45 +05:30
Akshay Joshi 271b6d91fc Port User Management dialog to React. Fixes #7345 2022-08-11 10:25:52 +05:30
Aditya Toshniwal 8b7ce2c276 Port change user password and 2FA dialog to React. Fixes #7568 2022-08-10 18:02:54 +05:30
Yogesh Mahajan f96653e9af Fixed an issue with rendering geometry when selecting a complete column. Fixes #7586 2022-08-09 13:28:09 +05:30
Pradip Parkale 8c24d28740 Remove the SQL files for the unsupported versions of the database server. Fixes #7462
Fixed API test cases for Postgres 14.4. Fixes #7527
2022-08-09 13:24:52 +05:30
Yogesh Mahajan fa6b77b42c Port Role Reassign dialog to React. Fixes #7344 2022-08-05 16:04:15 +05:30
Yogesh Mahajan 4c6e7d4f4f Fixed an issue with the error message being displayed at the right place for Azure deployments. Fixes #7497 2022-08-05 14:11:17 +05:30
Akshay Joshi 53887c32bf Port change ownership dialog to React. Fixes #7590 2022-08-05 14:11:17 +05:30
Dave Page 060d7ba46b Update the container base image to Alpine 3.16 (with Python 3.10.5). Fixes #7595 2022-08-04 11:50:56 +01:00
Dave Page 66a1123268 Clarify config settings that may need to be re-defined if SERVER_MODE or DATA_DIR are updated in an included config file. 2022-08-01 16:17:49 +01:00
Akshay Joshi 95312f2d14 1) Ensure that autocomplete does not appear when navigating code using arrow keys. Fixes #7573
2) Fixed an issue where autocomplete is not working after clearing the query editor. Fixes #7563
2022-08-01 14:38:32 +05:30
Yogesh Mahajan 6145dc76fc Added support to create triggers from existing trigger functions in EPAS. Fixes #7387 2022-07-28 11:16:05 +05:30
Akshay Joshi 81f52a82c8 Port About dialog to React. Fixes #7567 2022-07-28 10:11:40 +05:30
Aditya Toshniwal 4808df5e95 1) Port the file/storage manager to React. Fixes #7313
2) Allow users to delete files/folders from the storage manager. Fixes #4607
3) Allow users to search within the file/storage manager. Fixes #7389
4) Fixed an issue where new folders cannot be created in the save dialog. Fixes #7524
2022-07-19 15:27:47 +05:30
Akshay Joshi 4585597388 Added option to trigger autocomplete on key press in the query tool. Fixes #4488 2022-07-19 11:55:37 +05:30
Yogesh Mahajan 8f2bda2309 1) Preserve the settings set by the user in the import/export data dialog. Fixes #7428
2) Fixed the JSON editor issue of hiding the first record. Fixes #7520
2022-07-18 10:54:03 +05:30
Aditya Toshniwal 9dde195af4 Ensure that notices should not disappear from the messages tab. Fixes #7512 2022-07-14 18:05:36 +05:30
Aditya Toshniwal 9468c80a78 Fixed an issue where comments on indexes are not displayed. Fixes #7508 2022-07-14 18:01:31 +05:30
Aditya Toshniwal 1fecf70123 Ensure that geometry should be shown for all the selected cells. Fixes #7519 2022-07-14 17:38:42 +05:30
Akshay Joshi 02b0f35442 1) Port change password dialog to React. Fixes #7341
2) Port named restore point dialog to React. Fixes #7546
2022-07-11 13:39:09 +05:30
Akshay Joshi a16e3523bd Ensure that the splash screen can be moved. Fixes # 7471 2022-07-07 14:11:36 +05:30
Akshay Joshi 50c930f5fa Make the controls on the Graph Visualiser collapsible and reorganize the controls. 2022-07-07 14:10:10 +05:30
Yogesh Mahajan 59f5c0d955 Added support for Azure PostgreSQL deployment in server mode. Fixes #7522 2022-07-06 11:43:49 +05:30
Akshay Joshi 8b62cd1f04 Added support for visualise the graph using a Pie chart in the query tool. Fixes #7487 2022-07-05 10:47:17 +05:30
Nikhil Mohite b283c0ba18 Port Master Password dialog to React. Fixes #7342 2022-07-04 12:16:23 +05:30
Pradip Parkale e59471d87d Ensure that dashboard graph API is not called after the panel has been closed. Fixes #7518 2022-07-04 12:03:18 +05:30
Fahar Abbas ed59584fe4 Fixed typo error for Statistics on the table header. Fixes #7523 2022-07-01 14:58:45 +05:30
Nikhil Mohite 9c745db413 Enable the start debugging button once execution is completed. Fixes #7517 2022-07-01 12:41:06 +05:30
Akshay Joshi b92e2fcfc9 Added support for visualizing the graphs using Stacked Line, Bar, and Stacked Bar charts in the query tool. Fixes #7486 2022-06-30 12:38:48 +05:30
Aditya Toshniwal cb635f6706 Removing dynamic module loading and replacing it with static loading. Fixes #7492
Gets rid of all occurrences and usage of get_own_javascripts since it is no longer used.
2022-06-30 11:06:50 +05:30
Akshay Joshi e46468321d Hide the tenant id from the scresnshot. 2022-06-29 15:20:29 +05:30
Yogesh Mahajan 4ad2fbf7bb Screenshot size updated.
refs #7506
2022-06-28 18:59:25 +05:30
Yogesh Mahajan 64e1e004ae Disables Azure PostgreSQL cloud deployment in Server mode.
refs #7506
2022-06-28 18:48:41 +05:30
Yogesh Mahajan 659009c1de Fixed permission denied error when deploying PostgreSQL in Azure using Docker. Fixes #7506 2022-06-27 19:36:20 +05:30
Nikhil Mohite 837e3e5e83 Fixed an issue where an error message is displayed when creating the new database. Fixes #7502 2022-06-24 15:09:48 +05:30
Pradip Parkale e95eb14651 Fixed an issue where the connection wasn't being closed when the user switched
to a new connection and closed the query tool. Fixes #7461

Fixed the 'Show activity?' issue which was missed during Dashboard porting.
2022-06-23 18:15:16 +05:30
Akshay Joshi 2556771c32 The following issues were fixed in Graph Visualiser:
1) Allow the user to set the row limit and chart line width.
2) Zoom should only be applied to X-axis, not both.
3) On clicking the 'Generate' button, the chart should return to its original zoom level.
4) Negative values are not displayed.

refs #7485
2022-06-23 14:52:11 +05:30
Nikhil Mohite 74f7fee8b5 Fixed an issue where pgAdmin stuck while creating a new index. Fixes #7460 2022-06-22 17:38:07 +05:30
Nikhil Mohite d90b2621da Fixed an issue where passwords entered in the 'Connect To Server' dialog were truncated. Fixes #7440 2022-06-22 17:35:22 +05:30
Akshay Joshi 93bc1f3c57 Added support for visualise the graph using a Line chart in the query tool. Fixes #7485 2022-06-22 17:18:51 +05:30
Nikhil Mohite 2adca6bbc4 1) Added mouse over indication for breakpoint area in the Debugger. Fixes #2647
2) Added search text option to the Debugger panel. Fixes #2648
3) Port Debugger to React. Fixes #6132
2022-06-15 11:37:54 +05:30
Yogesh Mahajan 7e1e068370 Added capability to deploy PostgreSQL servers on Microsoft Azure. Fixes #7178 2022-06-15 11:22:42 +05:30
Yogesh Mahajan 3297546e0a Added support for passing password using Docker Secret to Docker images. Fixes #7332 2022-06-15 11:07:56 +05:30
Akshay Joshi 3381516013 Upgrade Chartjs to the latest 3.8.0. Fixes #7469 2022-06-13 17:26:17 +05:30
Pradip Parkale 628e609e6a 1) Added the option 'Show template databases?' to display template databases regardless of the setting of 'Show system objects?'.
2) Ensure that the user should be able to create a template database using create dialog instead of updating it later.

Fixes #7351
2022-06-13 14:50:17 +05:30
Aditya Toshniwal 5c1493bd7e Fixed an issue where there is no setting to turn off notifications in the Query Tool. Fixes #7423 2022-06-13 14:32:07 +05:30
Aditya Toshniwal 725726f083 Ensure that the Query Editor should be focused when switching between query tool tabs. Fixes #7441 2022-06-13 14:26:01 +05:30
Aditya Toshniwal ea3203f466 Fixed and issue where 'Use spaces' not working in the query tool. Fixes #7443 2022-06-13 11:46:09 +05:30
Aditya Toshniwal f615ef30f9 Skip the history records if the JSON info can't be parsed instead of showing 'No history'. Fixes #7468 2022-06-13 11:43:26 +05:30
Nikhil Mohite fd1f71587f Fixed an issue where the Database restriction is not working. Fixes #7453 2022-06-09 17:03:21 +05:30
Yogesh Mahajan 20bc17eb6f Updates documentation for the Traefik v2 container deployment. Fixes #7315 2022-06-02 17:37:57 +05:30
Akshay Joshi 4a17ad312f Update pgcli to latest release 3.4.1. Fixes #7411 2022-06-02 17:29:58 +05:30
Nikhil Mohite e3225b6565 Fixed the browser tree overlapping nodes and expansion issue. Fixes #6962 2022-05-28 13:26:17 +05:30
Aditya Toshniwal b507eb8857 Fixed an issue when switching between connections in the Query Tool dropdown,
the background and foreground colors should be changed. Fixes #7374
2022-05-26 15:31:18 +05:30
Khushboo Vashi 955bb22cd1 Fixed an issue when a table has a column with an array type with length or
precision, the column type is not selected while editing the table. Fixes #7408
2022-05-25 17:49:06 +05:30
Pradip Parkale a5ad956088 Ensure that when Authentication buttons are disabled their text is visible in the Dark and High contrast theme. Fixes #7347 2022-05-24 17:12:37 +05:30
Aditya Toshniwal 1e1e1f027a Fixed an issue where geometry is not visible when a single cell is selected. Fixes #7394 2022-05-24 17:08:02 +05:30
Aditya Toshniwal c5ca45c461 Ensure that null values are accepted for the numeric columns in react-data-grid. Fixes #7405 2022-05-24 15:02:06 +05:30
Aditya Toshniwal 04fa7dee68 Added missing toggle case keyboard shortcuts to the query tool. Fixes #7399 2022-05-24 14:54:43 +05:30
Akshay Joshi efe613d13e Fixed an issue where comments on domain constraints were not visible when selecting a domain node. Fixes #7403 2022-05-24 14:50:33 +05:30
Aditya Toshniwal 6d26d5833f Added support for multi-cell selection in the query tool grid. Fixes #7380 2022-05-24 11:39:34 +05:30
Khushboo Vashi 345cfd7c60 Ensure that unwanted APIs should not be getting called for BigAnimal. Fixes #7368
Updated the BigAnimal icon.
2022-05-24 11:34:23 +05:30
Akshay Joshi 4f7bcc2919 Added the ability to detect and warn users about bidirectional Unicode characters. Fixes #7002 2022-05-23 16:04:21 +05:30