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
4b183f7988
Fixed resql test case. #5926
2023-05-22 16:35:06 +05:30
fb3b2a4635
Fix an issue where View RE-SQL is not quoting the column comments. #6280
2023-05-22 16:24:55 +05:30
cedfd12f6a
Add an option to hide/show empty object collection nodes. #5048
2023-05-22 14:55:01 +05:30
e04f5a0938
Fixed an issue where REVOKE ALL DDL in table SQL was added only for one role. #5926
2023-05-22 14:09:47 +05:30
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
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
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
6c7f5d1a6b
Ensure that connection heartbeat signals are stopped on server disconnect. #6147
2023-05-17 12:07:49 +05:30
30107e38f3
Ensure that "pause replay of wal"/"resume replay of wal" are enabled/disabled appropriately. #6026
2023-05-16 11:28:48 +05:30
2a22cf077c
Fix circular reference error for the multirange data types in the query tool. #6221
...
Add support for the multirange data types.
2023-05-10 10:32:47 +05:30
d6f01b552a
Ensure user/roles with special characters are quoted to avoid syntax error.#6234
2023-05-03 15:19:08 +05:30
4fbfcdfee9
Fix multiple object breadcrumbs bugs. #2078
2023-05-03 15:18:17 +05:30
a73f58160f
Fix an issue where running any query in query tool gives 'list index out of range' error. #5922
2023-05-03 11:05:00 +05:30
52829d6f31
Fix an issue in View SQL when column level privileges are set with multiple roles. #6189
2023-05-03 10:34:39 +05:30
0e0d0c7c2e
Fixed API test cases for Triggers in EPAS.
2023-04-27 17:46:58 +05:30
35cbe968f4
Fixed an issue where table node is not getting added on UI if the same name table is present in another schema.
2023-04-27 11:57:55 +05:30
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
1e7517dc98
Show object breadcrumbs path along with its comment on object hover. #2078
2023-04-26 11:18:16 +05:30
20132f8daa
Fix a typo in database delete test case.
2023-04-20 14:39:41 +05:30
d6ecc531e0
Added support to create an unnamed index. #3318
2023-04-20 12:35:10 +05:30
ed941b5b95
Fix a SQL error occurring on roles dependents SQL. #6128
2023-04-20 10:18:00 +05:30
947630e0f0
Added support to show statistics for materialized views. #3316
2023-04-14 16:27:43 +05:30
288ba1d1f9
Fixed an issue where collation was set to none if we remove it while creating partitioned table. #5820
2023-04-13 13:27:16 +05:30
15914fe5e3
Fix the dependents SQL of Roles which is throwing a type casting error on PostgreSQL 15. #6093
2023-04-10 12:25:12 +05:30
ca088e83f7
Fix server test cases for servers with blank password and trust
2023-04-03 17:51:35 +05:30
e334b87b4c
Add an extra None check for password before encryption to avoid possible failure
2023-04-03 17:21:16 +05:30
3eac4ba59e
Fixed an issue where MSQL is not loading while creating a new login role.
2023-04-03 14:50:45 +05:30
33953e9119
Fixed intermittent error "Connection Lost" shown while connecting to database.
2023-03-31 16:17:04 +05:30
94051a0991
Fix failing RE-SQL test cases for pgAgent.
2023-03-31 15:34:57 +05:30
21cbc6e9e5
Fix SQLs generated for pgAgent related nodes which were causing issues after psycopg3 changes. #5011
2023-03-31 10:48:16 +05:30
140494454a
Fixed linter errors after eslint upgrade.
2023-03-29 17:22:50 +05:30
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
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
66cb4e3bcf
Auto expand row edit form when a new row is added for Primary Key, Foreign Key, Unique Constraint and Exclusion Constraint. #3298
2023-03-27 17:14:37 +05:30
207812582d
1) Fixed RESQL test case for EPAS.
...
2) Update Dependencies.
2023-03-24 14:37:35 +05:30
366dd3a973
Remove psycopg2 completely.
2023-03-20 16:57:30 +05:30
89c8a7f907
Added option to create unique constraint with nulls not distinct. #5855
2023-03-15 18:55:42 +05:30
292d76b39e
Update SQLAlchemy, Flask, Flask-SQLAlchemy, and other packages to current versions. #5901
...
- Update Flask, Flask-SQLAlchemy, Flask-Babel, Flask-Security-Too, Flask-SocketIO, pytz, psutil, SQLAlchemy, bcrypt, cryptography, eventlet, Authlib, requests python packages
- Remove pinned dnspython, Werkzeug packages from requirements.txt
2023-03-15 11:57:16 +05:30
3c56c0e4b7
Revert "Update SQLAlchemy, Flask, Flask-SQLAlchemy, and other packages to current versions. #5901"
...
This reverts commit 31818bb67a
2023-03-09 16:53:43 +05:30
31818bb67a
Update SQLAlchemy, Flask, Flask-SQLAlchemy, and other packages to current versions. #5901
...
Remove the python version check from the requirements.txt.
2023-03-08 18:26:51 +05:30
53f460ca7d
Fixed typo
2023-03-08 11:23:41 +05:30
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
ca33283930
Make 'using' and 'with check' fields a textarea in the RLS policy. #5874
2023-03-07 12:19:03 +05:30
55b917f24b
1) Ensure that when '--pkg resql' is provided then only RESQL test cases should run.
...
2) Fixed the RESQL test cases for Sequences. #5810
2023-02-28 16:24:29 +05:30
9abbd30790
Fix an issue where sequence owner is remove on sequence edit. #5810
2023-02-22 14:06:44 +05:30
f404fdcf8a
Fixed an issue where the user can't create trigger AFTER UPDATE OF. #5790
2023-02-20 17:37:17 +05:30
5f52bb59dd
Fix json issues ( #5865 )
2023-02-16 10:46:39 +00:00
5e0daccf76
Added support for psycopg3 along with psycopg2. #5011
2023-02-15 11:31:29 +05:30
7a4951f211
Remove dependency on simplejson package.
2023-02-15 11:10:12 +05:30
5303a36ff4
Fixed an issue where Clear Saved Password should be disabled if the password is already cleared. #5773
2023-02-14 15:47:40 +05:30
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
be72cee6be
Fix failing jasmin test cases. #5701
2023-02-10 14:47:29 +05:30
713ddb5f62
Remove usage of jQuery in pgAdmin.
...
Remove usage of Bootstrap in React components. #5701
2023-02-10 10:28:39 +05:30
696cb0fa05
Ensure that Grant column permission to a view is visible in the SQL tab. #5685
2023-02-10 10:26:01 +05:30
b3a3b8beab
Revert "Fixed an issue where the default value of string for columns should wrap in quotes in the create script. #5577"
...
This reverts commit 34e409f313
2023-02-02 15:32:29 +05:30
cdc1248794
Send the username to server node when created. #5702
2023-02-02 13:58:09 +05:30
932dcd9666
Fix an issue where role is used as username for newly added servers when opening query tool. #5702
2023-02-01 13:11:00 +05:30
7a18ceab64
Fixed the server heartbeat logging issue when server is removed. #5567
2023-01-30 15:39:34 +05:30
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
fd1c26408b
Modify the logic to show the connection string for the shared servers. #4728
2023-01-24 17:22:54 +05:30
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
6ae91592d1
Fix orphan database connections resulting in an inability to connect to databases. #5567
2023-01-19 15:57:02 +05:30
33aea87dea
Incorporated review comments. #5647
2023-01-02 13:30:49 +05:30
98184e5835
Update copyright notices for 2023
2023-01-02 11:53:55 +05:30
67bc0c23ef
Fixed an issue where row count notification was disappearing automatically. #5647
2023-01-02 10:54:24 +05:30
34e409f313
Fixed an issue where the default value of string for columns should wrap in quotes in the create script. #5577
2023-01-02 10:53:14 +05:30
64af035ce9
Ensure that the submenus under the trigger's context menu are enabled/disabled correctly. #5627
2023-01-02 10:49:36 +05:30
d2e00282e2
Fixed an issue where incorrect password used with shared server. #5487
2022-12-22 10:34:02 +05:30
ffcf7ccbf9
Fixed an issue where Tablespace location shows error "Location cannot be empty".
2022-12-19 10:54:30 +05:30
6eec5c3842
Fixed an issue while updating server node info removes the clear saved password menu. #5598
2022-12-14 15:54:17 +05:30
d7eb9f723f
Fixed RESQL test case failure. #5470
2022-12-09 14:09:01 +05:30
c42a90db8a
Fixed an issue where tablespace was missing on partition tables in SQL. #5470
2022-12-08 12:54:45 +05:30
2480d08e0f
Added native menu support in desktop mode. #5503
2022-12-06 18:16:36 +05:30
cddb24bc50
Fixed an error in the collation create script for PG-15. #5606
2022-12-06 12:50:09 +05:30
be011a4f3d
Fixed an issue where Transaction IDs were not found in session in the Query Tool. #5453
2022-12-05 10:48:42 +05:30
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
8d74de09cc
Remove all traces of Backbone, Underscore. #5493
2022-11-21 10:54:15 +05:30
41508f7f67
python 3 updates
...
- Fix super() calls for python 3
- No need to inherit objects.
- No need for u at the start of strings
- Tidied up some brackets and f-strings too
2022-11-19 10:13:41 +05:30
af32e3c296
Added the ability to generate ERDs for tables. #4756
2022-11-09 11:36:04 +05:30
16e28bb998
Fixed an issue where parameters for roles were not visible. #5429
2022-11-02 11:23:26 +05:30
201a27e4b3
Fix an issue where save button is enabled when table properties dialog is opened. #5098
2022-10-31 17:51:46 +05:30
ad871694cc
Fixed an issue where the dependents tab wasn't working for PG 15. #5455
...
changes after review
2022-10-31 17:45:53 +05:30
4925c6ce50
Ensure the Generate ERD option is hidden if the connection to the database is not allowed. #5149
2022-10-20 16:26:10 +05:30
e17c50d304
Added support for storing configurations of pgAdmin in an external database. #1832
2022-10-20 16:18:41 +05:30
a62fc2fbff
Added support for IAM token based authentication for AWS RDS or Azure DB. #3491
2022-10-15 14:49:04 +05:30
f79844e926
Fixed an issue where notifications disappeared quickly. #5364
2022-10-07 09:13:25 +05:30
b086e1fd83
Add option to generate SQL with DROP table DDL in ERD Tool. #4997
2022-10-06 09:30:45 +05:30
406119d96c
Allow reordering table columns using drag and drop in ERD Tool and create table. #4994
2022-10-03 11:18:22 +05:30
bedfad002d
Fixed RESQL test cases.
2022-09-30 10:42:11 +05:30
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
545c76a411
Ensure consistent orderings for ACLS when comparing schemas in the schema diff. #5101
2022-09-28 12:03:14 +05:30
0b6b2e733a
1) Remove Python's 'Six' package completely. #5357
...
2) Replace deprecated @abstractproperty with @property, @abstractmethod.
2022-09-26 12:47:31 +05:30
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
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
985546fff6
Fixed an issue where pgAdmin failed to start due to bin path migration. Fixes #7557
2022-09-15 13:13:38 +05:30
01a9a41bd9
1) Warn the user when connecting to a server that is older than pgAdmin supports.
...
2) Fixed Debugger API test cases.
2022-09-15 13:12:46 +05:30
1bff94d0ea
1) Ensure that properties should be displayed after the SonarQube fixes. (Patch by: Aditya)
...
2) Fixed Tablespace wrong path issue. (Patch by: Nikhil)
3) Align the label and drop-down on Graph Visualizer.
2022-09-12 14:05:21 +05:30
93f5fbc797
Fixed SonarQube issues.
2022-09-12 11:28:00 +05:30
ca8b5c68fd
Remove Backgrid and Backform. Fixes #6134
2022-09-10 14:22:49 +05:30
b128ba2f57
Fixed a couple of SonarQube issues.
2022-09-10 14:04:28 +05:30
cbf5886430
Fixed the following code smells:
...
1. Use concise character class syntax
2. Add a "break" statement or remove this "else" clause.
3. Replace this generic exception class with a more specific one.
4. Use a regular expression literal instead of the 'RegExp' constructor.
5. Use the opposite operator ("not in") instead.
2022-09-10 13:48:14 +05:30
d967d5046d
Fixed 'Remove the unused function parameter' code smell.
2022-09-09 18:36:51 +05:30
3b95a416ca
Fixed 'Remove the unnecessary boolean literals' code smell.
2022-09-09 15:23:18 +05:30
b73aa6d000
Fixed 'Remove the unnecessary boolean literals' code smell
2022-09-08 20:28:43 +05:30
b8f63adf41
Fixes following code smell reported by SonarQube:
...
1) Replace this if-then-else flow by a single return statement
2) Remove the unnecessary boolean literals.
2022-09-08 19:56:02 +05:30
7086719640
Fixed SonarQube issues.
2022-09-08 18:08:58 +05:30
18b77f15dd
Remove Alertify from pgAdmin completely. Fixes #7619
2022-09-08 15:16:48 +05:30
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
71a4b20d90
Fixed some SonarQube issues.
2022-08-30 14:21:33 +05:30
37082a955b
Sonarqube fixes.
2022-08-26 10:07:59 +01:00
41a3345101
Fixed an issue where the cursor was not visible in the code tab of the trigger dialog.
2022-08-23 18:45:43 +05:30
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
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
3583b094d0
Fixed API test cases for Postgres 14.4
2022-08-17 15:29:56 +05:30
084203debc
Fixed Securtiy Hotspot reported by SonarQube.
2022-08-12 17:10:26 +05:30
b4e5717bde
Fixed an issue where expanding the Shared Servers group would open the properties dialog for another server.
2022-08-11 13:10:18 +05:30
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
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
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
fa6b77b42c
Port Role Reassign dialog to React. Fixes #7344
2022-08-05 16:04:15 +05:30
53887c32bf
Port change ownership dialog to React. Fixes #7590
2022-08-05 14:11:17 +05:30
6145dc76fc
Added support to create triggers from existing trigger functions in EPAS. Fixes #7387
2022-07-28 11:16:05 +05:30
81b0d1138b
Remove Alertify dialog from Grant Wizard, Import/Export Servers and Cloud.
2022-07-28 10:14:04 +05:30
9468c80a78
Fixed an issue where comments on indexes are not displayed. Fixes #7508
2022-07-14 18:01:31 +05:30
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
7d0ed90796
Fixed API test cases.
...
refs #7492
2022-07-01 12:07:43 +05:30
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
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
74f7fee8b5
Fixed an issue where pgAdmin stuck while creating a new index. Fixes #7460
2022-06-22 17:38:07 +05:30
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
99c7a50fd6
Fixed an issue where the DB restriction check was not working for the collection node. Fixes #7453
2022-06-15 11:09:06 +05:30
fbf7b4aec3
Fixed RESQL test cases introduced after Template patch.
2022-06-15 10:57:04 +05:30
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
fd1f71587f
Fixed an issue where the Database restriction is not working. Fixes #7453
2022-06-09 17:03:21 +05:30
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
2c013c9f0f
Fixed RESQL test case for Domain and add missing 'COMMENT ON CONSTRAINT' statements.
2022-05-24 16:51:01 +05:30
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
6820b85902
Fixed Resource Group API test case.
2022-05-18 11:14:17 +05:30
b36004b702
The following are the initial fixes for PG15:
...
1) From PG 15 onward, the datlastsysoid has been removed from the table pg_database.
We have added the constant _DATABASE_LAST_SYSTEM_OID = 16383, all the objects below
this value are considered to be system objects. Modified the pgAdmin logic accordingly.
2) Concatenation operator '||' needs a specific typecast to be applied to query variables. Modified SQL's accordingly.
Fixes #7283
2022-05-17 20:32:17 +05:30
44f9ba4a57
Port connect server password dialog to React. Fixes #7337
2022-05-16 16:21:14 +05:30
c56fe813a5
Use gettext to wrap some strings.
2022-04-29 16:18:28 +05:30
7d91cca14d
1) Fixed linter error.
...
2) Fixed an issue where a password popup will appear on disconnecting from the server.
2022-04-26 18:16:33 +05:30
d336cade85
Fixed an issue where the table showed duplicate columns when creating multiple sequences on the same column. Fixes #7307
2022-04-21 12:42:33 +05:30
1ac13a2788
Added options 'Ignore owner' and 'Ignore whitespace' to the schema diff panel. Fixes #7282
2022-04-20 15:27:17 +05:30
c2f1a7bdc5
Ensure the database and schema restriction controls are not shown as a drop-down. Fixes #7255
2022-04-09 12:09:35 +05:30
b5b9ee46a1
1) Port query tool to React. Fixes #6131
...
2) Added status bar to the Query Tool. Fixes #3253
3) Ensure that row numbers should be visible in view when scrolling horizontally. Fixes #3989
4) Allow removing a single query history. Refs #4113
5) Partially fixed Macros usability issues. Ref #6969
6) Fixed an issue where the Query tool opens on minimum size if the user opens multiple query tool Window quickly. Fixes #6725
7) Relocate GIS Viewer Button to the Left Side of the Results Table. Fixes #6830
8) Fixed an issue where the connection bar is not visible. Fixes #7188
9) Fixed an issue where an Empty message popup after running a query. Fixes #7260
10) Ensure that Autocomplete should work after changing the connection. Fixes #7262
11) Fixed an issue where the copy and paste row does not work if the first column contains no data. Fixes #7294
2022-04-07 17:36:56 +05:30
3b35398925
Ensure that the error message 'CRYPTKEY_NOT_SET' is not displayed.
2022-04-05 17:01:12 +05:30
8f8adcf71b
1 Fixed the issue where db connection was getting disconnected for dashboard, if network is slow.
...
2 Fixed publication collection node properties issue which was missed during react node porting.
3 Removed unwanted variable from theme style sheet.
2022-04-05 13:40:22 +05:30
b397ba7787
Fixed issues related to porting of properties collection and dashboard.
...
refs #7132
2022-04-04 17:42:42 +05:30
fe416c838b
Fixed an issue where the browser tree state was not preserved correctly. Fixes #7176
2022-03-31 18:28:36 +05:30
cb052f1988
1) Port Properties panel for collection node, Dashboard, and SQL panel in React. Fixes #7132
...
2) Added transaction start time to Server activity sessions view. Fixes #7215
2022-03-30 12:06:59 +05:30
02e799c917
Fixed RESQL test cases for PG14.
2022-03-29 14:56:45 +05:30
7f2ff5af5c
Fixed an issue where SQL for revoke statements are not shown for databases. Fixes #4258
2022-03-28 17:35:54 +05:30
903b300b9e
1) Added support for unique keys in ERD. Fixes #7249
...
2) Fixed an issue where foreign key relationships do not update when the primary key is modified. Fixes #7197
2022-03-28 16:26:43 +05:30
9f992a9e5d
Fixed schema diff issue where function's difference DDL was showing incorrectly when arguments had default values with commas. Fixes #7263
2022-03-28 13:33:35 +05:30
d548a5bc50
Fixed schema diff issue in which the option 'null' doesn't appear in the DDL statement for the foreign table. Fixes #7265
2022-03-25 16:39:20 +05:30
826d2d913c
Fixed API and RESQL test case for Resource Groups.
2022-03-25 12:51:39 +05:30
0b4a874f30
Fixed an issue where unexpected error messages are displayed when users change the language via preferences. Fixes #7267
2022-03-24 16:08:13 +05:30
473afd950c
Ensure objects depending on extensions are not displayed in Schema Diff. Fixes #7221
2022-03-24 15:59:02 +05:30
2f37f0ca51
Fixes for the preferences dialog
...
1) Add server mode validation in the binary path.
2) Updated preferences tree rendering to avoid using the ReactDOM render.
3) Updated CSS for keyboard shortcuts checkbox border makes it consistent with input box border.
4) Fixed jasmine test case and improved code coverage.
5) Fixed SonarQube issues.
6) Added validation to disable "Maximum column with" option if "Column sized by" option is set to "Column name" in Query Tool -> Result grid.
7) Updated documentation with the latest screenshots.
8) Correct typo in the documentation. Fixes #7261
refs #7149
2022-03-23 13:28:35 +05:30
ba027e992e
Ensure that the values of certain fields are prettified in the statistics tab for collection nodes. Fixes #7216
2022-03-22 14:53:12 +05:30
74e794b416
Port preferences dialog to React. Fixes #7149
2022-03-21 13:29:26 +05:30
e256f734df
Fixed a schema diff issue where difference SQL isn't generated when foreign key values for a table differ. Fixes #7220
2022-03-10 14:41:21 +05:30
1b7dce124b
Fixes an issue where the connect server/database menu was not updated correctly. Fixes #7186
2022-03-07 15:28:28 +05:30
1af431dcc2
Fixed a schema diff issue in which user mappings were not compared correctly. Fixes #6956
2022-03-04 17:21:30 +05:30
83660ec9ed
Update EPAS server icon.
2022-03-02 13:30:59 +00:00
cbd29cf45b
Change the hostname validation to check only for leading and trailing spaces.
...
refs #7181
2022-02-18 11:39:11 +05:30
b1221d5517
Ensure that the user should be able to add new server with unix socket connection. Fixes #7181
2022-02-16 13:20:40 +05:30
5a8c916bc0
Added comments column for the functions collection node. Fixes #7152
2022-02-16 12:22:52 +05:30
677221cd9c
Rename the menu 'Disconnect Database' to 'Disconnect from database'. Fixes #7180
2022-02-15 18:34:31 +05:30
e61a1045f5
Added capability to deploy PostgreSQL servers on Amazon RDS. Fixes #7177
2022-02-14 12:13:48 +05:30
76a4dee451
Fixed the schema diff issue where tables have different column positions and a column has a default value. Fixes #7124
2022-02-11 10:21:43 +05:30
6d1926bb63
Rename the menu 'Disconnect Server' to 'Disconnect from server'. Fixes #7163
2022-02-07 16:12:30 +05:30
1141aeb524
1) Fixes the incorrect title shown for the error message in restore/backup.
...
2) Doc updates for webserver authentication.
3) Cleanup task for API tests.
2022-02-07 11:51:27 +05:30
4a195e7ef6
Fixed value error in the restore dialog. Fixes #7151
2022-02-03 17:44:54 +05:30
78f0c9c4a5
Ensure that owner should be ignored while comparing extensions. Fixes #7145
2022-02-02 11:25:07 +05:30
fddcbbff67
Fixed event trigger comparing issue in Schema Diff tool. Fixes #7146
2022-02-01 14:14:18 +05:30
bc0b25d995
1) Fixed an issue where a warning message was shown after database creation/modification. Fixes #7142 .
...
2) Added error boundary to schema view which will improve the exception stack trace details.
3) Fixed Jasmine test cases.
2022-01-31 13:41:22 +05:30
0ce3434631
Fixed code smell 'Update this function so that its implementation is not identical' reported by SonarQube.
2022-01-25 20:10:31 +05:30
094129e2be
Port Dependent, dependencies, statistics panel to React. Fixes #7016
2022-01-24 14:13:02 +05:30
3e86ed5d21
Added validation for Hostname in the server dialog. Fixes #7127
2022-01-24 12:04:35 +05:30
41bcce09ce
Remove the support of the 'Move object to another tablespace' feature.
2022-01-21 19:39:21 +05:30
343c3ee49c
Fixed following code smells reported by SonarQube:
...
1) Remove this redundant jump.
2) Remove this commented out code.
3) Variables should not be shadowed.
2022-01-21 18:54:23 +05:30
c983aae881
Port Import/Export dialog to React. Fixes #7017 .
2022-01-21 11:48:52 +05:30
1013d7ccdd
Fixed code smell reported by SonarQube.
2022-01-20 16:58:21 +05:30
d945c6f843
Fixed an issue where connections keep open to (closed) connections on the initial connection to the database server. Fixes #7035
2022-01-19 15:02:05 +05:30
9f836f5433
Fixed following code smells reported by SonarQube:
...
1) Immediately return this expression instead of assigning it to the temporary variable.
2) Extract this nested ternary operation into an independent statement.
3) Expected a `for-of` loop instead of a `for` loop with this simple iteration.
2022-01-18 14:49:54 +05:30
e3807ec3d6
Fixed following code smells reported by SonarQube:
...
1) Boolean checks should not be inverted.
2) Review this redundant assignment.
3) Extract this nested ternary operation into an independent statement.
4) Unexpected empty function.
5) Immediately return this expression instead of assigning it to the temporary variable.
2022-01-17 13:56:01 +05:30
3f7e921cce
Fixed code smell 'Unexpected empty arrow function' reported by SonarQube.
2022-01-12 18:59:21 +05:30
4e414f57e6
Fixed code smell 'Default parameters should be last' reported by SonarQube.
2022-01-12 18:40:18 +05:30
c98fb887cc
Fixed code smell 'Unexpected empty arrow function' reported by SonarQube.
2022-01-12 17:32:20 +05:30
d2457f2a1d
Ensure that Partitioned tables should be visible correctly when creating multiple partition levels. Fixes #7085
2022-01-12 16:29:13 +05:30
e38c38cd58
Fixed following SonarQube code smells:
...
1) Remove this useless assignment to a variable.
2) Remove the unused local variable.
2022-01-12 14:53:19 +05:30
374c5e952f
Fixed an issue where the Browser tree gets disappears when scrolling sequences. Fixes #7100
2022-01-11 18:03:11 +05:30
af6ff20020
Fixed SonarQube issues.
2022-01-07 19:58:19 +05:30
f56b4030f1
Fixed a schema diff issue where generated script adds unwanted line endings for Functions/Procedures/Trigger Functions. Fixes #7102
2022-01-06 13:08:50 +05:30
2786f7ac5a
Update copyright notices for 2022
2022-01-04 13:54:25 +05:30
44ab4648a8
Fixed an issue in SQL generation for PostgreSQL-14 functions. Fixes #7081
2021-12-31 14:30:53 +05:30
19016c3733
Ensure that help should be visible properly for Procedures. Fixes #7075
2021-12-31 14:21:38 +05:30
0ceb2e2767
Ensure that Truncate and Reset statistics should work. Fixes #7096
2021-12-30 12:19:33 +05:30
191e2b6242
Fixed an issue where an operation error message pop up showing the database object's name incorrectly. Fixes #7078
2021-12-28 13:49:04 +05:30
6d0ed91d31
Fixed an issue where the Owner is not displayed in the reverse engineering SQL for Procedures. Fixes #7077
2021-12-24 16:09:51 +05:30
461c0abce1
Fixed an issue where Tablespace is created though an error is shown on the dialog. Fixes #6745
2021-12-21 18:07:17 +05:30
92a997b16a
Rearrange tools menu on the basis of usability and form groups of similar sub-menus.
2021-12-16 18:29:44 +05:30
Anil Sahoo
Akshay Joshi
Khushboo Vashi
Pravesh Sharma
Aditya Toshniwal
Yogesh Mahajan
Aditya Toshniwal
Nikhil Mohite
Reese Russell
Matěj Cepl
Raman
Stranger10110
Mark Mayo
aelgn
danielkempenich
Dave Page
Pradip Parkale