8459a45d72
Update to use GitHub for source repos.
2022-09-21 10:56:03 +01:00
a2a18d4b4a
Fixed an error while saving changes to the ERD table. Fixes #5342
2022-09-19 16:20:07 +05:30
e2b00dda1b
Fixes a redirect vulnerability when the user opens the pgAdmin URL. Fixes #5343
2022-09-19 15:36:10 +05:30
d38d0ce805
1) Fixed the error message displayed when clicking the cloud server for which deployment is in progress. Fixes #5144
...
2) Ensure that if big animal authentication is aborted, API calls should be stopped. Fixes #5275
2022-09-15 18:44:07 +05:30
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
9ac233f244
Fixed an issue where ERD throws an error if variable is added to the column. Fixes #7709
2022-09-15 13:16:27 +05:30
985546fff6
Fixed an issue where pgAdmin failed to start due to bin path migration. Fixes #7557
2022-09-15 13:13:38 +05:30
16bcb7d4a2
Ensure that the browser tree should be refreshed after changing the ownership. Fixes #7607
2022-09-14 15:08:05 +05:30
eb60b3892d
Updated keyboard shortcut documentation. Fixes #7446
2022-09-13 16:43:34 +05:30
703cefd9ae
Replace the language selection 'Brazilian' with 'Portuguese (Brazilian). Fixes #7693
2022-09-12 14:51:18 +05:30
ca8b5c68fd
Remove Backgrid and Backform. Fixes #6134
2022-09-10 14:22:49 +05:30
7086719640
Fixed SonarQube issues.
2022-09-08 18:08:58 +05:30
603ce21d24
Fixed an issue where textarea of the JSON Editor does not resize with dialog. Fixes #7656
2022-09-08 15:31:36 +05:30
0c9c57e608
1. Resolved resize window issue for DDL result panel.
...
2. Updated the Screenshots.
3. Updated server group title to bold.
refs #6133
2022-09-08 15:24:43 +05:30
18b77f15dd
Remove Alertify from pgAdmin completely. Fixes #7619
2022-09-08 15:16:48 +05:30
e1942d8c9e
1) Port schema diff to React. Fixes #6133
...
2) Remove SlickGrid.
2022-09-07 19:20:03 +05:30
ad59380676
Fixed an issue with the non-visibility of columns added prior to import/export data. Fixes #7649
2022-09-07 17:40:52 +05:30
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
71c962f51c
Fixed ModuleNotFoundError when running setup.py to load/dump servers. Fixes #7663
...
Patch Sent By: Karl Maximilian Daenner
2022-09-06 11:48:55 +05:30
7c729d5f0e
Fixed API test case for change password in the server mode. Fixes #7648
2022-09-06 11:30:21 +05:30
317a17337d
Added supported database servers in the release notes.
2022-09-05 15:30:24 +05:30
9a317f3ba6
Fixed an issue where backup does not work due to parameter 'preexec_fn' no longer being supported. Fixes #7580
2022-09-02 13:12:58 +05:30
72f819ec67
Ensure that the dump servers functionality works from setup.py. Fixes #7644
2022-08-31 14:28:48 +05:30
e58b9c767b
Port search object dialog to React. Fixes #7622
2022-08-30 17:08:12 +05:30
fe0577be5f
Ensure that the Import/Export server menu option is visible. Fixes #7646
2022-08-26 14:38:50 +05:30
78757564c8
Pin Flask-SocketIO <= v5.2.0. The latest version does not support Werkzeug in production environments. Fixes #7641
2022-08-25 13:21:18 +05:30
5c04f1aa2e
1) Ensure that the autofocus is on the input control for the master password and server password dialogs. Fixes #7633
...
2) Fixed an XSS vulnerability in the Hostname/Address control in the Server Connection dialog.
2022-08-22 15:58:17 +05:30
2de89dcaaf
Fixed an issue where a user could not authenticate using Azure CLI on OSX. Fixes #7632
2022-08-22 14:50:18 +05:30
f2cc897f2f
1. Fixed an issue where copy and pasting a row in the results grid doesn't set the default for boolean. Fixes #7579
...
2. Fixed an issue where the History tab is getting blank and showing an error after some queries are executed. Fixes #7468
3. Fixed query tool view data crash.
2022-08-22 14:33:38 +05:30
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
0f53fc8511
Fixed Spanish translations typo. Fixes #7625
...
Submitted by: Alan Nevot
2022-08-22 10:20:10 +05:30
f873ab5374
1) Ensure that the next button should be disabled if the password did not match for Azure deployment. Fixes #7616
...
2) Fixed an issue where Azure cloud deployment failed. Fixes #7617
2022-08-18 18:39:52 +05:30
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
306b184e11
1. Fixed an issue where Alt-Shift-Q didn't work after creating a new query. Fixes #7575
...
2. Fixed an issue where the Query Editor loses focus when saving a query (Alt+s). Fixes #7521
3. Ensure that an error is thrown if clipboard access is not provided and change the copy rows shortcut. Fixes #7452
2022-08-17 17:23:44 +05:30
da927f4897
1) Autocomplete on keypress should be set to False by default.
...
2) Update the documentation for the locked option in user management.
2022-08-17 14:38:37 +05:30
d45072fae5
Ensure that rename panel should work on view/edit panels. Fixes #7540
2022-08-16 15:31:55 +05:30
ff4c5392d6
Fixed crypt key is missing issue when logout from the pgAdmin. Fixes #7614
2022-08-16 15:29:57 +05:30
2d27a97b8c
Fixed improper parsing of HTTP requests in Pallets Werkzeug v2.1.0 and below (CVE-2022-29361). Fixes #7602
2022-08-16 12:20:01 +05:30
ae5254e8a9
Fixed an issue where the cloud deployment wizard creates the cluster with the
...
High Availability even if that option is not selected. Fixes #7608
2022-08-14 07:14:10 +05:30
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
271b6d91fc
Port User Management dialog to React. Fixes #7345
2022-08-11 10:25:52 +05:30
8b7ce2c276
Port change user password and 2FA dialog to React. Fixes #7568
2022-08-10 18:02:54 +05:30
f96653e9af
Fixed an issue with rendering geometry when selecting a complete column. Fixes #7586
2022-08-09 13:28:09 +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
4c6e7d4f4f
Fixed an issue with the error message being displayed at the right place for Azure deployments. Fixes #7497
2022-08-05 14:11:17 +05:30
53887c32bf
Port change ownership dialog to React. Fixes #7590
2022-08-05 14:11:17 +05:30
060d7ba46b
Update the container base image to Alpine 3.16 (with Python 3.10.5). Fixes #7595
2022-08-04 11:50:56 +01:00
66a1123268
Clarify config settings that may need to be re-defined if SERVER_MODE or DATA_DIR are updated in an included config file.
2022-08-01 16:17:49 +01:00
95312f2d14
1) Ensure that autocomplete does not appear when navigating code using arrow keys. Fixes #7573
...
2) Fixed an issue where autocomplete is not working after clearing the query editor. Fixes #7563
2022-08-01 14:38:32 +05:30
6145dc76fc
Added support to create triggers from existing trigger functions in EPAS. Fixes #7387
2022-07-28 11:16:05 +05:30
81f52a82c8
Port About dialog to React. Fixes #7567
2022-07-28 10:11:40 +05:30
4808df5e95
1) Port the file/storage manager to React. Fixes #7313
...
2) Allow users to delete files/folders from the storage manager. Fixes #4607
3) Allow users to search within the file/storage manager. Fixes #7389
4) Fixed an issue where new folders cannot be created in the save dialog. Fixes #7524
2022-07-19 15:27:47 +05:30
4585597388
Added option to trigger autocomplete on key press in the query tool. Fixes #4488
2022-07-19 11:55:37 +05:30
8f2bda2309
1) Preserve the settings set by the user in the import/export data dialog. Fixes #7428
...
2) Fixed the JSON editor issue of hiding the first record. Fixes #7520
2022-07-18 10:54:03 +05:30
9dde195af4
Ensure that notices should not disappear from the messages tab. Fixes #7512
2022-07-14 18:05:36 +05:30
9468c80a78
Fixed an issue where comments on indexes are not displayed. Fixes #7508
2022-07-14 18:01:31 +05:30
1fecf70123
Ensure that geometry should be shown for all the selected cells. Fixes #7519
2022-07-14 17:38:42 +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
a16e3523bd
Ensure that the splash screen can be moved. Fixes # 7471
2022-07-07 14:11:36 +05:30
50c930f5fa
Make the controls on the Graph Visualiser collapsible and reorganize the controls.
2022-07-07 14:10:10 +05:30
59f5c0d955
Added support for Azure PostgreSQL deployment in server mode. Fixes #7522
2022-07-06 11:43:49 +05:30
8b62cd1f04
Added support for visualise the graph using a Pie chart in the query tool. Fixes #7487
2022-07-05 10:47:17 +05:30
b283c0ba18
Port Master Password dialog to React. Fixes #7342
2022-07-04 12:16:23 +05:30
e59471d87d
Ensure that dashboard graph API is not called after the panel has been closed. Fixes #7518
2022-07-04 12:03:18 +05:30
ed59584fe4
Fixed typo error for Statistics on the table header. Fixes #7523
2022-07-01 14:58:45 +05:30
9c745db413
Enable the start debugging button once execution is completed. Fixes #7517
2022-07-01 12:41:06 +05:30
b92e2fcfc9
Added support for visualizing the graphs using Stacked Line, Bar, and Stacked Bar charts in the query tool. Fixes #7486
2022-06-30 12:38:48 +05:30
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
e46468321d
Hide the tenant id from the scresnshot.
2022-06-29 15:20:29 +05:30
4ad2fbf7bb
Screenshot size updated.
...
refs #7506
2022-06-28 18:59:25 +05:30
64e1e004ae
Disables Azure PostgreSQL cloud deployment in Server mode.
...
refs #7506
2022-06-28 18:48:41 +05:30
659009c1de
Fixed permission denied error when deploying PostgreSQL in Azure using Docker. Fixes #7506
2022-06-27 19:36:20 +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
e95eb14651
Fixed an issue where the connection wasn't being closed when the user switched
...
to a new connection and closed the query tool. Fixes #7461
Fixed the 'Show activity?' issue which was missed during Dashboard porting.
2022-06-23 18:15:16 +05:30
2556771c32
The following issues were fixed in Graph Visualiser:
...
1) Allow the user to set the row limit and chart line width.
2) Zoom should only be applied to X-axis, not both.
3) On clicking the 'Generate' button, the chart should return to its original zoom level.
4) Negative values are not displayed.
refs #7485
2022-06-23 14:52:11 +05:30
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
93bc1f3c57
Added support for visualise the graph using a Line chart in the query tool. Fixes #7485
2022-06-22 17:18:51 +05:30
2adca6bbc4
1) Added mouse over indication for breakpoint area in the Debugger. Fixes #2647
...
2) Added search text option to the Debugger panel. Fixes #2648
3) Port Debugger to React. Fixes #6132
2022-06-15 11:37:54 +05:30
7e1e068370
Added capability to deploy PostgreSQL servers on Microsoft Azure. Fixes #7178
2022-06-15 11:22:42 +05:30
3297546e0a
Added support for passing password using Docker Secret to Docker images. Fixes #7332
2022-06-15 11:07:56 +05:30
3381516013
Upgrade Chartjs to the latest 3.8.0. Fixes #7469
2022-06-13 17:26:17 +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
5c1493bd7e
Fixed an issue where there is no setting to turn off notifications in the Query Tool. Fixes #7423
2022-06-13 14:32:07 +05:30
725726f083
Ensure that the Query Editor should be focused when switching between query tool tabs. Fixes #7441
2022-06-13 14:26:01 +05:30
ea3203f466
Fixed and issue where 'Use spaces' not working in the query tool. Fixes #7443
2022-06-13 11:46:09 +05:30
f615ef30f9
Skip the history records if the JSON info can't be parsed instead of showing 'No history'. Fixes #7468
2022-06-13 11:43:26 +05:30
fd1f71587f
Fixed an issue where the Database restriction is not working. Fixes #7453
2022-06-09 17:03:21 +05:30
20bc17eb6f
Updates documentation for the Traefik v2 container deployment. Fixes #7315
2022-06-02 17:37:57 +05:30
4a17ad312f
Update pgcli to latest release 3.4.1. Fixes #7411
2022-06-02 17:29:58 +05:30
e3225b6565
Fixed the browser tree overlapping nodes and expansion issue. Fixes #6962
2022-05-28 13:26:17 +05:30
b507eb8857
Fixed an issue when switching between connections in the Query Tool dropdown,
...
the background and foreground colors should be changed. Fixes #7374
2022-05-26 15:31:18 +05:30
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
a5ad956088
Ensure that when Authentication buttons are disabled their text is visible in the Dark and High contrast theme. Fixes #7347
2022-05-24 17:12:37 +05:30
1e1e1f027a
Fixed an issue where geometry is not visible when a single cell is selected. Fixes #7394
2022-05-24 17:08:02 +05:30
c5ca45c461
Ensure that null values are accepted for the numeric columns in react-data-grid. Fixes #7405
2022-05-24 15:02:06 +05:30
04fa7dee68
Added missing toggle case keyboard shortcuts to the query tool. Fixes #7399
2022-05-24 14:54:43 +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
6d26d5833f
Added support for multi-cell selection in the query tool grid. Fixes #7380
2022-05-24 11:39:34 +05:30
345cfd7c60
Ensure that unwanted APIs should not be getting called for BigAnimal. Fixes #7368
...
Updated the BigAnimal icon.
2022-05-24 11:34:23 +05:30
4f7bcc2919
Added the ability to detect and warn users about bidirectional Unicode characters. Fixes #7002
2022-05-23 16:04:21 +05:30
50b1ba5c80
Ensure that Dashboard graphs should be refreshed on changing the node from the browser tree. Fixes #7402
2022-05-23 13:26:40 +05:30
11cfea3860
Added the ability to resize columns on dashboard tables. Fixes #7364
2022-05-18 17:49:54 +05:30
5e0dfff42a
Ensure that the editor position should not get changed once it is opened. Fixes #7393
2022-05-18 13:52:09 +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
2d8aff6ca0
Fixed an issue with geometry window zoom mouse scroll not working. Fixes #7373
2022-05-17 18:58:49 +05:30
fbe7b56054
Fixed an issue where a popup for unsaved changes appears when clicking on the
...
open file button for a blank query editor. Fixes #7376
2022-05-17 18:56:15 +05:30
cb05d2924f
Fixed an issue where an error message fills the entire window if the query is long. Fixes #7388
2022-05-17 18:52:19 +05:30
ae0624ae8a
Fixed an issue where Preferences are not saved when the dialog is maximized. Fixes #7383
2022-05-17 11:06:14 +05:30
44f9ba4a57
Port connect server password dialog to React. Fixes #7337
2022-05-16 16:21:14 +05:30
7686c33cbd
Tell Docker to always pull the latest base images when building containers.
...
Fixes #7372
2022-05-13 13:55:41 +01:00
1135821870
Fix Query tool issues:
...
1. Warning/Confirm dialogs should be inside the query tool.
2. The Help button in View/Edit data should open the corresponding help page.
3. Disable execute options when query tool in transaction.
4. Grid not loading more than 10000 rows. react-data-grid issue, PR sent. Use a fork till then.
5. NOTICE messages should not be part of Notifier success popups.
Fixes #7350
2022-05-09 12:39:29 +05:30
c56fe813a5
Use gettext to wrap some strings.
2022-04-29 16:18:28 +05:30
a0c85431dc
Ensure that the Dashboard column sort order should be remembered when the refresh button is clicked. Fixes #7339
2022-04-29 10:26:24 +05:30
7c61017f57
Fixed an issue where the Dashboard Server Activity was showing old queries as active. Fixes #7305
2022-04-28 12:10:42 +05:30
6e2ee9a21f
Port data filter dialog to React. Fixes #7340
2022-04-28 12:04:56 +05:30
5677b1e5f8
Added capability to deploy PostgreSQL servers on EDB BigAnimal. Fixes #7179
2022-04-26 16:41:10 +05:30
3d1a9624c1
Fixed an issue where the drag and drop table in ERD throws an error. Fixes #7333
2022-04-26 16:25:42 +05:30
4f9eaf850d
Updated documentation for the new query tool.
...
refs #6131
2022-04-26 16:18:28 +05:30
faff8d1fb3
Revert "Disable the master password requirement when using alternative authentication sources. Fixes #7012"
...
This reverts commit 0c823455a0
2022-04-22 15:58:06 +05:30
ab8e9a8ea5
Fixed an issue while creating a new database throwing an error that failed to retrieve data. Fixes #7322
2022-04-22 15:42:04 +05:30
f28e8126af
Added support for Azure AD OAUTH2 authentication. Fixes #7325
2022-04-21 12:48:10 +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
58e4f766d8
Fixed sorting issue in the statistics panel. Fixes #7299
2022-04-20 10:32:51 +05:30
74e3f976c1
Improve the Kerberos Documentation. Fixes #6746
2022-04-18 10:03:30 +05:30
131ff4de48
Ensure that sorting should be preserved on refresh for Server Activity. Fixes #7308
2022-04-14 11:11:45 +05:30
0b7bde2775
Fixed an issue where the Browser panel is not completely viewable. Fixes #7026
2022-04-13 17:37:34 +05:30
a91762fb30
Ensure that Columns should always be visible in the import/export dialog. Fixes #7252
2022-04-11 17:25:19 +05:30
0c823455a0
Disable the master password requirement when using alternative authentication sources. Fixes #7012
2022-04-11 13:45:53 +05:30
bf974e73ce
Only set permissions on the storage directory upon creation. Fixes #6958
2022-04-11 13:37:39 +05:30
9dfa5ea77d
Improvement to the Geometry Viewer popup to change the size of the result tables when column names are quite long. Fixes #7168
2022-04-09 12:09:36 +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
efa971edb4
Ensure that after deleting multiple objects from the properties panel, the browser tree should be refreshed. Fixes #7296
2022-04-09 12:09:35 +05:30
0747329575
Don't strip binaries when packaging them in the server RPM as this might break cpython modules.
...
Fixes #7231
2022-04-08 15:27:34 +01:00
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
bf8e569bde
Fixed an issue where the downloaded ERD diagram was 0 bytes. Fixes #7187
2022-04-07 15:19:32 +05:30
38278c179e
Ensure that the master password dialog is popped up if the crypt key is missing. Fixes #6960
2022-04-04 17:00:18 +05:30
0133b750ee
7231 is reactivated, so remove it from the release notes.
2022-04-01 12:13:16 +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
143ae19b8d
Ensure that the correct user should be selected in the new connection dialog. Fixes #7264
2022-03-31 15:51:46 +05:30
b2b14051c3
Fixed an issue where 2FA was not showing the QR code when setting up the Authenticator app. Fixes #7231
2022-03-31 13:59:38 +05:30
e6821a610b
Fixed 'Cannot read properties of undefined' error while creating the table via the ERD tool. Fixes #7275
2022-03-31 11:53:17 +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
0957670d4e
Adds a new LDAP authentication configuration parameter that indicates the case sensitivity of the LDAP schema/server. Fixes #5836
2022-03-29 14:46:57 +05:30
08e00ccebc
Fixed an issue where the newly added table is not visible under the Tables node on refresh. Fixes #7239
2022-03-29 14:40:54 +05:30
63c9aaea35
Correct the typo of RM number.
2022-03-28 17:39:56 +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
7ecc0169df
Correct the release notes
2022-03-28 16:29:31 +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
04d0ab4adf
Ensure that pgAdmin4 should work with latest jinja2 version. Fixes #7269
2022-03-25 11:52:11 +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
e7dc6df723
Support running the container under OpenShift with alternate UIDs. Fixes #7257
2022-03-21 11:19:33 +00:00
74e794b416
Port preferences dialog to React. Fixes #7149
2022-03-21 13:29:26 +05:30
3299b0c1b0
Fixed an issue where foreign key is not removed even if the referred table is removed in ERD. Fixes #7238
2022-03-17 17:02:00 +05:30
08880ebd2e
Fix indentation
2022-03-15 14:54:31 +00:00
ed90045deb
Move the cloud deployment docs to a more appropriate place.
2022-03-15 14:54:22 +00:00
609c41154f
Wording and formatting tweaks.
2022-03-15 14:52:34 +00:00
7b6469bd35
Fixed an issue where the error is shown on logout when the authentication source is oauth2. Fixes #7059
2022-03-15 16:38:54 +05:30
dfb66b427c
Add CVE number.
2022-03-14 15:26:54 +00:00
dccd4f0bba
Ensure that upload paths are children of the storage directory. Fixes #7233
2022-03-11 18:20:16 +05:30
0f5d4cd7b7
Fixed an issue where pgAdmin 4 took ~75 seconds to display the 'Starting pgAdmin' text on the splash screen. Fixes #7230
2022-03-10 19:02:11 +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
9ed2506062
Fixed a schema diff issue where string separator '_$PGADMIN$_' is visible for identical user mappings. Fixes #7228
2022-03-10 14:40:38 +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
24c0816042
Fixed an issue where the parent partition table was not displayed during autocomplete. Fixes #7105
2022-03-07 14:06:40 +05:30
f9707a8bf5
Allow users to scroll and enter input when there is a validation error. Fixes #7172
2022-03-04 17:25:36 +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
5ce3c4a5c8
Ensure that Flask-Security-Too is using the latest version. Fixes #7202
2022-03-02 10:56:02 +05:30
0cd67b15cb
Update the release date in the release notes. Fixes #7191
2022-02-19 10:29:02 +05:30
aca97d9f57
Fixed an issue where pgadmin cannot connect to LDAP when STARTTLS is required before bind. Fixes #6991
2022-02-16 18:01:39 +05:30
b539637426
Fixed an issue where a warning is flashed every time for an email address when
...
authentication sources are internal and ldap. Fixes #6999
2022-02-16 13:34:24 +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
1cdbb9a643
Fixed an issue where the User Management dialog is not opening. Fixes #7173
2022-02-14 15:17:48 +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
19beb62f81
Added support to open SQL help, Dialog help, and online help in an external web browser. Fixes #7139
2022-02-04 16:05:30 +05:30
28be10a1b5
Ensure that layout should not be reset if a query tool is opened and pgAdmin is restaretd. Fixes #7154
2022-02-04 15:20:55 +05:30
444a364a8d
Fixed an issue when uploading a CSV throwing an error in the Desktop mode. Fixes #7150
2022-02-04 15:10:13 +05:30
4a195e7ef6
Fixed value error in the restore dialog. Fixes #7151
2022-02-03 17:44:54 +05:30
b4b658c59d
Ensure that cursor should be focused on the first options of the Utility dialogs. Fixes #7110
2022-02-02 14:48:35 +05:30
4d727015fd
Fixed an issue where the query tool is displaying an incorrect label. Fixes #7136
2022-02-02 14:45:31 +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
c38bf04f51
Correct documentation for 'Add named restore point'. Fixes #7086
2022-01-31 20:24:15 +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
37d82d457c
Fixed an issue where the F2 Function key removes browser panel contents. Fixes #7126
2022-01-28 10:55:23 +05:30
8fd3ddc4ae
Make the size blank for all the directories in the file select dialog. Fixes #7109
2022-01-27 12:11:09 +05:30
deab1bfaba
Ensure that JSON files should be downloaded properly from the storage manager. Fixes #7118
2022-01-25 20:17:50 +05:30
04729f63b8
Fixed an issue where restore generates incorrect options for the schema. Fixes #7123
2022-01-25 20:14:10 +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
c65f60771a
Enforce the minimum Windows version that the installer will run on. Fixes #7135
2022-01-21 12:59:01 +00:00
c983aae881
Port Import/Export dialog to React. Fixes #7017 .
2022-01-21 11:48:52 +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
40fa1aff6b
Added flag in runtime to disable GPU hardware acceleration. Fixes #6916
2022-01-13 13:01:40 +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
374c5e952f
Fixed an issue where the Browser tree gets disappears when scrolling sequences. Fixes #7100
2022-01-11 18:03:11 +05:30
ad862f4084
Port Maintenance dialog to React. Fixes #7019
2022-01-07 12:07:49 +05:30
65a6c18263
Updated screenshots and descriptions for Backup and Restore dialog.
2022-01-07 11:35:40 +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
8b13f158ab
Fixed review comments for Import/Export Servers.
...
refs #4803
2022-01-05 14:02:49 +05:30
920c27bb31
Add trademark notice.
2022-01-04 15:33:10 +00:00
2786f7ac5a
Update copyright notices for 2022
2022-01-04 13:54:25 +05:30
9dd957a2aa
Added support to import/export server groups and servers from GUI. Fixes #4803
2022-01-04 12:27:17 +05:30
a4ef5ea48b
Fixed an issue where SubPlans may overlap other nodes & make them inaccessible in Graphical EXPLAIN View.
...
Patch sent by: Robert Frunzke
Fixes #7093
2021-12-31 14:49:42 +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
603d91be0e
Port Restore dialog to React. Fixes #7018
2021-12-28 13:45:59 +05:30
bae8a2bd5d
Fixed an issue where Explain Analyze shows negative exclusive time. Fixes #7003
2021-12-24 16:11:58 +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
9754b0fe14
Fixed an issue where Columns with default value not showing when adding a new row. Fixes #7034
2021-12-17 10:48:24 +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
6875d00e44
Fixed an issue where confirmation pop-up is hidden behind Reassign/Drop Owned Dialog. Fixes #7071
2021-12-14 16:42:06 +05:30
83e646c7d4
Reverting patch for #7003 , showing Nan in time fields.
2021-12-14 16:30:59 +05:30
701e6f86f5
Ensure that statue message should not hide the last line of messages when running a long query. Fixes #7020
2021-12-13 13:10:56 +05:30
da5545ff57
Added support to disable the auto-discovery of the database servers. Fixes #7039
2021-12-13 13:07:37 +05:30
bd545fd5b2
1) Fixed schema diff owner related issue. Fixes #6877
...
2) Fixed schema diff related some issues. Fixes #6957
2021-12-11 22:10:28 +05:30
837925a47c
Fixed typos in the Documentation.
2021-12-10 19:46:45 +05:30
9ec8d05a64
1) Ensure that the Owner should not be disabled while creating the procedure. Fixes #7064
...
2) Fixed an issue where Explain Analyze shows negative exclusive time. Fixes #7003
2021-12-09 16:59:43 +05:30
91a288c2bb
Correct the SQL definition for function/procedure with the Atomic keyword in PG14. Fixes #7029
2021-12-08 12:31:59 +05:30
fd53e4f5f9
Replace Alertify alert and confirm with React-based model dialog. Fixes #7053
2021-12-07 18:52:40 +05:30
48dc4bacc4
Fixed Kerberos authentication issue which is broken due to 2FA.
...
refs #6543
2021-12-06 20:14:39 +05:30
950809ee55
Increase the width of the scrollbars. Fixes #6978
2021-12-06 20:11:30 +05:30
c7a49490a2
Fixed an issue where tooltip data are not displaying on downloaded graphical explain plan. Fixes #6840
2021-12-06 20:07:11 +05:30
9c0c046a38
Fixed unhashable type issue while opening the about dialog. Fixes #7048
2021-12-03 12:31:59 +05:30
36c9eb3dfd
Added support for Two-factor authentication for improving security. Fixes #6543
2021-12-02 16:47:18 +05:30
e30cbe2579
Fixed some accessibility issues:
...
1) Focus is not visible while navigating through top navbar menu items(File, Object, Tools)
2) In preference dialog wherever access key is used for a shortcut declaration, unable to get out of the textbox.
3) Focus is not visible for the links on the dashboard
Fixes #7046
2021-12-02 16:24:55 +05:30
c6424e3897
Replaced alertifyjs notifiers with React-based notistack. Fixes #7004
2021-12-02 16:05:52 +05:30
6b613fdf36
Fixed an issue where SQLite database definition is wrong because the USER_ID FK
...
references the table user_old which is not available.
Fixes #7031
2021-12-01 17:24:41 +05:30
9d804d2857
Update the dropzone version to 5.9.3 and Flask-SQLAlchemy to 2.5.*. Fixes #7044
2021-12-01 17:23:46 +05:30
b14285cdbf
Remove mention of 9.6 utilities.
2021-11-30 11:58:02 +00:00
976faa5e2f
Add "section" to the Debian package control files. Fixes #7040
2021-11-29 13:47:11 +00:00
2c02e6fc23
Ensure that the user should be allowed to set the schema of an extension while creating it. Fixes #6963
2021-11-29 15:27:44 +05:30
fbd10ef4b6
Fixed an issue where reverse engineering SQL is wrong for Aggregate. Fixes #7024
2021-11-29 12:00:38 +05:30
abe5303448
Fixed an issue where the error is thrown while creating a new server using
...
Add New Server from the dashboard while tree item is not selected.
Fixes #7015
2021-11-28 13:32:30 +05:30
bef692d431
Fixed an issue where On-demand rows throw an error when any row cell is edited
...
and saved it then scroll to get more rows.
Fixes #7005
2021-11-28 13:26:40 +05:30
7c18ddfe7d
Include GSSAPI support in the PostgreSQL libraries and utilities on macOS. Refs #6872
2021-11-26 15:05:40 +00:00
d644b4f94e
1) Replace Flask-BabelEx with Flask-Babel. Fixes #6088
...
2) Upgrade Flask to version 2. Fixes #7010
2021-11-24 17:22:57 +05:30
849a1b1a89
Fix an RPM build issue that could lead to a conflict with python3 at installation. Fixes #7013 .
2021-11-23 09:16:47 +00:00
b0abc4048e
Fix an RPM build issue that could lead to a conflict with python3 at installation. Fixes #7013 .
2021-11-22 11:33:20 +00:00
a55ac2fdd1
Fix an RPM build issue that could lead to a conflict with python3 at installation. Fixes #7103 .
2021-11-22 11:32:04 +00:00
3afeb8ca46
Port Backup Global, Backup Server, and Backup object dialog in React. Fixes #6984
2021-11-22 11:20:44 +05:30
a701e8c766
Fixed an issue where the Change Password menu option is missing for internal
...
authentication source when more than one authentication source is defined.
Fixes #6989
2021-11-22 11:02:26 +05:30
cc91e5da94
Fixed an issue where properties of the database should not be visible after removing the database.
...
Fixes #6964
2021-11-18 12:36:39 +05:30
5b99646798
Ensure that Python 3.10 and the latest eventlet dependency should not break the application. Fixes #7006
2021-11-18 12:29:24 +05:30
a5b79564ff
Fixed an issue where the user can't debug function with timestamp parameter. Fixes #6986
2021-11-18 12:25:21 +05:30
3d5d507f4b
Fixed an issue where referenced table drop-down should be disabled in
...
foreign key -> columns after one row is added.
Fixes #6906
2021-11-18 12:22:14 +05:30
33cc2a7514
Fixed an issue where SQL for index shows the same column multiple times. Fixes #6981
2021-11-15 16:31:40 +05:30
0ca7dbccf6
Ensure that the Binary path for PG14 should be visible in the preferences. Fixes #6972
2021-11-15 12:44:33 +05:30
e67bad3461
Ensure that the user should be able to navigate browser tree objects using arrow keys from keyboard. Fixes #6896
2021-11-15 11:17:42 +05:30
e2e5a8208c
1) Fixed an issue where JSON editor preview colours have inappropriate contrast in dark mode. Fixes #6944
...
2) Fixed JSON Editor scrolling issue in code mode. Fixes #6945
2021-11-15 10:58:17 +05:30
ca4d5d0ca4
Added operators and aggregates in search objects. Fixes #6974
2021-11-12 17:45:08 +05:30
8bf178b0a3
Reset the layout if pgAdmin4 detects the layout is in an inconsistent state. Fixes #6988
2021-11-12 11:50:37 +05:30
d4bf7164f9
Ensure that inherit table icon should be visible properly in the tree view. Fixes #6845
2021-11-11 12:55:38 +05:30
7468ca36ae
Fixed SQL syntax error if select "Custom auto-vacuum" option and not set Autovacuum option to Yes or No. Fixes #6925
2021-11-11 12:36:19 +05:30
572b5a126a
Ensure that internal authentication when combined with other authentication providers, the order of internal source should not matter while picking up the provider. Fixes #6832
2021-11-11 12:29:30 +05:30
36e5708464
Correct the release notes.
2021-11-10 15:44:03 +05:30
d4697e8f1c
Ensure that users should be able to modify the REMOTE_USER environment
...
variable as per their environment by introducing the new config parameter
WEBSERVER_REMOTE_USER.
Fixes #6953
2021-11-10 15:38:41 +05:30
aff84103d9
Fixed an issue where database nodes are not getting loaded behind a reverse
...
proxy with SSL. Fixes #6905
2021-11-10 11:47:40 +05:30
a61a9e5b8f
Fixed an issue where older server group name displayed in the confirmation
...
pop-up when the user removes server group. Fixes #6939
2021-11-10 11:17:51 +05:30
1ed4d0f95e
Fixed an issue where textarea should be allowed to resize and have more than 255 chars. Fixes #6976
2021-11-07 10:51:54 +05:30
31849ea95f
Ensure that changing themes should work on Windows when system high contrast
...
mode is enabled. Fixes #6954
2021-11-07 10:46:49 +05:30
fa8b3edda5
Fixed an issue where user details are not shown when the non-admin user tries
...
to connect to the shared server. Fixes #6940
2021-10-29 16:26:11 +05:30
f71e2e8040
Fixed an issue where pgAdmin is not opening properly. Fixes #6809
2021-10-29 16:17:36 +05:30
39992a817d
Added support of Aggregate and Operator node in view-only mode. Fixes #3834
2021-10-29 16:14:33 +05:30
35b1e1d0d2
Fixed pgAdmin freezing issue by providing the error message for the operation
...
that can't perform due to lock on the particular table. Fixes #5427
2021-10-27 10:51:52 +05:30
711ea3bfa1
Fixed an issue where properties panel is not updated when any object is added from the browser tree. Fixes #6859
2021-10-27 10:31:49 +05:30
8eb6f8061d
Ensure that dialog should be opened when clicking on Reassign/Drop owned menu. Fixes #6949
2021-10-25 11:47:28 +05:30
c7cd57db91
Ensure that columns should be merged if the newly added column is present in the parent table. Fixes #6780
2021-10-21 10:59:52 +05:30
27b6e07e21
Fixed object delete issue from the properties tab for the collection nodes. Fixes #6858
2021-10-19 17:21:46 +05:30
a2f5e6ad8f
Fixed an issue where the wrong SQL is generated when deleting and renaming table columns together. Fixes #6935
2021-10-19 17:13:12 +05:30
9de1489322
Ensure that only the table node should be allowed to drop on the ERD tool. Fixes #6929
2021-10-19 12:01:43 +05:30
9e3165c0ff
1) Ensure that the master password should be prompt when MASTER_PASSWORD_REQUIRED
...
is set to True and AUTHENTICATION_SOURCES is the webserver. Fixes #6928
2) Fixed an issue where the existing server group is disappeared on rename it. Fixes #6930
2021-10-19 11:56:44 +05:30
b8072bd630
Fixed an issue where the blank string is stored instead of NULL in the server table of SQLite database. Fixes #6915
2021-10-18 15:50:42 +05:30
a908ef7c61
Fixed browser tree sort order regression issue. Fixes #6912
2021-10-16 12:54:44 +05:30
5b411caabe
Fixed an issue where each click to refresh the collection node, the number of objects decreasing by tens or more. Fixes #6908
2021-10-16 12:50:51 +05:30
7f3c3fa6f9
Added support to allow tables to be dragged to ERD Tool. Fixes #6241
2021-10-16 12:43:39 +05:30
476d7c5fc9
Fixed background colour issue in the browser tree. Fixes #6890
2021-10-16 12:40:57 +05:30
1377244e52
Fixed the issue of editing triggers for advanced servers. Fixes #6802
2021-10-16 12:36:25 +05:30
173cb60691
Added support to enable/disable rules. Fixes #6794
2021-10-14 11:44:03 +05:30
2aac87569b
Fixed an issue where the users are unable to load the databases behind an HTTP reverse proxy. Fixes #6905
2021-10-14 11:35:11 +05:30
fa21e25cb2
Ensure that the Dashboard should get updated after connecting to the server. Fixes #6876
2021-10-14 11:24:43 +05:30
8a21d9b500
Fixed some typos in the documentation and comments.
2021-10-14 11:13:16 +05:30
8b7b63868f
Added support for composite foreign keys in the ERD tool. Fixes #6891
2021-10-13 14:28:55 +05:30
6c692df118
Changed the label 'Inherits Tables?' to 'Is inherited?' as it misleading in the properties panel. Fixes #6776
2021-10-13 11:41:21 +05:30
9ace229152
Fixed an issue where exclusion constraint cannot be created from table dialog
...
if the access method name is changed once. Fixes #6900
2021-10-13 11:35:19 +05:30
5b9383c880
Fixed an issue where the user is unable to create an index with concurrently keyword. Fixes #6790
2021-10-12 18:19:40 +05:30
9fd9ca2673
Added support for indent guides in the browser tree. Fixes #4596
2021-10-12 17:53:38 +05:30
72e5d4b426
Updated yarn.lock file
2021-10-12 16:47:47 +05:30
ac6c6fbf97
Fixed an issue where the browser tree doesn't show all contents on changing resolution. Fixes #6881
2021-10-12 15:02:46 +05:30
a726635290
1) Added support for authentication via the web server (REMOTE_USER). Fixes #6657
...
2) Fixed OAuth2 integration redirect issue. Fixes #6719
Initial patch for 6657 sent by: Tom Schreiber
2021-10-12 14:52:30 +05:30
ca40add29b
Ensure that columns should be displayed in the order of creation instead of alphabetical order in the browser tree. Fixes #6882
2021-10-12 14:37:06 +05:30
2ced82c7b3
Ensure that query highlighting color in the query tool should be less intensive. Fixes #6754
2021-10-12 14:30:29 +05:30
a92c1b43a2
1) Added support for advanced table fields like the foreign key, primary key in the ERD tool. Fixes #6081
...
2) Added index creation when generating SQL in the ERD tool. Fixes #6529
2021-10-11 17:42:14 +05:30
9796f50362
Fixed an issue where the tree is not scrolling to the object selected from the search result. Fixes #6828
2021-10-07 17:23:21 +05:30
d65930a8a6
Remove an extra blank line at the start of the SQL for function, procedure, and trigger function. Fixes #6797
2021-10-07 17:11:48 +05:30
5467b5e085
Added missing description of the RM.
2021-10-06 17:05:28 +05:30
ca32828281
Fixed an issue where Execute button of the query tool gets disabled once we change anything in the data grid. Fixes #6798
2021-10-06 16:59:38 +05:30
7787def660
The nodes index, RLS policy, rules, triggers are failing to save for partitions.
...
refs #6868
2021-10-06 16:51:46 +05:30
1ed6272e7b
Ensure that SQL help should work for EPAS servers. Fixes #6834
2021-10-06 14:54:01 +05:30
7d5668141d
Updated PostgreSQL version from 13 to 14, to get the latest utility files.
2021-10-04 16:12:45 +05:30
7d07770244
Reverting 'Two-factor authentication' support as it cause OSX and docker build failures.
...
This reverts commit 787a441343
2021-09-29 13:24:18 +05:30
787a441343
Added support for Two-factor authentication for improving security. Fixes #6543
2021-09-28 17:47:00 +05:30
1569be7866
Fixed keyerror issue in schema diff for 'attnum' and 'edit_types' parameter. Fixes #6755
2021-09-28 15:03:28 +05:30
483e2ca8d0
Port browser tree to React. Fixes #6129
2021-09-27 16:44:26 +05:30
31339737a6
Updated screenshots for server group and server dialog.
2021-09-27 12:29:39 +05:30
9d2f3b5ee9
Ensure that RLS names should not be editable in the collection node of properties tab. Fixes #6759
2021-09-27 10:57:08 +05:30
294bf27985
Updated all the screenshots and documentation for the nodes.
2021-09-26 22:03:11 +05:30
3d8754cd3c
Updated some screenshots and documentation for the nodes.
2021-09-24 21:01:56 +05:30
b9bc628189
1. Placeholder should be inside the controlProps. Change the placeholder from 'Select...' to 'Select an item...'
...
2. Updated grant wizard screenshot and documentation.
3. Remove '(Beta)' from ERD Tool and PSQL Tool.
2021-09-23 16:17:39 +05:30
b60bd73f88
Fixed an issue where Refresh view options are not working for materialized view. Fixes #6736 .
2021-09-21 16:48:10 +05:30
7aa213a5ce
1) Port Grant Wizard to react. Fixes #6687
...
2) Fixed an issue where grant wizard is unresponsive if the database size is huge. Fixes #2097
2021-09-20 13:02:41 +05:30
44e770aa0b
Updated query error row selection color as per dark theme style guide. Fixes #6723
2021-09-17 21:04:49 +05:30
99c99a9ce9
Ensure that in the Query History tab, query details should be scrollable. Fixes #3827
2021-09-17 21:01:24 +05:30
f1c04096e5
Fixed an issue where the last message is not visible in the Debugger. Fixes #6713
2021-09-17 20:44:57 +05:30
460c66ab3f
Fixed an issue where the drop cascade button enables for Databases. Fixes #6724
2021-09-10 18:27:16 +05:30
4a0a4941af
Correct the message in the release note.
2021-09-09 16:30:31 +05:30
dbf78bf214
Added support to create the Partitioned table should be created using COLLATE and opclass. Fixes #2546
2021-09-09 16:26:23 +05:30
55e7e481d4
Fixed an issue where collapse and expand arrows mismatch in case of nested IF. Fixes #6712
2021-09-09 16:04:59 +05:30
103393fee6
Update release note for 6.0
2021-09-09 13:24:55 +05:30
d1e823bf39
Informative error should be shown if Oauth2 profile does not have email id registered. Fixes #6590
2021-09-09 12:44:37 +05:30
764677431f
Added React framework for the properties dialog and port Server Group, Server, and Database dialogs.
...
Following changes done for the framework:
- Framework for creating React based dynamic form view out of a pre-defined UI schema. Previously, it was based on Backform/Backbone.
- The new framework and components will use MaterialUI as the base. Previously, Bootstrap/Backform/jQuery components were used.
- The new code uses JSS instead of CSS since material UI and most modern React libraries also use JSS. In the future, this will allow us to change the theme in real-time without refresh.
- 90% code covered by 80-85 new jasmine test cases.
- Server group node UI Schema migration to new, with schema test cases.
- Server node UI Schema migration to new, with schema test cases.
- Database node UI Schema migration to new, with schema test cases.
- Few other UI changes.
Fixes #6130
2021-09-09 12:20:59 +05:30
fcfe7fae54
Fixed an issue where whitespace in function bodies was not applied while generating the script using Schema Diff. Fixes #6620
2021-09-02 14:51:50 +05:30
a2c1aa2c4c
Make closing tabs to be smarter by focusing on the appropriate tab when the user closed a tab. Fixes #6625
2021-09-02 11:36:10 +05:30
a9ff5c799e
Ensure that pgAdmin should not fail at login due to a special character in the hostname. Fixes #6704
2021-09-01 15:36:37 +05:30
d13d2c6dda
Introduced OAUTH2_SCOPE variable for the Oauth2 scope configuration. Fixes #6627
2021-08-31 14:36:14 +05:30
7deda52bd9
Fixed an issue where multiple query tool tabs getting closed for the single close event. Fixes #6710
2021-08-30 16:59:46 +05:30
22f20a38ec
Fixed an issue where the user can not paste the updated table header in safari 12 and 13 browsers. Fixes #4815
2021-08-30 14:46:42 +05:30
b764046587
Fixed an issue where privileges were revoked using SQL query on objects like tables that do not correctly show in SQL tab. Fixes #4567
2021-08-27 12:54:14 +05:30
d38f520805
Added support for the truncate table with restart identity. Fixes #2538
2021-08-27 12:41:29 +05:30
51d73b1672
Fixed errors related to HTML tags shown in the error message for JSON editor. Fixes #6668
2021-08-26 14:54:51 +05:30
092f830c3c
Fixed blank screen issue on windows and also made changes to use NWjs manifest for remembering window size. Fixes #6419
2021-08-26 11:19:15 +05:30
b30a42ab9e
Ensure that deleting a database should not automatically connect to the next database. Fixes #6685
2021-08-25 17:01:48 +05:30
737bc6a965
Ensure that the lock panel should not be blocked for larger records. Fixes #6570
2021-08-25 11:05:28 +05:30
e39838455e
Ensure that trigger function SQL should have 'create or replace function' instead of 'create function' only. Fixes #5849
2021-08-24 18:23:32 +05:30
94b40775a1
Allow the referenced table to be the same as the local table in one to many relationship for ERD Tool. Fixes #6495
2021-08-24 18:19:03 +05:30
7efef73ff7
Added database and server information on the Maintenance process watcher dialog. Fixes #4629
2021-08-24 17:10:16 +05:30
8bf1c96065
Fixed the export image issue where relation lines are over the nodes. Fixes #6531
2021-08-24 17:05:23 +05:30
c7fd1ae535
Enables pgAdmin to retrieve user permissions in case of nested roles which helps to terminate the session for AWS RDS. Fixes #6641
2021-08-24 17:01:06 +05:30
008a458fe9
Fixed width limitation issue in PSQL tool window. Fixes #6544
2021-08-23 16:23:30 +05:30
fbc6c30b62
Set PSQLRC and PSQL_HISTORY env vars to apt. user storage path in the server mode. Fixes #6691
2021-08-23 16:19:01 +05:30
c64eb3507c
Make code folding case insensitive in the code mirror. Fixes #4264
2021-08-23 16:16:20 +05:30
1b33c52eac
Fixed the JSON editor issue of hiding the first record. Fixes #6684
2021-08-20 13:47:31 +05:30
accc941818
Fixed no attribute '_asdict' error when connecting the database server. Fixes #6663
2021-08-20 13:47:31 +05:30
3e4b5fd0d7
Renamed 'Auto rollback?' to 'Auto rollback on error?'. Fixes #6682
2021-08-19 15:30:58 +05:30
3f3416c13e
Fixed UnboundLocalError where local variable 'user_id' referenced before assignment. Fixes #6671
2021-08-19 15:06:16 +05:30
7798584e1c
Fixed an issue where columns with sequences get altered unnecessarily with a schema diff tool. Fixes #6564
2021-08-18 19:33:01 +05:30
d59063d79f
Correct the description in the release note.
2021-08-17 18:15:35 +05:30
a6edfb498f
Partially fixes the data output panel display issue. Fixes #6572
2021-08-17 17:22:08 +05:30
ab04b30726
1. Unverified email id is getting locked.
...
2. Admin should be able to lock the user, as currently it only unlocks it via
user management dialog.
3. There were some indefinite login page loading issues when trying to log in
with invalid password, where it should redirect to the login page again instead.
refs #6337 (Initial patch by Khushboo Vashi)
2021-08-09 21:04:49 +05:30
7483ddf2b2
Added support to copy SQL from main window to query tool. Fixes #4904
2021-08-09 14:29:31 +05:30
78b041465e
Fixed an issue where even if the user is locked, he can reset the password and can login into pgAdmin. Fixes #6664
2021-08-09 14:24:26 +05:30
703478c13d
Fixed an issue where the titles in query tabs are different. Fixes #6618
2021-08-06 19:09:39 +05:30
025c98ced8
1) Flash warning message of N no of attempts left for the unsuccessful login attempt.
...
2) Updated some strings in the Preferences for the "Maximum column width" option.
2021-08-03 17:06:06 +05:30
8e214ca8fb
Added support for formatted JSON viewer/editor when interacting with data in a JSON column. Fixes #5198
2021-08-03 11:36:45 +05:30
03477d407e
Fixed dashboard server activity issue when active_since parameter is None. Fixes #6650
2021-07-29 11:49:27 +05:30
2dd88e5a4e
Ensure that all the required options should be loaded when the Range data type
...
is selected while creating a custom data type.
Fixes #6643
2021-07-29 10:43:27 +05:30
2452d90300
Fixed incorrect tablespace options in the drop-down for move objects dialog. Fixes #6586
2021-07-27 17:28:38 +05:30
508f97b08e
Rename the "Resize by data?" to "Columns sized by" and disabled the 'Maximum column width'
...
button if 'Columns sized by' is set to 'Column data'. Fixes #6622
2021-07-27 15:17:06 +05:30
3f67f512ec
Fixed incorrect binary path issue when the user deletes the binary path from the preferences. Fixes #6619
2021-07-26 11:49:48 +05:30
d95a6f2af7
Fixed an issue where paste is not working through Right-Click option on PSQL. Fixes #6574
2021-07-23 12:41:48 +05:30
a3d3c74e67
Ensure that the login account should be locked after N number of attempts. N is configurable using the 'MAX_LOGIN_ATTEMPTS' parameter. Fixes #6337
2021-07-22 12:24:43 +05:30
b2205fc6e1
Fixed an issue in the search object when searching in 'all types' or 'subscription' if the user doesn't have access to the subscription. Fixes #6448
2021-07-19 14:11:10 +05:30
b0727cc532
Fixed CSRF errors for stale sessions by increasing the session expiration time for desktop mode. Fixes #6369
2021-07-15 17:49:42 +05:30
9e8af67202
Fixed TypeError 'NoneType' object is not sub scriptable. Fixes #6580
2021-07-15 17:46:31 +05:30
8edd5946e5
1) Modified some labels and controls.
...
2) Fixed issue where the same user is showing in SQL query.
3) Added SQL tab in the dialog.
refs #3893
2021-07-07 10:44:02 +05:30
48ca83f31d
Added support for OAuth 2 authentication. Fixes #5940
...
Initial patch sent by: Florian Sabonchi
2021-07-06 13:22:58 +05:30
ef67409d61
Highlighted long running queries on the dashboards. Fixes #1975
2021-07-01 18:10:55 +05:30
d90472014d
Remove leading whitespace and replace it with '[...] ' in the Query Tool data grid so cells don't look empty.
...
Fixes #6427
2021-07-01 09:17:35 +01:00
b98e881d84
Disable email deliverability check that was introduced in flask-security-too by default to maintain backwards compatibility.
...
Fixes #6550
2021-06-30 10:46:32 +01:00
5fe52b9cfe
Added support for Reassign/Drop Owned for login roles. Fixes #3893
2021-06-28 18:55:52 +05:30
5c6d00d545
Fixed directory selection issue with the folder dialog. Fixes #6536
2021-06-28 18:55:52 +05:30
6429a5b31a
Clarify when container config envvars may be ignored.
2021-06-28 09:48:24 +01:00
e68c8305a2
Added option to provide maximum width of the column when 'Resize by data?’ option in the preferences is set to True. Fixes #6559
2021-06-28 11:51:21 +05:30
e095d382b3
Fixed an issue where incorrect column name listed in the properties of Index. Fixes #6557
2021-06-27 19:00:16 +05:30
6645625e6b
Fixed copy/paste issues for PSQL tool terminal. Fixes #6547 .
2021-06-24 20:00:52 +05:30
a53be65ab0
Fixed Czech translation string for 'Login' keyword. Fixes #6555
...
Patch sent by: Waclaw
2021-06-24 11:19:26 +05:30
313224e6f5
Ensure that Data Output panel can be snapped back after it is detached. Fixes #4189
2021-06-23 15:06:06 +05:30
2adb29ffc0
Fixed an issue where the New Connection Drop Down has lost default maintenance database, auto-select, and tab-through functionality. Fixes #6505
2021-06-23 12:48:17 +05:30
80ccd62d38
Fixed an issue in the search object when searching in 'all types' or 'subscription' if the user doesn't have access to the subscription. Fixes #6448
2021-06-23 12:39:55 +05:30
b81ff45d34
Fixed replace keyboard shortcut issue in the query tool on the normal keyboard layout. Fixes #6388
2021-06-23 12:34:01 +05:30
81b78dd2b2
Do not block the query editor window when running a query. Fixes #3920
2021-06-23 12:22:24 +05:30
e2302a6c9b
Ensure that setting 'Open in new browser tab' should be visible, it should not be based on the value of 'ENABLE_PSQL'. Fixes #6541
2021-06-23 11:59:56 +05:30
0b52ef6eb0
Fixed an issue where detaching the query editor panel gives a blank white panel. Fixes #6398
2021-06-23 11:49:40 +05:30
a533620684
Fixed an issue where Execute/Refresh button should not be disabled when we run the empty query. Fixes #6489
2021-06-23 11:49:40 +05:30
09d8d0f362
Fix path on windows. Fixes #6558
2021-06-23 07:04:59 +01:00
082c9707c0
Fixed documentation issue 'Definition list ends without a blank line; unexpected unindent.'
2021-06-15 16:45:16 +05:30
15798ee168
Updated DEFAULT_BINARY_PATHS for container.
2021-06-15 16:08:15 +05:30
e37b7eae3f
Cleanup psql docs.
2021-06-15 11:09:52 +01:00
2549688bdf
1) Disable the PSQL feature entirely in server mode by default.
...
2) Remove the code that attempts to filter out commands.
refs #2341
2021-06-14 20:53:11 +05:30
71526ac79f
Ensure that the calendar control should be disabled in the properties panel for Role. Fixes #6469 .
2021-06-14 16:59:04 +05:30
09693d14d1
Added check if the Windows version is not supporting the ConPty or WinPty disable the PSQL for that version.
...
refs #2341
2021-06-14 11:47:40 +05:30
4a3a5174b2
Disable browser password saving in the runtime. Fixes #6473
2021-06-11 15:10:38 +01:00
e3190b86ab
Fixed an issue where a decimal number is appended for character varying fields while downloading the data in CSV format. Fixes #6520
2021-06-11 19:29:20 +05:30
460fb7ec29
Fixed an issue where pgAdmin does not open after password reset in server mode. Fixes #6513
2021-06-10 22:55:31 +05:30
b2042f48cd
Added RESQL/MSQL test cases for Table and its child nodes. Fixes #4622
2021-06-09 18:16:50 +05:30
d276f37e87
Support non-admin installation on Windows. Fixes #6524
2021-06-09 13:32:48 +01:00
7c88ee7cff
Added a mechanism to detect a corrupt/broken config database file. Fixes #6460
2021-06-08 19:41:47 +05:30
93ddc4a5ba
Ensure that the user should be able to add members in Login/Role group while creating it. Fixes #6466
2021-06-08 19:33:03 +05:30
e1067ffe67
Ensure that the Query Tool connection string should not be changed as per the 'Query Tool tab title'. Fixes #6404
2021-06-07 22:07:51 +05:30
5b12483416
Fixed an issue where the Foreground Color property of server dialog does not work. Fixes #6482
2021-06-07 21:09:04 +05:30
065a3aa2f5
Updated Flask-Security-Too to the latest v4. Fixes #6225
2021-06-06 13:58:06 +05:30
4bc4ca1ba9
1) Added browse button to select the binary path in the Preferences. Fixes #1561
...
2) Added support to set the binary path for the different database server versions. Fixes #5370
2021-06-04 17:55:35 +05:30
ac8e8961ce
Added Grant Wizard option under Package node. Fixes #1591
2021-06-04 12:47:37 +05:30
2c51925638
Added OS, Browser, Configuration details in the About dialog. Fixes #6231
2021-06-01 20:18:24 +05:30
9ac08c263b
Fixed duplicate SQL issue for tables with more than one partition. Fixes #6478
2021-05-31 12:46:07 +05:30
658a2de619
Fixed the issue of renaming the database by another user. Fixes #4203
2021-05-31 12:41:09 +05:30
faa49687be
Added support to rotate the pgadmin log file on the basis of Size and Age. Fixes #6395
2021-05-25 20:18:46 +05:30
3ddf941cd7
Added support to launch PSQL for the connected database server. Fixes #2341
2021-05-25 20:12:57 +05:30
37dece2cd8
Added window maximize/restore functionality for properties dialog. Fixes #4064
2021-05-24 22:08:23 +05:30
4676d7ef02
Fixed an issue where the Help message not displaying correctly on Login/Group role. Fixes #6414
2021-05-17 13:08:38 +05:30
64e42bebe2
Update the correct redmine numbers, wrongly added in the last commit.
2021-05-14 12:42:06 +05:30
7275ce906e
1) Fixed an issue where the user is not warned if Kerberos ticket expiration
...
is less than 30 min while initiating a global backup. Fixes #6444
2) Ensure that proper identification should be there when the server is
connected using Kerberos or without Kerberos. Fixes #6445
2021-05-14 12:33:01 +05:30
7ed97eeec4
Fixed an issue where file dialog showing incorrect files for the selected file types. Fixes #6443
2021-05-14 12:12:17 +05:30
0bb40de1c4
Ensure that the user should not be able to add duplicate panels. Fixes #6399
2021-05-12 15:19:41 +05:30
bd7808a104
Fixed an issue where the filter 'Include/Exclude By Selection' not working for null values. Fixes #6392
2021-05-11 19:12:43 +05:30
11c541adc6
Update document and screenshot for 'Resize by data?' option.
2021-05-11 17:55:22 +05:30
c746cfddfe
Fix width of table row.
2021-05-11 11:47:38 +01:00
fe6f9aae61
Fix a number of typos.
2021-05-11 11:16:38 +01:00
058afad9eb
Added support for cache bust webpack chunk files. Fixes #5477
2021-05-11 13:48:53 +05:30
1e6eca1787
Ensure that pgAdmin4 shut down completely on the Quit command. Fixes #6420
2021-05-10 15:28:45 +05:30
89b0028684
Update Kerberos docs for phase 2.
2021-05-10 10:20:47 +01:00
d80087f6d5
Added support to set auto width of columns by content size in the data output window. Fixes #5954
2021-05-07 17:18:50 +05:30
b0df4d3604
Added support for the creation of Nested Table and Varying Array Type for Advanced Server. Fixes #6407
2021-05-07 12:39:54 +05:30
b30ec71098
Ensure that while connecting to the server using SSPI login, it should not prompt for the password. Fixes #5776
2021-05-05 11:40:48 +05:30
7e79814cb0
Added 'IF NOT EXISTS' clause while creating tables and partition tables which is convenient while using the ERD tool. Fixes #6397
2021-05-04 15:59:34 +05:30
ac403d0dfa
Fixed an issue where the current debug line is not visible in the 'Dark' theme. Fixes #6409
2021-05-04 12:34:03 +05:30
72f3730c34
Added support to connect PostgreSQL servers via Kerberos authentication. Fixes #6158
2021-05-03 16:10:45 +05:30
aa9a4c30d3
Fixed an issue where duplicate columns are visible in the browser tree, which is owned by two sequences. Fixes #6413
2021-05-03 14:53:21 +05:30
3a2145e5fa
Fixed an issue where query editor is not being closed if the user clicks on the 'Don't Save' button. Fixes #6417
2021-05-03 12:52:28 +05:30
333a22496c
Fixed an issue where drag and drop object is not correct in codemirror for properties dialog. Fixes #4436
2021-04-29 13:19:36 +05:30
488dc1849d
Fixed an issue where data is displayed in the wrong order when executing the query repeatedly. Fixes #5555
2021-04-29 13:13:52 +05:30
e718be72e3
Added comment column in the properties panel for View and Materialized View collection node. Fixes #6416
2021-04-28 18:44:28 +05:30
9dd1bae3c7
Ensure that pgAdmin should not allow opening external files that are dragged into it. Fixes #6355
2021-04-28 11:59:45 +05:30
718ac02806
Fixed ModuleNotFoundError when running setup.py from outside of the root. Fixes #6408
2021-04-27 12:54:57 +05:30
7d6f077cf8
Fixed an issue where schema diff does not create DROP DEFAULT statement for columns. Fixes #6377
2021-04-26 16:41:20 +05:30
b853bda2a2
Fixed an issue where the wrong SQL is showing for the child partition tables. Fixes #6329
2021-04-26 14:32:34 +05:30
5894001eb2
Fixed an issue where CSV download quotes the numeric columns. Fixes #6341
2021-04-22 17:35:51 +05:30
8ae8fea6d2
Ensure that Backup and Restore should work on shared servers as some cases were failing due to initial changes.
...
Fixes #6385
2021-04-22 17:29:04 +05:30
dc65cbb08c
Fixed an issue where foreign data wrapper properties are not visible if the host option contains two host addresses. Fixes #6379
2021-04-19 11:08:21 +05:30
b4d44541bb
Fixed SQL panel black screen issue when detaching it in runtime. Fixes #6334
2021-04-15 16:40:35 +05:30
cb7bcaf939
Ensure that Backup and Restore should work on shared servers. Fixes #6385
2021-04-14 12:11:55 +05:30
f07463024c
Fixed flickering issue of the input box on check constraints. Fixes #6107
2021-04-12 12:34:36 +05:30
9853d8bfd6
Fixed an issue while selecting the row which was deleted just before the selection operation. Fixes #6306
2021-04-12 11:45:04 +05:30
0ed47fcd2b
Fixed an issue where the Save button is enabled by default when open the table's properties dialog on PG 9.5. Fixes #6367
2021-04-12 11:36:16 +05:30
098ab9e428
Updated docs and screenshots to cover the Notifications tab on the Query Tool. Fixes #4001
2021-04-12 11:28:48 +05:30
49095ccba6
1) Fixed an issue where shortcut keys are not working with manage macro. Fixes #5908
...
2) Fixed an issue where the cursor shifts its focus to the wrong window for all the query tool related model dialogs. Fixes #6161
2021-04-09 12:41:13 +05:30
1f4affcb1e
Fixed an issue where a connection warning should be displayed when the user
...
clicks on explain or explain analyze and the database server is disconnected
from the browser tree. Fixes #6376
2021-04-08 18:49:31 +05:30
437f0df0f3
Ensure that the strings in the LDAP auth module are translatable. Fixes #6274
2021-04-08 18:15:34 +05:30
14dcb70b95
Ensure that the user should not be to change the connection when a long query is running. Fixes #6082
2021-04-08 18:09:13 +05:30
3a797b1efa
Ensure that the file format for the storage manager should be 'All files' and for other dialogs, it should remember the last selected format. Fixes #6325
2021-04-08 12:23:57 +05:30
8aea86613e
Fixed an issue where users are unable to see data of the partition table using the View/Edit data option. Fixes #6375 .
2021-04-07 16:25:21 +05:30
7f59463e3b
Corrected the syntax for 'CREATE TRIGGER', use 'EXECUTE FUNCTION' instead of 'EXECUTE PROCEDURE' from v11 onwards. Fixes #6220
2021-04-07 12:01:37 +05:30
585ba81492
Fixed sizing issue of help dialog for Query Tool and ERD Tool when open in the new browser tab. Fixes #6333
2021-04-06 15:26:25 +05:30
811ac6eb6c
Added missing dependency 'xdg-utils' for the desktop packages in RPM and Debian. Fixes #6338
2021-04-02 13:53:05 +05:30
53f5562468
Fixed an issue where correct error not thrown while importing servers and JSON file has incorrect/insufficient keys. Fixes #6076
2021-04-02 08:58:43 +05:30
c84df9cc0f
Ensure that while comparing domains check function dependencies should be considered in schema diff. Fixes #6327
2021-04-01 16:31:12 +05:30
566f03beca
Ensure that the query tool tab should be closed after server disconnection when auto-commit/auto-rollback is set to false. Fixes #5519
2021-04-01 11:58:59 +05:30
07f2df7e66
Fixed cannot unpack non-iterable response object error when selecting any partition. Fixes #6344
2021-03-31 12:08:01 +05:30
f0c86741a4
Improve code coverage and API test cases for Server module. Fixes #5319
2021-03-30 11:12:33 +05:30
a29890368c
Fixed an issue where the procedure creation is failed when providing the Volatility option. Fixes #6293
2021-03-30 10:58:32 +05:30
9c69c1a277
Mark the Apache HTTPD config file as such in the web DEB and RPM packages. Fixes #6356
2021-03-29 10:35:50 +01:00
723d97971d
1) Ensure that SQL formatter should not add extra tabs and format the SQL correctly. Fixes #5869
...
2) Ensure that SQL formatter should not use tab size if 'Use spaces?' set to false. Fixes #6233
2021-03-22 14:47:19 +05:30
3f63f65674
Ensure that the view/edit data panel should not be opened for unsupported nodes using the keyboard shortcut. Fixes #6206
2021-03-19 15:38:40 +05:30
b973d6055d
Ensure that toggle buttons are accessible by most screen readers. Fixes #6317
2021-03-19 11:44:57 +05:30
ded65340fe
Ensure the Python interpreter used by the runtime ignores user site-packages. Fixes #6269
...
Significant debugging by Peter Buckner.
2021-03-17 15:20:20 +00:00
4bb71c56ad
Fixed an issue where the top menu disappears when entering into the full screen for minimum screen resolution. Fixes #6322
2021-03-17 18:47:25 +05:30
ff06a18155
1) Fixed an issue where the incorrect values visible in the dependents tab for publication. Fixes #6307
...
2) Ensure that the primary key should be visible properly in the table dialog. Fixes #6316
2021-03-16 11:43:27 +05:30
9395ce3fda
Fixed an issue where copy/paste rows in view data paste the wrong value for boolean type. Fixes #6312
2021-03-16 11:29:47 +05:30
49a59f8929
Added zoom scaling options with keyboard shortcuts in runtime. Fixes #6271
2021-03-15 14:26:11 +05:30
bf6ee28dae
Cleanup naming/title consistency
2021-03-12 16:04:09 +00:00
80032e9658
Make the container distribution a multi-arch build with x86_64 and Arm64 support. Fixes #6212
2021-03-12 15:54:30 +00:00
8031961205
Fixed alignment issue under preferences for the German language. Fixes #4014
2021-03-12 13:33:04 +05:30
7bad4ca535
Show the login roles that are members of a group role be shown when examining a group role. Fixes #5404
2021-03-12 13:11:09 +05:30
408df750be
Fixed color issue on the statistics tab for collection node in the safari browser. Fixes #4020
2021-03-12 11:49:58 +05:30
03d3b8c03c
1) Fixed an issue where % displayed twice in explain analyze for query and table. Fixes #4847
...
2) Rename text 'table' with 'relation' in the statistic tab for explain analyze. Fixes #4849
2021-03-12 11:40:17 +05:30
d6ee715d83
Ensure that autovacuum and analyze scale factors should be editable with more than two decimals. Fixes #4784
2021-03-09 18:48:32 +05:30
351d86e149
Fixed string index out of range error where the dependent tab is in focus and selecting any publication or table. Fixes #6292
2021-03-09 18:43:04 +05:30
0f62fecca2
Fixed an issue where the dependent tab throwing an error when selecting any login/group role. Fixes #6294
2021-03-09 14:32:16 +05:30
6ffb82fb6d
Make the 'Save Data Changes' icon to be more intuitive. Fixes #6176
2021-03-09 13:58:17 +05:30
a2be30d257
Use schema qualification while accessing the catalog objects. Fixes #3976
2021-03-09 13:18:45 +05:30
8cf7c41ad9
Fixed an issue where adding/updating records fails if the table name contains percent sign. Fixes #4438 .
2021-03-09 12:40:59 +05:30
5e40f9904d
Make 'kerberos' an optional feature in the Python wheel, to avoid the need to install MIT Kerberos on the system by default. Tidy up the Python versioning a little whilst passing. Fixes #6268
2021-03-08 11:33:08 +00:00
04a24680a6
Ensure that the venv activation scripts have the correct path in them on Linux. Partially fixes #6279
2021-03-05 09:58:30 +00:00
d70dea5072
Ensure that the template database should be visible while creating the database. Fixes #6286
2021-03-04 17:48:52 +05:30
778e0cd402
Ensure that cell content being autoselected when editing the cell data. Fixes #5810
2021-03-04 13:53:23 +05:30
9317fe21b2
Fixed an issue where the user is not able to change the connection in Query Tool when any SQL file is opened. Fixes #6272
2021-03-04 13:17:31 +05:30
8be3517c6d
Fixed an issue where hanging symlinks in a directory cause select file dialog to break. Fixes #5119
2021-03-04 12:48:56 +05:30
77949ac4f7
Improve the web setup script for Linux to make the platform detection more robust and overrideable. Fixes #6228
2021-03-03 09:06:37 +00:00
faa66f1636
Added '--replace' option in Import server to replace the list of servers with the newly imported one. Fixes #6270
2021-03-01 18:00:06 +05:30
6cf3913c8e
Clarify docs around configuration.
2021-03-01 10:47:50 +00:00
9225493a93
Fixed an issue where schema diff showing wrong SQL when comparing triggers with different when clause. Fixes #6281 .
2021-03-01 13:20:43 +05:30
4267207c7f
1) Fixed an issue where the user is unable to create a subscription if the host/IP address for connection is 127.0.0.1. Fixes #6253
...
2) Ensure that proper error message should be shown on the properties and statistics tab in case of insufficient privileges for a subscription. Fixes #6259
3) Fixed an issue where the 'Create Slot' option is disabled in case of the same IP/host provided but the port is different. Fixes #6260
2021-03-01 12:08:33 +05:30
cafd2af96d
Ensure PGADMIN_DEFAULT_EMAIL looks sane when initialising a container deployment. Fixes #6227
2021-02-26 16:57:09 +00:00
544483ae1f
Remove the "launch now" option in the Windows installer, as UAC could cause it to run as an elevated user. Fixes #5628
...
While we're passing, fix a couple of InnoSetup build warnings and remove some unnecessary code.
2021-02-26 16:24:39 +00:00
e8114b5dc6
Allow underscores in the Windows installation path. Fixes #5467
2021-02-26 12:27:39 +00:00
87b9549ff4
Fixed encoding issue when database encoding set to SQL_ASCII and name of the column is in ASCII character. Fixes #6018
2021-02-26 13:23:07 +05:30
5a5a9314f3
Fixed an issue where the Save button is enabled for functions/procedures by default when open the properties dialog. Fixes #5073
2021-02-26 13:15:29 +05:30
4fc36a9053
Fixed an issue where the properties tab for collection nodes is unresponsive after switching the tabs. Fixes #4959
2021-02-26 12:50:30 +05:30
8279e7e01c
Ensure that the user should be able to kill the session from Dashboard if the user has a 'pg_signal_backend' role. Fixes #6159
2021-02-26 12:50:30 +05:30
4ea2246333
Remove the executable bit form images.
2021-02-25 09:12:16 +00:00
2d537b6909
Updated release note
2021-02-22 16:47:16 +05:30
ea33ab308e
Runtime docs. Fixes #6195
2021-02-22 10:47:13 +00:00
291e645d77
1) Updated documentation for SSL support in Subscription dialog.
...
2) Fixed API test cases.
refs #6201
2021-02-22 11:02:16 +05:30
df7de2ef71
Ensure RPMs & DEBs depend on matching versions of each other. Fixes #6250
2021-02-19 10:09:41 +00:00
731ba32e81
1) Added SSL support for creating a subscription. Fixes #6201
...
2) Fixed an issue where the user is not able to create the subscription. Fixes #6230
3) Fixed a couple of issues raised during testing of logical replication.
2021-02-19 14:56:45 +05:30
b27a884bda
Documentation of Logical Replication. Fixes #6145
2021-02-18 11:37:56 +05:30
44cc7a308a
Added publication and subscription support in Schema Diff. Fixes #6153
2021-02-15 16:05:40 +05:30
c1e80ac38a
Fixed an issue where the ERD image is not properly downloaded. Fixes #6197
2021-02-15 15:24:57 +05:30
be090552f8
Documentation of Quick Search support. Fixes #6196
2021-02-15 14:56:50 +05:30
2036e9d9a8
Fixed an issue where the user is unable to update column-level privileges from the security tab. Fixes #6117
2021-02-10 17:56:26 +05:30
1317e4254b
Updated the JS dependencies to the latest
...
1) Migrate from webpack 4 to webpack 5. This had a lot of breaking changes,
so updated multiple webpack plugins and changed the config accordingly.
2) Replaced iconfont-webpack-plugin with a more maintained webfonts-loader.
3) Replaced deprecated babel-eslint with @babel/eslint-parser.
4) Replaced optimize-css-assets-webpack-plugin with a more maintained css-minimizer-webpack-plugin.
5) Updated all other JS packages and made the required code changes.
Fixes #6207
2021-02-10 12:47:52 +05:30
85b40ee4f0
Fixed an issue where the user unable to change the background color for a server. Fixes #6178
2021-02-05 14:15:37 +05:30
9e85fb3de3
Fixed an issue where strike-through is not visible for rows selected for deletion after scrolling. Fixes #6157
2021-02-05 13:57:35 +05:30
9c7691c891
Fixed an issue where utility(Backup, Maintenance, ...) jobs are failing when the log level is set to DEBUG. Fixes #6208
2021-02-04 14:50:26 +05:30
14036b7aeb
Fixed an issue where the focus is not properly set on the filter text editor after closing the error dialog. Fixes #5809
2021-02-04 11:45:16 +05:30
02c3863e8c
Fixed an issue where shared server entries not getting deleted from SQLite database if the user gets deleted. Fixes #6143
2021-02-04 11:31:39 +05:30
73b6b95fbc
Make Statistics, Dependencies, Dependants tabs closable and the user can add them back using the 'Add panel' option. Fixes #5091
2021-02-03 12:46:32 +05:30
b41557b54b
Instead of rotating logs, don't write them to the container in the first place.
...
This is inline with container best practices (logs go to the container console).
Fixes #6170
2021-02-02 13:45:49 +00:00
b948f43dda
Added Quick Search functionality for menu items and help articles. Fixes #6148
2021-02-02 14:47:58 +05:30
75f887f5dc
Ensure that ERD throws a warning before closing unsaved changes if open in a new tab. Fixes #6193
2021-02-02 11:47:10 +05:30
e10dd6a80f
Rotate the logfile in the container distribution. Fixes #6170
2021-02-01 17:35:23 +00:00
2a4ba132ad
Remove the PG 9.5 utilities, as it'll be out of support by the next release.
2021-02-01 17:20:24 +00:00
bf56a6723b
Added support for Logical Replication. Fixes #5912
2021-02-01 15:12:43 +05:30
08df09af96
Limit the upgrade check to run once per day. Fixes #6187
2021-01-29 16:01:35 +00:00
2e68c6ff75
Fixed Definition list ends without a blank line; unexpected unindent.
2021-01-29 14:56:18 +05:30
102ffd141c
Implemented runtime using NWjs to open pgAdmin4 in a standalone window
...
instead of the system tray and web browser. Used NWjs to get rid of QT
and C++. Fixes #5967
Use cheroot as the default production server for pgAdmin4. Fixes #5017
2021-01-29 13:38:27 +05:30
a0271c7656
Fixed an issue while downloading ERD images in Safari and Firefox. Fixes #6177
2021-01-29 12:19:24 +05:30
358af42c50
Fixed an issue where the dependencies tab showing multiple owners for the objects having shared dependencies. Fixes #6087
2021-01-29 12:10:21 +05:30
48e257e5af
1) Fixed an issue where Zoom to fit button only works if the diagram is larger than the canvas. Fixes #6163
...
2) Ensure that the diagram should not vanish entirely if zooming out too far in ERD. Fixes #6164
3) Fixed an issue where Generate SQL displayed twice in the ERD tool. Fixes #6179
4) Updated missing documentation for the 'Download Image' option in ERD. Fixes #6180
2021-01-29 11:54:50 +05:30
36f76f5e2c
Fixed autocomplete issue where it is not showing any suggestions if the schema name contains escape characters. Fixes #6045 .
2021-01-29 11:45:38 +05:30
ab642344d4
Ensure that username should be visible in the 'Connect to Server' popup when service and user name both specified. Fixes #5871
2021-01-29 11:32:27 +05:30
addcf2c6e2
Fix typo
2021-01-27 10:02:28 +00:00
88c0968cab
Some minor updates to Kerberos documentation.
2021-01-25 19:32:53 +05:30
e20f26c500
Documentation of ERD Diagram support. Fixes #6152
2021-01-25 12:18:47 +05:30
048c90a695
Documentation of Kerberos support. Fixes #6147
2021-01-25 12:11:08 +05:30
f92b0961ee
Revert "Fixed an issue where shared server entries not getting deleted from SQLite database if the user gets deleted. Fixes #6143"
...
This reverts commit 57ed02a9aa
2021-01-21 15:23:03 +05:30
57ed02a9aa
Fixed an issue where shared server entries not getting deleted from SQLite database if the user gets deleted. Fixes #6143
2021-01-21 14:23:02 +05:30
3e09f1bf40
Ensure that the current value of the sequence should be ignored while comparing using schema diff. Fixes #6144
2021-01-21 14:18:06 +05:30
32cdfa2969
Include PostgreSQL 13 utilities in the container. Fixes #6162
2021-01-20 13:17:27 +00:00
850afd7402
Add a container option (PGADMIN_DISABLE_POSTFIX) to disable the Postfix server.
2021-01-20 11:50:05 +00:00
9bee91b6f6
1) Fixed an issue where the Save button is enabled by default in Macro. Fixes #5905
...
2) Remove extra line after Manage Macros menu while clearing all macros. Fixes #5906
3) Ensure that 'Clear All Rows' should not work if there is no existing macro available and the user does not specify any value. Fixes #5907
4) Fixed an issue where the server is disconnected error message displayed if the user creates Macro with invalid SQL. Fixes #5929
2021-01-20 13:52:00 +05:30
b3ca172f3a
Fixed an issue of deleting records when the user tries to delete multiple records. Fixes #6098
2021-01-20 12:39:12 +05:30
c0ef0a893d
1) Added support for Kerberos authentication, using SPNEGO to forward the Kerberos tickets through a browser. Fixes #5457
...
2) Fixed incorrect log information for AUTHENTICATION_SOURCES. Fixes #5829
2021-01-18 16:32:10 +05:30
0c8226ff39
Added ERD Diagram support with basic table fields, primary key, foreign key, and DDL SQL generation. Fixes #1802
2021-01-16 17:06:50 +05:30
065bda37b4
Added informative message when there is no difference found for schema diff. Fixes #6122
2021-01-15 14:03:22 +05:30
a2edf317a9
Ensure that the user should be able to specify an older date for the account expiration of the role/user. Fixes #6120
2021-01-15 11:38:08 +05:30
f86f58dc56
Revert "Ensure that the account expiration date for role/user can’t be older than the current date. Fixes #6120"
...
This reverts commit 9a47e574e3
2021-01-14 14:47:52 +05:30
f0debdd513
Revert "1) Added support for Kerberos authentication, using SPNEGO to forward the Kerberos tickets through a browser. Fixes #5457"
...
This reverts commit 6ead597b43
2021-01-14 14:46:59 +05:30
6ead597b43
1) Added support for Kerberos authentication, using SPNEGO to forward the Kerberos tickets through a browser. Fixes #5457
...
2) Fixed incorrect log information for AUTHENTICATION_SOURCES. Fixes #5829
2021-01-14 13:46:48 +05:30
9a47e574e3
Ensure that the account expiration date for role/user can’t be older than the current date. Fixes #6120
2021-01-14 12:09:03 +05:30
1a756efe82
Fixed an issue where Non-admin user is unable to view shared server created using service. Fixes #6075
2021-01-13 12:18:16 +05:30
18e4b30634
Reverting fix for #4892 , updated the RM with the workaround.
2021-01-13 11:05:46 +05:30
6589f82e77
Improve the explain plan details by showing popup instead of tooltip on clicking of the specified node. Fixes #5488
2021-01-12 16:43:30 +05:30
0fcfe63092
Fixed an issue on refreshing files in Query Tool. Fixes #6069
2021-01-11 17:40:13 +05:30
d55555c544
Fixed an issue where sequences are not created. Fixes #6128
...
refs #6084
2021-01-11 17:29:08 +05:30
90004119af
Ensure that verbose logs should be visible for Utility(Backup, Maintenance) jobs. Fixes #6140
2021-01-11 16:35:44 +05:30
f8497d4e7a
Fixed an issue where the database list in the new connection window is not visible. Fixes #6121
2021-01-11 13:03:15 +05:30
eb3cd689a1
1) Update release date.
...
2) Update copyright notice.
2021-01-07 17:05:56 +05:30
b372f08a59
Update copyright notices for 2021
2021-01-04 15:34:45 +05:30
5198a881b7
Added 'Count Rows' option to the partition sub tables. Fixes #5282
2021-01-04 15:25:05 +05:30
d1f5511566
Improve code coverage and API test cases for pgAgent. Fixes #5338
2020-12-31 13:52:14 +05:30
6fce58f2ad
Updated Flask-BabelEx to the latest. Fixes #5997
2020-12-31 13:48:35 +05:30
dbb4a46d46
Fixed accessibility issues in various dialogs. Fixes #6077
2020-12-24 13:26:25 +05:30
3012778def
Updated deployment documentation, refer correctly to uWSGI where Gunicorn had been referenced. Fixes #6096
...
Patch By: Thomas Levine
2020-12-24 13:20:08 +05:30
4c9853f10d
Fixed an issue where pressing the back button will show another instance of the main page inside of the Query Tool tab. Fixes #4892
2020-12-24 13:13:57 +05:30
5448de2d3f
Added support for expression in exclusion constraints. Fixes #5571
2020-12-24 12:50:57 +05:30
a92595012f
Fixed extra parentheses issue around joins for Views. Fixes #6061
2020-12-23 13:02:16 +05:30
c933771016
Fixed accessibility issues in schema diff module. Fixes #6065
2020-12-23 12:57:16 +05:30
ed5fc20ee2
Fixed TypeError exception in schema diff when selected any identical object. Fixes #6084
2020-12-21 15:06:01 +05:30
3def9792be
Added appropriate help message and a placeholder for letting users know about the account password expiry for Login/Group Role. Fixes #5973
2020-12-17 12:02:32 +05:30
a7b8d77ed7
Fixed an issue where the state of the Save File icon does not match the dirty editor indicator. Fixes #6046
2020-12-17 11:37:03 +05:30
cb0a914099
Ensure that the 'template1' database should not be visible after pg_upgrade. Fixes #5875
2020-12-16 11:37:19 +05:30
5f5818ba78
Updated mimetype from 'text/javascript' to 'application/javascript' as 'text/javascript' is obsolete. Fixes #6079
2020-12-14 12:34:19 +05:30
c4d9ef9210
Added connected pgAdmin user and connection name in the log file. Fixes #6052
...
Patch By: Nico T
2020-12-14 12:24:06 +05:30
52780079f3
Fixed an issue where the dirty indicator stays active even if all changes were undone. Fixes #6047
2020-12-14 12:02:02 +05:30
6475a70514
Ensure that the macro query result should be download properly. Fixes #5965
2020-12-14 11:58:53 +05:30
c79614786f
Ensure that the rename panel should be disabled when the SQL file opened in the query tool. Fixes #6058
2020-12-10 18:13:04 +05:30
eee23aa642
Fixed DLL load failed while importing bcrypt. Fixes #6072
2020-12-08 14:40:37 +05:30
ca4db8871e
Ensure that code coverage should cover class and function declarations. Fixes #6062
2020-12-06 19:16:17 +05:30
12dc2c418d
Fixed documentation issue where JSON is not valid. Fixes #5982
2020-12-03 10:46:36 +05:30
1c5cb63aff
Fixed an issue where shared servers import is failing. Fixes #6022
2020-12-03 10:40:52 +05:30
794bd50ed1
Improve code coverage and API test cases for Debugger. Fixes #5343
2020-12-03 10:31:24 +05:30
26b3bc3f74
Fixed an issue where an illegal argument is showing for trigger SQL when a trigger is created for View. Fixes #6003
2020-12-02 10:55:23 +05:30
64e6570f00
Fixed an issue where schema diff doesn't show the result of compare if source schema has tables with RLS. Fixes #5998
2020-12-01 13:46:19 +05:30
783b7516a7
Fixed false error is shown while adding a new foreign key from the table dialog when a foreign key already exists with Auto FK Index set to true. Fixes #5886
2020-12-01 11:35:01 +05:30
abd0748a77
Ensure that dirty indicator (*) should not be visible when renaming the tabs. Fixes #5991
2020-12-01 11:28:10 +05:30
fb51ef569e
Fixed an issue where escape character is shown when the server/database name has some special characters. Fixes #5992
2020-12-01 11:19:07 +05:30
b54cf2edca
Improve code coverage and API test cases for Foreign Tables. Fixes #5328
2020-11-26 11:52:06 +05:30
55e50144f3
Update the cryptography python package for Python 3.5 and above. Fixes #6033
2020-11-26 11:43:08 +05:30
ce14696165
Improve code coverage and API test cases for Views and Materialized Views. Fixes #5337
2020-11-20 10:04:30 +05:30
3e2a1c4eca
Ensure that folder rename should work properly in Storage Manager. Fixes #5943
2020-11-19 10:33:05 +05:30
17ce84dd0a
Fixed an issue where dynamic tab title has not applied the first time for debugger panel. Fixes #5978
2020-11-19 10:25:20 +05:30
ebf5e871e0
Fixed an issue where the debugger's custom tab title not applied when opened in the new browser tab. Fixes #5974
2020-11-12 17:59:13 +05:30
5370bb4515
Added the appropriate server icon based on the server type in the new connection dialog. Fixes #5983
2020-11-12 17:52:54 +05:30
be386e77f2
1) Fixed an issue where the process watcher dialog throws an error for
...
the database server which is already removed. Fixes #5985
2) Fixed cognitive complexity reported by SonarQube.
2020-11-12 17:47:21 +05:30
64964f82cf
Ensure that Grant Wizard should include foreign tables. Fixes #5959
2020-11-09 12:44:00 +05:30
2793747d3c
1) Added support for dynamic tab size. Fixes #4231
...
2) Fixed an issue where a long file name is not visible on the process watcher dialog. Fixes #5950
2020-11-04 17:45:28 +05:30
749ba4a25c
Documentation of Storage Manager. Fixes #5938
2020-11-04 17:31:21 +05:30
91c5ff4a90
Fixed feature test failure.
2020-10-31 17:00:05 +05:30
25fcdab9db
Fixed an issue where a mismatch in the value of 'Estimated row' for functions. Fixes #5914
2020-10-30 15:09:40 +05:30
14a5d05b80
Ensure that non-superuser should be able to debug the function. Fixes #5760
2020-10-30 15:03:18 +05:30
183c83f0d2
Fixed an issue where the validation error message is shown twice. Fixes #5736
2020-10-30 14:59:22 +05:30
1126ee77ec
Updated documentation for pgAgent.
2020-10-28 12:33:56 +05:30
6c723a7e43
Fixed an issue where connection to the server is on wait state if a different user is provided. Fixes #5953
2020-10-28 12:32:22 +05:30
b76bb58378
Added support to compare schemas and databases in schema diff. Fixes #5891
2020-10-27 16:36:10 +05:30
c86a3d64fc
Added support to rename query tool and debugger tabs. Fixes #4230
...
Fixed an issue where non-closeable tabs are getting closed. Fixes #5923
2020-10-23 17:16:31 +05:30
c2ad97d0ab
Added support to download utility files at the client-side. Fixes #3318
2020-10-23 16:14:55 +05:30
7573fac29f
Ensure that query history should be listed by date/time in descending order. Fixes #5842
2020-10-23 15:06:56 +05:30
08c4deba5a
Added following security enhancements:
...
1) Added ALLOWED_HOSTS list to limit the host address.
2) Added CSP and HSTS security header.
3) Hide the webserver/ development framework version.
Fixes #5919
2020-10-20 17:14:45 +05:30
3413a42af4
Ensure that some fields should be disabled for the trigger in edit mode. Fixes #4639
...
Fixed illegal argument issue in the trigger for EPAS servers. Fixes #5799
2020-10-20 16:18:34 +05:30
7b9504bdfb
Fixed an issue where the suffix for Toast table size is not visible in the Statistics tab. Fixes #5895
2020-10-20 15:57:32 +05:30
18cad32bd4
Added tab title placeholder for Query Tool, View/Edit Data, and Debugger. Fixes #4232
2020-10-20 15:41:54 +05:30
38b90f7b00
Ensure that search object functionality works with case insensitive string. Fixes #5858
2020-10-15 16:17:54 +05:30
6addd207af
Ensure that macros should be run on the older version of Safari and Chrome. Fixes #5911
2020-10-15 15:59:53 +05:30
b11a0d50e6
Fixed documentation review comments for Macro support.
...
refs #5857
2020-10-12 16:13:34 +05:30
556278dbc5
Added support to view trigger function under the respective trigger node. Fixes #2519
2020-10-12 13:49:54 +05:30
365ec0ba9f
Fixed an issue where 'Rows X' column values were not visible properly for Explain Analyze in Dark theme. Fixes #5853 .
2020-10-09 18:17:27 +05:30
609904cfb3
Added documentation for Macro support. Fixes #5857
2020-10-06 17:35:04 +05:30
82e912ffad
Fixed 'can't execute an empty query' message if the user change the option of Auto FK Index. Fixes #5835
2020-10-06 17:20:43 +05:30
6c4049f29a
Added RESQL/MSQL test cases for Functions. Fixes #5395
...
Initial patch sent by Nikhil Mohite.
2020-10-06 17:13:41 +05:30
9466278be2
Fixed invalid literal issue when fetching dependencies for Materialized View. Fixed #5882
2020-10-05 17:53:47 +05:30
e4029cca04
Ensure that the user should be able to change the start value of the existing sequence. Fixes #5855
2020-10-05 16:38:16 +05:30
c28509ac28
Fixed an issue where the user is unable to change the macro name. Fixes #5885
2020-10-05 14:40:21 +05:30
be7bb81a19
Allow user to change the database connection from an open query tool tab. Fixes #3794
2020-10-01 13:29:46 +05:30
300de05a20
Merged the latest code of 'pgcli' used for the autocomplete feature. Fixes #5497
2020-10-01 13:29:46 +05:30
b097cec45e
Fixed an issue where some properties are not being updated correctly for the shared server. Fixes #5867
2020-09-30 12:29:59 +05:30
a707d818f5
Removed (Beta) keyword from Schema Diff and High Contrast theme.
2020-09-29 18:27:28 +05:30
c7c199210d
Fixed an issue where file extension is stripped on renaming a file. Fixes #4855
2020-09-29 11:03:38 +05:30
3e7cdcdf90
Ensure that 'ctrl + a' shortcut does not move the cursor in SQL editor. Fixes #5131
2020-09-29 10:56:57 +05:30
1fc06b8d57
Added useful message when the explain plan is not used and empty. Fixes #4806
2020-09-28 17:51:59 +05:30
4616a74029
Added Macro support. Fixes #1402
2020-09-28 15:26:45 +05:30
952197f130
Added support to ignore the owner while comparing objects in the Schema Diff tool. Fixes #5200 .
2020-09-28 15:22:46 +05:30
68588fbb44
Fixed an issue where schema diff is showing identical table as different due to default vacuum settings. Fixes #5826
2020-09-24 13:24:25 +05:30
c1d04747a1
Ensure that the 'Remove Server' option should be visible in the context menu. Fixes #5861
2020-09-24 10:58:30 +05:30
2e55b1f660
Fixed an issue where the 'PARALLEL UNSAFE' option is missing from reverse engineering SQL of function/procedure node. Fixes #5843 .
2020-09-23 13:21:50 +05:30
43d97b0e6f
Improve code coverage and API test cases for Functions. Fixes #5330
2020-09-22 14:43:46 +05:30
458036ad6b
Fixed an issue where the server is not able to connect using the service. Fixes #5841
2020-09-22 13:14:40 +05:30
1ee9cddceb
Ensure that the import/export feature should work with SSH Tunnel. Fixes #5739
2020-09-22 09:40:59 +05:30
ed3c692b1f
Fixed an issue where the query tool is not fetching more than 1000 rows for the table does not have any primary key. Fixes #5845
2020-09-21 15:36:19 +05:30
b0475566ca
Fixed reverse engineering SQL where parenthesis is not properly arranged for View/MView definition. Fixes #5830
2020-09-21 11:05:56 +05:30
3489f94ca7
Ensure that multiple extensions can be dropped from the properties tab. Fixes #5839 .
2020-09-21 10:09:41 +05:30
553be14000
Fixed an issue where a column is renamed and then removed, then the drop SQL query takes the wrong column name. Fixes #5807 .
2020-09-21 09:40:45 +05:30
a25e808e06
Remove maximum length on the password field in the server dialog. Fixes #5802
2020-09-17 20:21:00 +05:30
55b5080c77
Fixed and improve API test cases for the schema diff tool. Fixes #5417
2020-09-17 20:10:01 +05:30
593d86d3f2
Ensure that the 'Remove Server Group' option is available in the context menu. Fixes #5834
2020-09-15 13:19:00 +05:30
8e132eab08
Fixed some accessibility issues. Fixes #5732
2020-09-15 13:03:18 +05:30
324e3e74be
Fixed an issue where custom sequences are not visible when show system objects are set to false. Fixes #5833
2020-09-15 12:58:43 +05:30
6ded547a0d
Added documentation for shared server support. Fixes #5792
2020-09-11 19:12:08 +05:30
a7d40e238e
Ensure that the 'CREATE SCHEMA' statement should be present in the generated script if the schema is not present in the target database. Fixes #5816
2020-09-11 19:06:56 +05:30
1bd0a0edf5
Remove illegal argument from trigger function in trigger DDL statement. Fixes #5779
2020-09-10 17:27:01 +05:30
d0310b669e
Fixed an issue where clicking on the 'Generate script' button shows a forever spinner due to pop up blocker. Fixes #5815
2020-09-09 20:10:56 +05:30
ffb829e80c
Fixed an issue while refreshing Resource Group. Fixes #5820
2020-09-09 14:34:14 +05:30
f278490540
Update the description of GIN and GiST indexes in the documentation. Fixes #5734
2020-09-08 12:04:58 +05:30
9e5487d5ad
Fixed SQL for Row Level Security which is incorrectly generated. Fixes #5764
2020-09-07 18:40:49 +05:30
8c2e965f6e
Fixed excessive CPU usage by stopping the indefinite growth of the graph dataset. Fixes #5794
2020-09-07 18:23:04 +05:30
f8f00b4ecf
Fixed an issue in the query tool when columns are having the same name as javascript object internal functions. Fixes #5765 .
2020-09-07 18:10:27 +05:30
b562ab7681
Added shared server support for admin users. Fixes #4979
2020-09-03 12:59:28 +05:30
3e35dc95e5
Improve code coverage and API test cases for Tables. Fixes #5774 .
2020-09-03 12:35:56 +05:30
b5c299c5ad
Fixed an issue where --load-server does not allow loading connections that use pg_services. Fixes #5746
2020-08-31 17:49:46 +05:30
5a253f9053
Change the following to replace Python 2 code with Python 3:
...
1) Replace the deprecated unit test method.
2) Wraps filter usage in a list call.
3) Converts the old metaclass syntax to new.
4) Use range instead of xrange method.
5) Change Unicode to str.
6) Several other transformations.
7) Fixed change password test cases.
8) Use simplejson instead of plain JSON.
2020-08-31 16:45:31 +05:30
e226b2fa75
Adjusted the height of jobstep code block to use maximum space. Fixes #5426 .
2020-08-28 14:00:49 +05:30
e8b192be3e
Added a new button to the query tool toolbar to open a new query tool window. Fixes #4059
2020-08-28 13:53:08 +05:30
8368eed645
Ensure that 'setup-web.sh' should work in Debian 10. Fixes #5775 .
2020-08-27 19:21:21 +05:30
8222bf6420
Modified the 'Commit' and 'Rollback' query tool button icons. Fixes #5662
2020-08-27 12:58:13 +05:30
0998d349ca
Fixed an issue where the application ignores the fixed port configuration value. Fixes #5773
2020-08-27 12:49:58 +05:30
f3bde7b5f1
Ensure that schema names starting with 'pg' should be visible in browser tree when standard_conforming_strings is set to off. Fixes #4216
2020-08-26 18:16:16 +05:30
8fcf527632
Improve code coverage and API test cases for Columns and Constraints (Index, Foreign Key, Check, Exclusion). Fixes #5332
2020-08-26 12:35:22 +05:30
4eb17afe4e
Warn the user when connecting to a server that is older than pgAdmin supports. Fixes #5772
2020-08-25 17:18:43 +01:00
59649ca42c
1) Enable the 'Configure' and 'View log' menu option when the server taking longer than usual time to start.
...
2) When an error occurs from the backend, the configure window opens and if the user has changed the setting
of the port, it won't take any effect as we have retrieved the value of the port at the start of the runtime.
3) Added logic to identify the specified fixed port is already in use. Throw the error before starting the pgAdmin server.
Fixes #5751
2020-08-25 18:01:27 +05:30
df9aaf19c2
Fixed string indices must be integers issue for PostgreSQL < 9.3. Fixes #5766
2020-08-25 13:38:24 +05:30
86bbc3a9e8
Ensure that the user should be able to drop the database even if it is connected. Fixes #5722
2020-08-25 12:37:50 +05:30
b3d49c61a5
Fixed incorrect reverse engineering SQL for Foreign key when creating a table. Fixes #5748
2020-08-25 12:31:58 +05:30
52d0241a17
Fixed an issue where schema diff is not working when providing the options to Foreign Data Wrapper, Foreign Server, and User Mapping. Fixes #5754
2020-08-24 12:11:09 +05:30
6415294782
Improve code coverage and API test cases for Grant Wizard. Fixes #5344
2020-08-20 14:04:24 +05:30
79e6480513
Added SQL Formatter support in Query Tool. Fixes #2042
2020-08-20 13:05:00 +05:30
0fd9ee06bd
Fix typo
2020-08-18 11:15:24 +01:00
b0af385ea0
Fixed an issue where the entire logs is in red text when the user runs backup and restore. Fixes #5604
2020-08-17 17:23:30 +05:30
93adf6884f
Upgrade font awesome from v4 to v5. Fixes #5731
2020-08-13 12:04:00 +05:30
5b688cf949
Resolve schema diff dependencies by selecting the appropriate node automatically and maintain the order in the generated script. Fixes #5730
2020-08-12 17:36:48 +05:30
7dd313f5fc
Fixed an issue where debugger doesn't work if the search path is set other than 'public'. Fixes #4123
2020-08-12 14:24:40 +05:30
1f70385a4e
Fixed an issue where conversion of bytea to the binary string results in an error. Fixes #5567
2020-08-11 15:31:14 +05:30
2907a79dd7
Added missing comments in reverse engineering SQL for each column of a View. Fixes #3791
2020-08-11 11:30:47 +05:30
Dave Page
Aditya Toshniwal
Yogesh Mahajan
Nikhil Mohite
Akshay Joshi
Fahar Abbas
Khushboo Vashi
Pradip Parkale
Charlet, Christoph
Rahul Shirsat
zhangjie2@fujitsu.com
Ashesh Vashi
Ganesh Jaybhay
Talha Bin Rizwan
huangj.fnst@fujitsu.com
Nico Rikken
Florian Sabonchi
Cyril Jouve
Nidhi Bhammar
Chethana Kumar
Alessandro De Maria
Pramod Ahire
Chris Mayo