f4761f55f7
Fixed Multi-Factor Authentication bypass vulnerability (CVE-2024-4215). #7425
2024-04-29 13:41:02 +05:30
7c6fdcb12e
Disabled auto-fill on password fields. #2410
2024-04-29 11:44:17 +05:30
f724578463
Fixed API test cases for exec/call procedure.
2024-04-26 13:01:35 +05:30
92bb931b0a
Fixed an issue where incorrect select/exec scripts were generated for functions/procedures. #7334
2024-04-25 17:24:02 +05:30
fd65f1b644
Fixed all input boxes in pgAdmin to show browser auto-fill only where it is relevant. #2410
2024-04-24 11:27:08 +05:30
9f6ddd3cf9
Fixed violates check constraint issue when creating a pgAgent schedule. #7390
2024-04-23 17:27:11 +05:30
0d1e3f36e1
Revert "Fixed an issue where function arguments were getting enclosed in double quotes if written in upper case. #7222"
...
This reverts commit fc4b419987
2024-04-17 11:33:25 +05:30
30d2d1b23e
Fixed the following code smells:
...
1) useState call is not destructured into value + setter pair.
2) A fragment with only one child is redundant.
3) Unnecessary '.apply()' and '.call()'.
4) Expected the Promise rejection reason to be an Error.
2024-04-09 19:18:56 +05:30
102e0a9839
- Update MUI v4 to v5
...
- Remove the SCSS dependency completely and use MUI for theming.
- Update - date-fns, @date-io, notistack. Remove - popper.js, sass-loader.
- Cleanup webpack config.
- Port PSQL tool to use MUI themes instead of SCSS theme.
- Theme change will reflect realtime without refreshing pgAdmin.
2024-04-09 08:21:14 +05:30
edec9adbfb
Fixed SonarQube code smell 'Unnecessary use of boolean literals in conditional expression'.
2024-04-08 17:19:51 +05:30
fc4b419987
Fixed an issue where function arguments were getting enclosed in double quotes if written in upper case. #7222
2024-04-04 16:48:00 +05:30
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
a85d907351
Fixed an issue where user was unable to share a newly registered server. #7111
...
* Fixed an issue where the clear SSH tunnel password option was disabled in desktop mode.
2024-04-01 16:57:47 +05:30
9f31ec115a
Fixed Schema Diff issues while comparing Materialized View. #7271
2024-04-01 16:56:18 +05:30
fbbbfe22dd
Fixed a remote code execution issue in the validate binary path (CVE-2024-3116). #7326
2024-04-01 11:34:01 +05:30
4ae9132b59
Fixed an issue with empty locale provider while editing collation. #5611
2024-03-29 11:40:44 +05:30
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
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
053b1e3d69
Fixed issues in create collation. #5611
2024-03-27 17:30:16 +05:30
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
b742487dc3
Fixed an issue where table properties were not updating from properties dialog. #7210
2024-03-27 11:41:01 +05:30
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
1bcf343ceb
Fixed an issue where taking backup of a shared server was using server owner's user name. #7255
2024-03-26 11:28:20 +05:30
25074e46b4
Added support for provider, deterministic, version and RULES parameter while creating collation. #5611
2024-03-19 16:52:22 +05:30
cee0945a78
Revert the changes made to include a separate 'ALTER TABLE ...' query for setting defaults, as per the previous fix for issue #7165 .
2024-03-19 15:12:04 +05:30
c56aef335b
Fixed RESQL test cases for DBMS Schedule
2024-03-18 13:44:07 +05:30
097b630738
Added support for EDB Job Scheduler. #7098
2024-03-18 11:53:59 +05:30
bece59d4b3
Fixed schema diff wrong query generation for table, foreign table and sequence. #7165
2024-03-14 11:21:19 +05:30
7374997425
Fix an issue in table dialog where changing column name was not syncing table constraints appropriately. #7229
2024-03-08 11:45:32 +05:30
a5530f59f7
Fix sonarqube issues for the rule - 'If' statement should not be the only statement in 'else' block
2024-02-26 11:55:36 +05:30
2ab419c8a5
Fixed EPAS RESQL test case failure.
2024-02-23 11:25:54 +05:30
4faf2a3c6d
Fixed an issue where dependencies and dependents were not showing if a composite type is used as an attribute in another composite type. #7027
2024-02-21 11:18:44 +05:30
d3ede3151a
Upgrade CodeMirror from version 5 to 6. #7097
2024-02-21 11:15:25 +05:30
e81a036850
Fix an issue where the scripts created by generate script of Schema diff for Table with sequence was not working earlier. #7165
2024-02-15 11:38:44 +05:30
9ad223c41c
Fix an issue where constraint check control is enabled in edit table dialog. #7164
2024-02-09 16:26:46 +05:30
9462296d33
Fixed API tests failed due to #7113 changes.
2024-02-05 10:47:43 +05:30
8145e042a6
Fix a backend server error when creating a named restore point. #7166
2024-02-01 14:20:22 +05:30
711181c752
Ensure that the correct SQL is generated when changing the column data type to "char". #7113
2024-01-29 14:53:03 +05:30
3de19f66f2
Added support for column storage syntax while creating table. #6450
2024-01-29 11:32:34 +05:30
639a28fbfc
Fixed code smell 'Prefer using an optional chain expression instead, as it's more concise and easier to read'.
2024-01-25 16:51:40 +05:30
41fe1db884
Fixed PEP8
2024-01-25 12:51:29 +05:30
cafe69c235
Fixed SonarQube Bugs and API test cases.
2024-01-25 12:46:55 +05:30
0e0cbc40b8
Fixed SonarQube code smell Replace the unused local variable with '_'.
2024-01-24 18:33:43 +05:30
81fccc87b5
Added support to rename columns in Views. #6380
2024-01-22 12:27:55 +05:30
2d08b0dd13
Added configurable parameter to enable support for PasswordExecCommand in server mode. #6792
2024-01-12 17:34:40 +05:30
b28df5874e
Fixed an issue where multiple errors were showing if user does not have connect privileges. #7073
2024-01-12 17:20:51 +05:30
701085adaf
Fixed an issue where group membership information was displayed incorrectly. #7085
2024-01-12 16:48:49 +05:30
5240e8ccf8
Added BYPASSRLS|NOBYPASSRLS option while creating a Role. #6392
2024-01-11 19:14:01 +05:30
f5ba42bec8
Fixed API test case for Foreign Table.
2024-01-08 15:02:08 +05:30
26ec59ab5f
Limit the keyring calls based on save_password flag of server config.
2024-01-08 14:04:38 +05:30
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
5e710f7ee3
Fixed an issue where Schema Diff not generating difference for missing columns. #7104
2024-01-08 09:39:39 +05:30
740ce15bd7
Update copyright notices for 2024
2024-01-01 14:13:48 +05:30
2621050066
Fix an issue where connection string sequences do not persist after updating server details. #7041
2024-01-01 14:11:17 +05:30
01a118d495
Fixed an error-'amname' when generating ERD for database containing parition tables. #7064
2023-12-28 15:27:30 +05:30
a4e9f04a2e
Fixed an issue where changes done to a node using edit dialog are not reflecting on the properties tab if the properties tab is active. #7041
2023-12-27 11:06:04 +05:30
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
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
0d287df6dd
Administer pgAdmin Users and Preferences Using the Command Line Interface (CLI). #2483
2023-12-21 12:07:26 +05:30
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
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
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
f2876cabe8
1. Fixed an issue where database name was missing in an error message if name contains any special characters. #6488
...
2. Add a confirmation dialog before closing a query tool when a query is already running.
2023-11-30 18:23:52 +05:30
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
377216caec
Add support for generating ERD for a schema. #4580
2023-11-28 16:42:51 +05:30
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
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
e66cb54a58
Ensure user is not prompted for password if server password is saved and server configuration has invalid pgpass file parameter. #6934
2023-11-23 15:54:14 +05:30
115208c8d8
Reverse engineer serial columns when generating ERD for database/table. #6958
2023-11-23 15:50:54 +05:30
0358298090
Fix failing feature tests
2023-11-16 21:01:43 +05:30
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
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
cc239149ba
Fixed and improve few API test cases.
2023-11-16 14:43:10 +05:30
75a2d880f6
More fixes for UI issues found when testing wcDocker changes. #6479
2023-11-14 16:47:40 +05:30
7f49b891df
Fix an issue in ERD tool where SQL generated is missing columns for the table. #6920
2023-11-13 13:53:10 +05:30
370cb611d7
Clear the password field in the config database on clear saved server password. #6934
2023-11-09 13:02:19 +05:30
d4b57edede
Fixed an issue where the change server password is not working in desktop mode #6902
2023-11-09 12:06:42 +05:30
695c008245
Remove the max length of 255 from password exec command in server configuration dialog. #6877
2023-11-06 11:55:29 +05:30
96fccd28a9
Upgrade Flask, Flask-SQLAlchemy, Flask-WTF, Flask-Babel, Flask-Security-Too, WTForms, Werkzeug and keep backward compatibility with Python 3.7
2023-11-03 18:19:01 +05:30
6062084128
Fixed the query generated when creating subscription where copy_data parameter was missing. #6817
2023-11-03 14:58:48 +05:30
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
1bfd8d7f3c
Fix foreign table api test failures for EPAS.
2023-10-27 12:58:47 +05:30
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
e587ef404c
Fix an issue where the default server-group is being deleted if the load-server json file contains no servers. #6602
2023-10-23 11:16:57 +05:30
eead9b77e7
Fixed issue where MSQL for delete column was not generating. #5749
2023-10-16 15:04:31 +05:30
3a62fc5a2a
Fix issues found during testing. #6229 , #6836
2023-10-12 16:58:46 +05:30
10adb6a11b
Add support for setting prepare threshold in server connection. #6285
2023-10-12 16:54:06 +05:30
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
73430a2062
Fixed an issue where user was not able to assign new/old columns as primary key once column with primary key is deleted. #5749
2023-10-11 13:29:19 +05:30
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
4450145d31
Fixed issues reported while testing foreign table properties. #640
2023-10-11 11:53:14 +05:30
7ce07f7dcf
Fixed issues reported while testing foreign table node. #640
2023-10-06 12:28:40 +05:30
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
b9d3006915
Fix failing RE-SQL test cases for foreign tables on EPAS servers.
2023-09-29 13:38:22 +05:30
3cd547f879
Implement column node and its features for foreign table. #640 , #6373 , #6674
2023-09-26 15:03:03 +05:30
3258851425
Access method for partitions not visible when opening table properties. #6378
2023-09-18 18:49:11 +05:30
ffec77d50b
Added compression method option while creating a column. #6379
2023-09-14 11:56:00 +05:30
d69b4282c8
Fixed issues reported while testing feature #6378
2023-09-13 16:19:07 +05:30
8c91d40932
Fixed RESQL test case failure for EPAS 15. #6400
2023-09-13 10:50:29 +05:30
32403920fe
Enhancement of properties tab for column's collection by adding Primary Key and Not NULL columns. #2411
2023-09-07 11:54:02 +05:30
e9384615dc
Fixed linter error.
2023-09-06 11:43:55 +05:30
07d965ea46
Ensure that Materialized view size fields in Statistics should be human-readable. #6712
2023-09-06 11:31:04 +05:30
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
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
0b7eafaca0
Added the 'data type' column in the properties tab of the Columns collection node. #2411
2023-08-31 12:33:08 +05:30
5fb80af90e
Added all the new options of the 'WITH' clause in the subscription dialog. #4805
2023-08-25 12:48:31 +05:30
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
b2eb23eb8d
Fix pgAdmin 7.5 fails to render table SQL with extension loaded index method. #6630
2023-08-10 11:53:30 +05:30
da71c0c746
Fixed an issue where the 'CASCADE' keyword is always visible while creating an Extension. #3942
2023-08-09 18:17:08 +05:30
27c7ea2ff1
Added all like options while creating a table. #6377
2023-08-07 11:20:04 +05:30
00011b387a
Fixed issue where cycle syntax was not added in SQL when creating new sequence from UI. #6639
2023-08-04 11:57:28 +05:30
b01a93544f
Added cascade option while creating an extension. #3942
2023-08-03 17:23:03 +05:30
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
ce146b679c
Add support for TRUNCATE trigger in foreign table. #6448
2023-08-03 09:42:17 +05:30
0f86b78d87
Added support for PostgreSQL and EPAS 16 to ensure it works without any errors. #6588
2023-08-02 11:26:09 +05:30
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
a1c7265c41
Fix PEP8 issues with latest pycodestyle ( #6636 )
2023-07-31 18:14:39 +05:30
5c2d242ff8
Added unlogged option while creating a sequence. #6376
2023-07-27 17:37:22 +05:30
b4991a49a2
fixed issue where deduplicate_items was selected for PG version 12 and below. #6374
2023-07-17 11:19:55 +05:30
d3753ee132
Fix an issue where the edit server fails in desktop mode if the server password is not stored. #6489
2023-07-17 11:19:20 +05:30
ab0b1dd40c
Added all supported index storage parameters while creating an index. #6374
2023-07-11 18:12:53 +05:30
def1f31ba8
Ensure that Backup, Restore, and Maintenance should work properly when pgpass file is used. #6499
2023-07-11 15:34:27 +05:30
62056cab14
Fixed sonaqube security smells and bugs
...
1. Delete unreachable code or refactor the code to make it reachable.
2. Unexpected var, use let or const instead.
3. Remove useless assignment to variable.
4. Define a constant instead of duplicating the literal
5. Remove commented out code
2023-07-10 10:36:15 +05:30
70d356d0f4
Fixed API test cases failing for v13 and below
2023-07-06 14:44:48 +05:30
bccdb131ee
Fixed an issue where Partitions are not visible in EPAS Servers.
2023-07-06 12:58:06 +05:30
c12f229c64
Added check to enable/disable Concurrently and Finalize menu of Detach Partition. #6369
2023-07-05 18:36:59 +05:30
0687c52fdc
Added support to detach partitions using concurrently and finalize. #6369
2023-06-29 10:33:39 +05:30
ca01116700
Typecast some parameters before sending to GUI in server module.
2023-06-23 19:15:21 +05:30
78db1e3c36
Added security_invoker option while creating a view. #6371
2023-06-22 11:14:03 +05:30
595a0dfc55
Added 'OR REPLACE' clause while creating trigger. #6370
2023-06-21 11:13:53 +05:30
466e969776
Fix an issue where object explorer tree crashes occasionally. #5306
2023-06-21 11:05:58 +05:30
4746fbd346
Fixed an issue where View/Edit data is throwing an error if the user deleted and re-create the same table for which View/Edit data was opened. #6431
2023-06-19 19:37:10 +05:30
36949aef99
Added option to create unique index with nulls not distinct. #6368
2023-06-19 15:09:48 +05:30
557f33c4f9
Added support to drop databases using the 'WITH (FORCE)' option. #6367
2023-06-19 15:04:40 +05:30
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
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
c69315bb43
Fixed SSH Tunnel save password issue.
2023-06-05 15:13:15 +05:30
f6275688e7
Fixed following issues: ( #6361 )
...
1) Ensure that SSH Tunnel should work properly after upgrading to 7.2 from 7.1. #6341
2) Ensure that the master password dialog should not visible if the parameter MASTER_PASSWORD_REQUIRED is set to False. #6353
2023-06-05 12:45:34 +05:30
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
b5af4ead0d
Fix an issue where editing a database object de-selects it on the browser tree. #6136
2023-06-02 10:59:47 +05:30
7dfcc73e95
Update the publication dialog tabs and the docs. #5868
2023-05-30 16:45:13 +05:30
05b595d32d
Fixed the failure of python test cases of EPAS and JS tests for publication node. #5868
2023-05-29 17:41:45 +05:30
396a22b6be
Fix count SQL for EPAS schemas to show/hide nodes. #5048
2023-05-29 17:09:27 +05:30
72794f9524
Fix issues related to show/hide empty nodes feature. #5048
2023-05-26 18:07:51 +05:30
8b7eeca545
Implement new PostgreSQL 15 features in publication dialog and SQL. #5868
2023-05-25 16:25:12 +05:30
cba3dc9457
Fixed an issue where Operators collection node throwing an error. #6325
2023-05-25 11:56:45 +05:30
fec63c6cf3
Text improvement for the OS secret store feature. #5123
2023-05-24 18:06:21 +05:30
b6924a84d6
Fixed error occurring while opening query tool after togging Resume/Pause wal replay. #6026
2023-05-23 15:30:44 +05:30
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
b1eba4fc4c
Fix incorrect number of foreign tables displayed. Show column comments in RE-SQL. #6279
2023-05-22 17:33:33 +05:30
Khushboo Vashi
Pravesh Sharma
Akshay Joshi
Yogesh Mahajan
JyotiEdb
Aditya Toshniwal
Anil Sahoo
Nikhil Mohite
Benjamin Blattberg
Anil Sahoo
Aditya Toshniwal