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
Aditya Toshniwal
ed2a73f7ff
Fix artifact archive error for EPAS tests on github workflows
2024-04-09 09:52:39 +05:30
Aditya Toshniwal
b5e5f8ac4c
Update release notes.
2024-04-09 08:37:41 +05:30
Aditya Toshniwal
c9345ad618
Fixed an issue where double dollar quoted code is treated as string in syntax highlighter. #7294
2024-04-08 15:32:01 +05:30
Akshay Joshi
475e3689f7
Added the new columns last_seq_scan and last_idx_scan from the pg_stat_all_tables and pg_stat_all_indexes tables respectively to the Statistics tab. #6728
2024-04-04 16:39:12 +05:30
Akshay Joshi
c90508cece
Update version for release 8.5
2024-04-01 17:01:55 +05:30
Khushboo Vashi
fbbbfe22dd
Fixed a remote code execution issue in the validate binary path (CVE-2024-3116). #7326
2024-04-01 11:34:01 +05:30
Akshay Joshi
00e17ef152
Fixed an issue where the 'Save Password' option for SSH tunneling password was consistently disabled. #7139
2024-03-28 13:58:03 +05:30
Aditya Toshniwal
ace73ebb60
Added support for viewing Log Based Clusters. #7216
...
Co-authored-by: Akshay Joshi <akshay.joshi@enterprisedb.com>
2024-03-28 12:19:34 +05:30
JyotiEdb
053b1e3d69
Fixed issues in create collation. #5611
2024-03-27 17:30:16 +05:30
Pravesh Sharma
082fb165d3
Implemented shortcut mapping for the edit menu in the query tool.
2024-03-27 16:41:08 +05:30
Akshay Joshi
8ab78dc40d
Fixed an issue where serial, bigserial, and smallserial columns were always shown as different in the schema diff.
2024-03-27 16:11:40 +05:30
Khushboo Vashi
6ecd7b20f7
Update release notes.
2024-03-27 11:50:31 +05:30
Akshay Joshi
089f890f2e
Fixed an issue where Triggers, Rules, Indexes were absent from the Schema Diff when comparing views. #7271
...
Fixed an issue in Schema Diff where Columns with sequences get altered unnecessarily. #4413
2024-03-27 11:40:23 +05:30
Khushboo Vashi
1f0a2fd150
Update release notes.
2024-03-26 18:24:44 +05:30
Aditya Toshniwal
cc1ce09b73
More CodeMirror fixes. #7268
...
Fix query tool autocomplete results when cursor is in between the SQL query. #7299
Fix an issue in query tool where custom keyboard shortcuts are not working for some. #7305
2024-03-23 18:22:06 +05:30
JyotiEdb
25074e46b4
Added support for provider, deterministic, version and RULES parameter while creating collation. #5611
2024-03-19 16:52:22 +05:30
Akshay Joshi
c56aef335b
Fixed RESQL test cases for DBMS Schedule
2024-03-18 13:44:07 +05:30
Akshay Joshi
097b630738
Added support for EDB Job Scheduler. #7098
2024-03-18 11:53:59 +05:30
Aditya Toshniwal
f351b10ed0
Fix an issue in query tool where toggle case of selected text loses selection. #7277
...
Also make changes to give pgAdmin shortcuts higher priority over CodeMirror default shortcuts.
2024-03-14 18:18:53 +05:30
Aditya Toshniwal
794c7cb335
Fixed multiple editor related issues:
...
1. Replace option in query tool edit menu is not working on non-Mac OS. #7262
2. Format SQL shortcut and multiline selection are not working. #7268
3. "Use Spaces?" Preference of Editor is not working. #7269
2024-03-11 16:52:56 +05:30
Akshay Joshi
9c9766ca0a
Update release note.
2024-03-08 11:49:36 +05:30
Akshay Joshi
4e49d752fb
Unsafe Deserialization and Remote Code Execution by an Authenticated user in pgAdmin 4 (CVE-2024-2044).
2024-03-04 13:22:09 +05:30
Akshay Joshi
1e90245650
Update release note
2024-03-01 12:14:43 +05:30
Akshay Joshi
d8c007f644
Fixed duplicate explicit target name issue in the documentation.
2024-02-29 19:14:59 +05:30
Akshay Joshi
cfbf4d8452
Updated URL in the container deployment docs.
2024-02-29 18:37:34 +05:30
Akshay Joshi
864f23c60d
Update release note.
2024-02-29 11:53:33 +05:30
Anil Sahoo
8dffcf842f
Added documentation for System Statistics tab. #7148
2024-02-29 11:34:54 +05:30
Aditya Toshniwal
e272552780
Fix doc builds failing because of release notes update
2024-02-23 14:13:06 +05:30
Aditya Toshniwal
dfbbc3b1a1
Update release notes.
2024-02-23 14:08:56 +05:30
Khushboo Vashi
125d36e7d2
Update release notes.
2024-02-22 16:43:50 +05:30
Aditya Toshniwal
b5bd236387
Fix edit menu related issues of query tool codemirror
2024-02-21 15:54:57 +05:30
Akshay Joshi
41812c9fde
Update release note.
2024-02-21 11:25:55 +05:30
Aditya Toshniwal
721290b1e9
Fix an issue where type column in dependents/dependencies tab is not showing correct label. #7225
2024-02-20 16:23:05 +05:30
Khushboo Vashi
10929157b4
Update Release Note.
2024-02-15 15:00:48 +05:30
Yogesh Mahajan
5a74022e8a
Allow preferences customization using a configuration file. #6058
2024-02-15 14:58:31 +05:30
Akshay Joshi
a74b0232f9
Update release note
2024-02-15 11:41:42 +05:30
Khushboo Vashi
389896411a
Update Release Notes.
2024-02-14 11:24:20 +05:30
octo-dama
6adae46a4c
Add --yes option for skipping the confirmation prompt while deleting the user via CLI for scripting purpose. #7204
2024-02-14 11:20:44 +05:30
Akshay Joshi
96ed38292f
Added release note for v8.4
2024-02-09 16:49:58 +05:30
Anil Sahoo
47b2bc8a83
1) Fix the tabbed panel backward/forward shortcut for tabs. #6808
...
2) Remove shortcuts for the dialog tab backward/forward.
3) Used hotkeys.js in place of mousetrap for listening to keyboard shortcuts.
2024-02-09 16:33:30 +05:30
Akshay Joshi
c92e9c2953
Fixed all broken submenus of the Help menu due to the SonarQube fix.
2024-02-08 12:24:40 +05:30
Akshay Joshi
af1f4b3aa7
Update version for release v8.3
2024-02-05 12:38:40 +05:30
Aditya Toshniwal
0904adaed0
Update release notes
2024-02-02 12:55:13 +05:30
Pravesh Sharma
f7045b58d4
Fixed an issue where format sql was messing up operator. #5083
...
- The formatting is done on client side now using sql-formattor JS lib. Backend API based formatting is removed.
- Added new options data type case, expression width, function case, lines between queries, logical operator new line and new line before semicolon available in the new lib.
- Removed old options comma-first notations, re-indent aligned, re-indent, strip comments and wrap after N characters as not available in the new library.
- Capitalise casing is replaced with Preserve casing as it is not supported by the new library.
- Also fixes #6785 , #6990 , #7115 .
2024-02-02 12:28:25 +05:30
Khushboo Vashi
1ac385be27
Update documentation for creating the configuration database.
2024-02-01 14:37:09 +05:30
Akshay Joshi
e23ef5d9df
Update release note.
2024-01-29 14:54:53 +05:30
Pravesh Sharma
3de19f66f2
Added support for column storage syntax while creating table. #6450
2024-01-29 11:32:34 +05:30
Aditya Toshniwal
47aa070cc3
Update release notes
2024-01-22 16:17:58 +05:30
Aditya Toshniwal
e80e82cd7f
Allow drag-n-drop columns collection tree node as comma separated columns. #4419
2024-01-22 13:19:04 +05:30
Khushboo Vashi
29f13f8832
Update release notes.
2024-01-22 12:41:43 +05:30
Akshay Joshi
81fccc87b5
Added support to rename columns in Views. #6380
2024-01-22 12:27:55 +05:30
Akshay Joshi
60983a25d2
Updated release note.
2024-01-12 17:48:56 +05:30
Akshay Joshi
5240e8ccf8
Added BYPASSRLS|NOBYPASSRLS option while creating a Role. #6392
2024-01-11 19:14:01 +05:30
Akshay Joshi
30509d1bc1
Added copy server support, allowing the duplication of existing servers with the option to make certain modifications. #6085 ( #7106 )
...
Added copy server support, allowing the duplication of existing servers with the option to make certain modifications. #6085
2024-01-08 12:16:49 +05:30
Akshay Joshi
5e710f7ee3
Fixed an issue where Schema Diff not generating difference for missing columns. #7104
2024-01-08 09:39:39 +05:30
Khushboo Vashi
fdaedacf40
Fixed multiple CLI issues. #2483
2024-01-03 16:09:42 +05:30
Akshay Joshi
fcfe7cfb7c
Fixed an issue where DB Restrictions were not visible on the server dialog. #7059
2024-01-01 16:26:02 +05:30
Aditya Toshniwal
5248055a01
Fixed an issue where auto commit/rollback setting not persisting across query tool connection change. #7091
2024-01-01 15:34:40 +05:30
Akshay Joshi
740ce15bd7
Update copyright notices for 2024
2024-01-01 14:13:48 +05:30
Akshay Joshi
2b736c18ab
Ensure that eventlet's subprocess should be used following the resolution of an issue with Python 3.12 by eventlet. #6926
2024-01-01 14:01:56 +05:30
Khushboo Vashi
3fa4e82af9
Introduce LDAP configuration parameter LDAP_IGNORE_MALFORMED_SCHEMA to ignore fetching schema from the LDAP server. #7062
2024-01-01 11:04:57 +05:30
Aditya Toshniwal
01a118d495
Fixed an error-'amname' when generating ERD for database containing parition tables. #7064
2023-12-28 15:27:30 +05:30
Akshay Joshi
8c06d93303
Fixed an issue where an error occurred in the SQL tab when using an extended index(pgroonga). #7002
2023-12-22 13:59:51 +05:30
Akshay Joshi
9ccdaf73cd
Ensure that the 'Dbo' schema is displayed as a regular schema rather than a system catalog schema. #7061
2023-12-21 18:52:27 +05:30
Aditya Toshniwal
09b83e54a2
Fixed an issue where pgAgent job schedule dialog is not opening for edit. #7070
2023-12-21 17:49:01 +05:30
Aditya Toshniwal
c8d6ff8a6d
Fixed an issue where query tool title did not change after 'Save As' until any new change is made. #6193
2023-12-21 17:41:27 +05:30
Khushboo Vashi
0d287df6dd
Administer pgAdmin Users and Preferences Using the Command Line Interface (CLI). #2483
2023-12-21 12:07:26 +05:30
Akshay Joshi
a973c9c62c
Remove EPAS 11 and add EPAS 16 in the GitHub actions.
2023-12-20 12:08:19 +05:30
Akshay Joshi
a22b2a6074
Added keep-alive support for SSH sessions when connecting to a PostgreSQL server via an SSH tunnel. #7016
2023-12-19 16:16:03 +05:30
Nikhil Mohite
04580652ab
Allow users to convert View/Edit table into a Query tool to enable editing the SQL generated. #5908
2023-12-19 15:52:57 +05:30
Akshay Joshi
75a1b4b17e
Update message catalog for v8.1
2023-12-07 20:06:01 +05:30
Akshay Joshi
e207a82dbb
Remove the 'Close Window' submenu specifically for OSX to prevent unintended closure of the entire application. #6814 (partial fixed)
2023-12-05 12:29:28 +05:30
Anil Sahoo
4b71519b80
Rename all references of 'Execute query' to 'Execute script' to be more relevant. #6842
2023-12-04 12:28:53 +05:30
Yogesh Mahajan
4e2aa82ddd
Provide a way to bypass the SSL cert verification for OAuth2 provider. #6095
2023-12-04 11:19:14 +05:30
Akshay Joshi
444f3a3189
Update release note.
2023-12-01 13:05:56 +05:30
Akshay Joshi
2b2ff0d260
Ensure that indexes created by constraints are visible in the object explorer when "Show system objects" is enabled. #6717
2023-12-01 13:02:21 +05:30
Aditya Toshniwal
16d1df2a1b
Fixed an issue where schema diff tool is not loading preferences on start. #7017
2023-11-30 15:31:23 +05:30
Akshay Joshi
fd1a0753bc
Fixed an issue where the Schema was not visible in the dropdown for table properties or when creating a new table. #6964
2023-11-29 13:09:01 +05:30
Akshay Joshi
f3fb76f669
Update release note
2023-11-28 16:46:32 +05:30
Aditya Toshniwal
377216caec
Add support for generating ERD for a schema. #4580
2023-11-28 16:42:51 +05:30
Aditya Toshniwal
c9590b2d62
Remove botocore from requirements as it is installed by boto3
2023-11-28 16:34:49 +05:30
Pravesh Sharma
412375af3c
- Add support for creating a function with custom return type. #6854
...
- Fixed an issue where create object dialog title was not showing object type name.
2023-11-28 15:54:44 +05:30
Akshay Joshi
3bd2dec663
Fixed an issue where the Vacuum option INDEX_CLEANUP have an incorrect value ('AUTO') for database versions < 14. #6984
2023-11-28 12:32:57 +05:30
Akshay Joshi
85255b65b1
1) Ensure that the Authentication Source in the drop-down of the UserManagement dialog aligns with the entries specified for AUTHENTICATION_SOURCES in the configuration file. #6950
...
2) Fixed an issue where the pgAdmin page went blank when clicking the delete button in the User Management dialog. #6989
2023-11-27 14:16:49 +05:30
Akshay Joshi
338bb64a55
Fixed an issue where reading process logs throws an error when DATA_DIR is moved to a networked drive. #6803
2023-11-23 16:32:52 +05:30
Akshay Joshi
a9ca7a2fd4
Update release note
2023-11-23 15:59:03 +05:30
Akshay Joshi
d8bcc11a95
Remove EPAS 11 and added EPAS 16 in the Binary Path.
2023-11-20 17:31:39 +05:30
Akshay Joshi
9f203cf7d7
Update release note
2023-11-20 11:56:53 +05:30
Khushboo Vashi
06a612481f
Update release notes.
2023-11-20 11:36:16 +05:30
Everton Seiei Arakaki
682d6597e4
Fix an issue where OAUTH_ADDITIONAL_CLAIMS does not recognise AzureAD with > 150 groups. #6835
2023-11-20 11:33:39 +05:30
Akshay Joshi
101f6fc103
1) Remove the version folder from the Windows Default Installation path.
...
2) Rename the release note to 8.0
3) Update the version for release v8.0
2023-11-17 17:52:56 +05:30
Aditya Toshniwal
0bc044fa67
Fixed an issue where Geometry Viewer renders geometry incorrectly after trying to view 3D or non-4326 SRID geometry. #6017
2023-11-17 16:29:01 +05:30
Akshay Joshi
302e1acabd
Fixed an issue where the data type of the array type was not visible for the column in the Foreign Table dialog. #6962
2023-11-16 17:49:26 +05:30
Aditya Toshniwal
c9db4a0d16
Add DROP SQL for foreign keys in SQL generated by ERD when using WITH DROP option. #5770
2023-11-16 16:55:26 +05:30
Mirko
e5cba59a02
Add JSON key "SharedUsername" to servers.json example
2023-11-13 17:39:49 +05:30
Akshay Joshi
0e8868a650
Remove gettext from empty strings in the title of the storage graph. #6884
2023-11-13 16:20:51 +05:30
Akshay Joshi
0ac471d160
Fix an issue where import/export data is not working for shared servers. #6875
2023-11-13 13:40:38 +05:30
Aditya Toshniwal
ef0b30b1ca
Continue fixing multiple UI issues found when testing wcDocker changes. #6479
2023-11-06 18:08:16 +05:30
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