42018e69a5
Add support to deploy pgAdmin in container with readOnlyRootFilesystem to true. #7330
2024-12-03 17:50:20 +05:30
6810fa6ce6
Add support for passing connection details as placeholders in the passexec command. #6794
...
Added a fix where electron app menu was not refreshing when node selection changed.
2024-11-29 17:54:07 +05:30
190574b3af
Fix issues more scenarios related to crypt key missing on backend server restart. #8065
2024-11-29 12:05:46 +05:30
657b0f82ec
Fixed an issue where query tool throws syntax error if a newly added row is untouched and saved. #8028
...
Fixed an issue where auto-width of wide columns in data output is incorrectly calculated. #8158
2024-11-28 14:18:13 +05:30
cd2f48aeb1
Fixed an issue in schema diff where an error message popup was showing some garbage without any info. #8098
2024-11-28 10:16:41 +05:30
88e515093c
Show auto-complete column names in filtered rows dialog of table and filter options of view/edit data tool. #3751
...
Allow setting NULL ordering for columns in view/edit data filter dialog. #3317
2024-11-28 10:13:57 +05:30
9ef5a53790
Add a user preference to enable/disable alternating row background colors in the data output of query tool. #8134
...
Fixed some theme related issues.
2024-11-27 11:23:13 +05:30
da530824d6
Fixed an issue where indent with space was not aligning to next tab position. #7486
2024-11-25 16:42:07 +05:30
ea693396b8
Update MUI from v5 to v6
2024-11-25 16:36:21 +05:30
f4cba74bf6
Fixed an issue where querying a foreign table gives the error 'ForeignTableCommand' object has no attribute 'auto_commit'. #7384
2024-11-25 14:40:26 +05:30
042888f5d7
Fixed an issue where ERD auto-layout should: #6592 ( #8167 )
...
- Always generate right-angled links
- Switch port to Left/Right for the best link route.
2024-11-22 16:26:50 +05:30
026c0d2389
Ensure the crypt key is retrieved correctly on backend server restart. #8065
2024-11-21 15:55:38 +05:30
4dbfdd8740
Added an EPAS 17 resql test case for builtin locale provider. #8095
2024-11-21 11:21:05 +05:30
f23fe38e0b
Update release notes.
2024-11-21 10:59:08 +05:30
321366489d
Fixed an issue where query tool should show results and messages only from the last executed query. #8010
...
Fixed an issue where query tool should not prompt for unsaved changes when there are no changes. #8127
2024-11-21 10:52:43 +05:30
6d5b1673e6
Fix SonarQube code smells for PgTree directory.
2024-11-19 15:45:00 +05:30
8be65ceb7b
Fixed an issue related to the query tool update connection after the server disconnected from the object explorer. #7865
2024-11-19 15:44:40 +05:30
a8384a8826
Added new language Chinese (Traditional) and rename language code for Chinese (Simplified)
2024-11-19 14:20:25 +05:30
c5d5fbdafd
Fixed an issue where Ctrl/Cmd + A was not selecting all data in query tool data grid. #5099
2024-11-14 16:56:03 +05:30
9a8d520abd
Fix few issues found in menu rendering code and GUI test cases
2024-11-14 14:49:07 +05:30
296befc881
Code refactoring at multiple places to improve re-usability
2024-11-14 14:16:38 +05:30
00d3aaa1fd
Refactor menu building code to support sub-menus of any depth
2024-11-14 13:36:42 +05:30
0aba9703cd
Added support for a builtin locale provider in the Database dialog. #8095
2024-11-14 13:20:01 +05:30
040e988323
Schema Diff bug when comparing materialized views with indices: key 'indrelid' needs to be ignored.
2024-11-14 12:43:33 +05:30
606b5287be
Chinese (Simplified) translation for v8.14
2024-11-14 10:46:14 +05:30
b278265005
French translation for v8.13
2024-11-11 15:03:29 +05:30
f9d881ffa6
Fix GUI test cases failing because of previous commit
2024-11-08 18:09:39 +05:30
6fcc4ae6a2
More fixes for issues found while testing query tool pagination changes. #1780
2024-11-08 15:48:24 +05:30
67d3f14c3d
Italian translation for v8.13
2024-11-08 11:45:16 +05:30
173cfb72b2
Format dashboard graph metrics for better readability. #6016
2024-11-07 22:00:45 +05:30
2e61eb0990
Updated message catalogs for v8.13
2024-11-07 19:08:40 +05:30
3417186df7
Fix issues found while testing pagination changes. #1780
2024-11-07 18:02:39 +05:30
772c6ecd84
Remove the dependency on python packages eventlet and greenlet. #8102
2024-11-07 16:45:18 +05:30
b51eef12b7
Add an object menu option to disconnect all server and database connections. #1984
2024-11-06 15:52:31 +05:30
2f4cae35bd
Updated the react-menu library from v2 to v4. #8061
2024-10-30 17:08:24 +05:30
a9bfa8a71d
Fix multiple issues related to debugger params dialog input. #7883
...
- Handle multiple possible values for a boolean parameter.
- Disable value input when "Use default" is enabled.
2024-10-29 16:01:46 +05:30
898c7b27df
Fix the Jinja2 error for python 3.8.
2024-10-18 19:30:42 +05:30
4d7fc8be52
Resolved issues reported during testing of #7655 .
2024-10-18 13:05:59 +05:30
5d008f0525
Fixed an issue where the query tool was crashing when an empty geometry was being rendered. #7655
2024-10-17 14:13:40 +05:30
b0d4200aa0
Few UX improvements in query tool pagination. #1780
2024-10-15 16:25:39 +05:30
2cc8f5f272
Ensure server connection is successful for sslrootcert=system in server configuration. #7907
2024-10-14 16:17:46 +05:30
9be0fef470
Indonesian translation for version 8.13
2024-10-14 11:33:52 +05:30
b4759e776e
French translation for version 8.13
2024-10-14 11:29:28 +05:30
1d8dfc110e
Italian translation for version 8.13
2024-10-14 11:23:47 +05:30
6ed615a1fc
Czech translation for version 8.13
2024-10-14 11:23:19 +05:30
7d12dc3b80
Remove unused variable from Debugger.
2024-10-10 17:54:15 +05:30
72a102aac8
Update message catalog for v8.13
2024-10-10 17:51:59 +05:30
7a7782a350
Fixed an issue in the debugger where function arguments of the character data type were being truncated. #8007
2024-10-10 15:25:08 +05:30
b649094d36
Fix the issue where rows do not retain shading when scrolling. #8013
2024-10-10 15:19:24 +05:30
8c45dea975
Fixed an issue where graphical explain keeps the node details open even after plan changed. #7993
2024-10-10 10:50:11 +05:30
509c696aa3
Fixed an issue where the copy shortcut was not working in the Query Tool data grid. #7920
2024-10-09 17:06:51 +05:30
9169d3d4bf
Fixed an issue where cursor selection is not visible in the PSQL tool. #7957
2024-10-09 14:42:30 +05:30
6cccb5da31
Fixed an issue where Dashboard tab showing 'Something went wrong'. #7955
2024-10-07 11:41:27 +05:30
6c3f0a4606
1) Updated French Translation.
...
2) Updated release note.
2024-10-04 12:26:37 +05:30
d736f4266c
Fixed an issue where default EOL in the query tool should be based on the OS. #7393
2024-10-03 17:29:58 +05:30
c6d7a0a8da
Add missing eslint React rules and fix the linter errors.
2024-10-01 16:32:04 +05:30
6322674d98
Replace infinite scrolling with pagination in query tool data output for better UX and performance. #1780
2024-10-01 14:47:12 +05:30
f8fb78be11
1) Alternate the background color of rows to enhance readability. #2874
...
2) Make the background color for the serial number and header cells distinct. #7863
2024-10-01 12:21:44 +05:30
15c37b620e
Fixed issues reported in #7958
...
* Fixed issues reported in #7954
- Search wasn't working as we were using the wrong row-index, while
rendering it.
- Fixed the CSS issue with the alignment of the search input box.
- Pass the row object while rendering the 'DataRow' component, to
improve the performance as it repeatedly calls the filtering function for each row.
- Changed the order of the validators on a field to prioritize the
'empty' string validator over the unique-id validator in a
collection.
- Use 'row.index' instead of rowId, while rendering a grid row
2024-10-01 12:06:59 +05:30
535c7eeef8
Fixed an issue where the dock layout was not saved upon closing a tab. #7919
2024-09-27 16:22:48 +05:30
f0ecc95ca9
Fixed an issue to allow the Enter key to save data in the result grid text editor. #5307
2024-09-27 12:18:07 +05:30
0e63914ab3
Fixed an issue where the copy shortcut CTRL +C was not working in the Query Tool data grid. #7920
2024-09-27 12:17:21 +05:30
9b64acb3d2
Allow OAuth2 params OAUTH2_NAME, OAUTH2_DISPLAY_NAME, OAUTH2_ICON, OAUTH2_BUTTON_COLOR to be optional. #7965
2024-09-27 10:35:21 +05:30
4cb0f87dfd
Added support for auto-detecting and setting the End-of-line character (LF/CRLF) in the query tool editor. #7393
2024-09-24 16:39:08 +05:30
fa64e8b38f
Fixed an issue where role properties were not loading. #7837
2024-09-24 11:59:05 +05:30
a0aa185518
Fixed a security issue where the OAuth2 client ID and secret exposed through the web browser (CVE-2024-9014). #7945
2024-09-20 08:45:37 +05:30
1f53baee8f
Fixed the dynamic column updation in the Unique & Primary Keys while creating a table.
...
* Updated the columns for the unique and primary keys while creating a table.
Use the 'editable' option for a Cell instead of 'disabled'.
* Don't need to define the hidden member as fields in GridHeaderSchema
* Updated the columns for the exclusion constraints while creating a
table.
* Signaled the relevant field, when column options have changed, for all
the children of a table.
* Use current snapshot of data for the GrigFormHeadeer
* Fixed the styling for the search input box
* Don't check for the 'colOptions.editable' flag, as it could be
indirect call as well.
2024-09-19 18:57:09 +05:30
6a79d0a195
Russian translation for version 8.12
2024-09-19 18:54:38 +05:30
8fd5efaa84
Make sure ALLOW_SPECIAL_EMAIL_DOMAINS should also work for pgAdmin docker apps. #6222
2024-09-19 14:03:43 +05:30
53cdc80df2
Add a new config variable - ALLOW_SPECIAL_EMAIL_DOMAINS to allow special domains for pgAdmin user emails. #6222
2024-09-19 10:51:06 +05:30
38d4728333
Fixed an issue where the query is not getting executed after giving a password and connecting to the server on the not saved password server. #6502
2024-09-18 20:55:29 +05:30
b0cd028ff8
Fixed an issue introduced due to reloading of the tree due to changes in particular preferences ( #7942 )
...
* Fix an issue - when the object browser tree is being recreated due to reloading for changes in some of the preferences. Tree object returns object from the previous instance as 'selected', but - it does not have the 'treeNodeInfo' available. In this special case - we would consider that there is no node selected at that particular moment, and pass information accordingly.
* Fixed 'New Connection' dialog issue after connecting a disconnected server.
* Disable the 'Add' button in the GridHeader with form, when 'canAdd'
flag is set to false.
* Convert the access path to string array for correct comparision.
* Check the access path type before comparison.
When language is 'c', set the 'code' block read-only.
* Enabled 'Strict' control for EPAS >= 95
2024-09-18 20:55:01 +05:30
100f59f78b
Fixed an issue where "Quit App" confirmation modal in desktop app is not respecting "Confirm on close or refresh?". #7890
2024-09-18 16:43:57 +05:30
23ea201325
Fixed an issue where graph visualizer pie chart was showing X axis, Y axis and grid lines.
2024-09-18 15:07:29 +05:30
441cc57bb8
Don't show 'Types of objects' for the 'Cluster' operation. Fixes #7884
2024-09-18 07:48:09 +05:30
a361fd94ff
Fixed an issue where the query gets executed automatically when the query tool opened using Create Script, Schema Diff.
2024-09-18 07:47:20 +05:30
315d1a40a4
Fixes issues #7884
...
* Introduced a 'exclude' option in the 'Field' to exclude it from the
change completely. Use the option 'exclude' to add field
'notNullColumns', which will be excluded from the data, but - can be
used to force rerender the 'Not Null Columns' select control on
change of it.
* Fixed the linter issue
* Rerender the cell as well, when dependent changes values. (#7884 )
* Listen for the depenent changes even for the non-visible controls
* Use 'useRef' on every rendering to avoid the React 'Something wrong' page
2024-09-16 17:55:43 +05:30
92dd13e72a
Introduced a 'exclude' option in the 'Field' to exclude it from the change.
...
* Introduced a 'exclude' option in the 'Field' to exclude it from the
change completely. Use the option 'exclude' to add field
'notNullColumns', which will be excluded from the data, but - can be
used to force rerender the 'Not Null Columns' select control on
change of it.
* Fixed the linter issue
2024-09-16 15:28:33 +05:30
0d39e791c9
Fixed the import-export 'Not null columns' and User Management issue #7884
2024-09-16 13:12:41 +05:30
53760dbf59
Fixed tree related issues.
2024-09-16 10:09:28 +05:30
dd6f6cf1af
Support OIDC in OAuth2 authentication. #7839
2024-09-16 08:36:54 +05:30
5e96f0fd61
Fixes the Variable Schema UI issues and InlineView bug reported in #7884
...
* Show the icon for the 'Reset' button. (Reference #7884 )
* Reload the server list after connecting to a server in the 'New
connection' dialog (QueryTool). (Reference: #7884 )
* Pass the grid path during the bulk update (click on a radio action)
* Don't assign the cell value to the 'rowValue' variable.
* Don't rely on the 'optionsLoaded' for setting the variable types as it
is loaded asynchronously, and variable types data may not be available
while rendering the 'value' cell. (Fixes #7884 )
* Fixed a type while checking for the 'inline-group'. fixes (#7884 )
* 'vnameOptions' can be a Promise function too, hence - taken care accrodingly.
* Introduced a parameter 'reloadOnDepChanges' in the BaseSchemaUI field
to force reload the control on value change for one of the
dependencies.
* Reload on the components in case of dependent value changes.
* Introduced 'useSchemaStateSubscriber', which generates a state
subscriber mananager instance. It helps multiple subscribers in a
single control as we could have multiple subscribe within a control.
(For example - value, options, errors, etc).
* Fixed all the issues reported (#7884 )
2024-09-16 00:04:37 +05:30
98d703645c
Italian translation for version 8.12
2024-09-16 00:02:41 +05:30
cead7b0a6f
Czech translation for version 8.12
2024-09-15 23:59:23 +05:30
139d9e21da
Update message catalogs for v8.12
2024-09-12 18:34:49 +05:30
ed211a2bbb
Fixed an issue where servers listed in the servers.json file were being reimported upon container restart. #7811
2024-09-11 13:06:31 +05:30
e21911b1c6
All the issues are fixed reported in #7884
...
* Show the icon for the 'Reset' button. (Reference #7884 )
* Reload the server list after connecting to a server in the 'New
connection' dialog (QueryTool). (Reference: #7884 )
* Pass the grid path during the bulk update (click on a radio action)
* Don't assign the cell value to the 'rowValue' variable.
2024-09-11 12:21:41 +05:30
d3d1eb3355
Fixed issue of migrating tunnel password with new master password mechanism. #7076
2024-09-09 17:38:22 +05:30
e9af0c3226
Improved the extendability of the SchemaView and DataGridView. ( #7876 )
...
Restructured these modules for ease of maintenance and apply the single
responsibility principle (wherever applicable).
* SchemaView
- Split the code based on the functionality and responsibility.
- Introduced a new View 'InlineView' instead of using the
'nextInline' configuration of the fields to have a better, and
manageable view.
- Using the separate class 'SchemaState' for managing the data and
states of the SchemaView (separated from the 'useSchemaState'
custom hook).
- Introduced three new custom hooks 'useFieldValue',
'useFieldOptions', 'useFieldError' for the individual control to
use for each Schema Field.
- Don't pass value as the parameter props, and let the
'useFieldValue' and other custom hooks to decide, whether to
rerender the control itself or the whole dialog/view. (single
responsibility principle)
- Introduced a new data store with a subscription facility.
- Moving the field metadata (option) evaluation to a separate place
for better management, and each option can be defined for a
particular kind of field (for example - collection, row, cell,
general, etc).
- Allow to provide custom control for all kind of Schema field.
* DataGridView
- Same as SchemaView, split the DataGridView call into smaller,
manageable chunks. (For example - grid, row, mappedCell, etc).
- Use context based approach for providing the row and table data
instead of passing them as parameters to every component
separately.
- Have a facility to extend this feature separately in future.
(for example - selectable cell, column grouping, etc.)
- Separated the features like deletable, editable, reorder,
expandable etc. cells using the above feature support.
- Added ability to provide the CustomHeader, and CustomRow through the
Schema field, which will extend the ability to customize better.
- Removed the 'DataGridViewWithHeaderForm' as it has been achieved
through providing 'CustomHeader', and also introduced
'DataGridFormHeader' (a custom header) to achieve the same feature
as 'DataGridViewWithHeaderForm'.
2024-09-09 14:27:31 +05:30
e5012ea9c6
Add debug logs to observe the OpenID token response.
2024-09-04 19:46:40 +05:30
306269af5d
Fix issues found while testing keyring changes. #7076
2024-09-02 19:32:25 +05:30
8bae604129
Fix the query tool restore connection issue on the server disconnection from the left side object explorer. #6502
2024-09-02 15:06:11 +05:30
f88ca891fa
Added feature to restore preferences to their default values. #1900
2024-08-30 12:24:24 +05:30
445e89576b
Fixed an issue where users could not use pgAdmin if they did not have access to the management database. #7571
2024-08-30 12:13:47 +05:30
1a1734cf5c
Allow running non-continuous selected SQL code blocks in the query tool. #7293
2024-08-29 12:41:58 +05:30
c4dc839d7c
Fix issue found while testing keyring related changes. #7076
2024-08-28 11:46:04 +05:30
5bdff56b8d
Italian translation update for v8.12
2024-08-23 10:41:48 +05:30
47fcf87ae4
Update JS and Python packages
2024-08-22 17:20:50 +05:30
1257ec9969
Revamp the current password saving implementation to keyring and reducing repeated OS user password prompts. #7076
...
The new implementation will store the master password in the keyring instead of storing each and every server password separately. The master password will be used to encrypt/decrypt server password when storing in the pgAdmin config DB.
2024-08-22 16:44:57 +05:30
9f8acfc51d
Czech translation for version 8.11
2024-08-19 15:07:19 +05:30
8cf316b853
Fixed some of the issues reported due to introduction of the custom hook 'useSchemaState'. #7776
2024-08-19 09:53:00 +05:30
55817f685f
Updated message catalogs for v8.11
2024-08-15 21:36:39 +05:30
35d585251a
Upgrade xterm realted packages to the latest @xterm based namespace.
2024-08-14 18:15:03 +05:30
242dd48cbd
Improve code highlighting in query editor. #7748
2024-08-14 16:48:51 +05:30
c0b6c8726e
Add a home button to the geometry viewer to set original zoom level when the viewer was opened. #2046
2024-08-14 11:09:28 +05:30
52c550e3fe
Fix an issue where ERD tool should to be able to open saved pgerd file when using keyboard shortcuts. #7688
2024-08-13 14:30:58 +05:30
57e72ce598
Fixed bugs found when testing react-data-grid upgrade changes. #7705
2024-08-13 13:00:52 +05:30
fb0022923a
Fix import Export Server loading issue, affected due to SchemaView component changes.
2024-08-12 11:27:21 +05:30
00e2480b7b
1) Fixed an issue where refreshing the Schema Diff tool opened in a new tab caused an error. #7499
...
2) Fixed an issue where the Generate Script ignored filter conditions when a parent node was selected. #7682
2024-08-08 13:02:38 +05:30
81d8ea56f8
Fix server heartbeat logging error after deleting the server. #7540
2024-08-07 14:32:48 +05:30
654dc0e2d7
Fixed an issue where the value in the find box is not updating with selected text in editor if find is already open and re-triggered. #7775
2024-08-06 11:59:22 +05:30
52af8d3e49
Introduce custom React Hook useSchemaState to simplify SchemaView component. #7776
...
Changes include:
- Simplify current SchemaView code
- Add ability to reuse the schema data & state management implementation outside the SchemaDialogView component.
- Further split components in small and manageable separate files.
- Removed the 'DepListenerContext' context as there was no need for separate context.
- Added a reload functionality in the 'useSchemaState'
- Changes in feature tests.
2024-08-02 09:59:01 +05:30
5d7ec14076
Fixed delete object(shortcut key) affecting both text and Object Explorer items. #7683
2024-08-01 11:48:16 +05:30
2e878a3fb2
Fixed an issue where the REVOKE statement in the create script was throwing an error if the role contained special characters. #7737
2024-08-01 11:34:00 +05:30
c6e7ce03cc
Upgrade react-data-grid fork to latest and change pgAdmin accordingly. #7705
2024-07-31 19:12:36 +05:30
c45fb47b08
Make PgTreeView react component more customisable
2024-07-31 14:07:47 +05:30
19237fe247
Fixed an issue where delete object(shortcut key) affecting both text and Object Explorer items. #7683
2024-07-31 11:25:08 +05:30
5fd308aafc
Show OS name and version details in about dialog for Linux platforms.
2024-07-25 17:51:31 +05:30
1fcb1f0228
Fix Dashboard UI issues.
2024-07-25 12:43:02 +05:30
1d5f5a2067
Fixed an issue where ERD Open/Save shorcuts were not working on Windows/Linux. #7639
2024-07-24 15:11:05 +05:30
70a7c42be1
Set the MFA OTP field to be a normal textbox to eliminate the save password prompt.
2024-07-24 15:00:27 +05:30
d0e6090761
Fix Dashboard State refresh issue with the active sessions only.
2024-07-24 13:45:52 +05:30
87ba177ff3
Fixed linter error.
2024-07-24 13:02:46 +05:30
0511554db9
The following issues have been fixed:
...
1) White screen issue after closing the Macro dialog.
2) Schema Diff database and schema selection issue.
3) CSV download issue.
2024-07-24 12:54:20 +05:30
026292f07b
Fix tab focus issue when closing query tool using keyboard shortcut. #6572
2024-07-23 17:02:39 +05:30
3aedae1436
Call loadNextPage function only when it is required while loading the table.
2024-07-22 14:15:03 +05:30
b173fda116
Fix tab focus issue while deleting multiple tabs using shortcut key. #6572
2024-07-22 11:32:26 +05:30
d9ccef94a2
Czech translation for version 8.10
2024-07-22 11:20:35 +05:30
eff63931f2
Update message catalogs.
2024-07-19 15:23:19 +05:30
3ec676194b
Fixed an issue where boolean values in node details of graphical explain plan were not interpreted correctly. #7662
2024-07-18 17:59:58 +05:30
8030bc708b
Add support for highlighting selection matches in the query editor. #7530
2024-07-18 17:51:20 +05:30
bfcdcdc4f1
Add a precautionary check for the query tool connection cursor to fix the error 'NoneType' object has no attribute '_query'. #7660
2024-07-18 14:24:50 +05:30
a75273a714
Updated entrypoint.sh to utilize the email-validator package for email validation. #7297
2024-07-18 11:05:37 +05:30
c9cc5257c7
Fix Server Log minor UI issues.
2024-07-18 09:40:49 +05:30
9ee896aac4
Add a keyboard shortcut to close active tab panel. #6572
2024-07-17 18:19:36 +05:30
1eb07608e9
Ensure processes related notifiers disappears. #7219
2024-07-17 13:07:52 +05:30
8e16e000c3
Fix issues found in electron testing. #7494
2024-07-16 20:29:10 +05:30
e028ebc152
Ensure pgadmin does not try to connect to the server if saved password is not available. #7679
2024-07-16 17:46:40 +05:30
30051f3257
Fixed an issue where Reassign/Drop Owned dialog not opening for Role. #7663
2024-07-16 17:42:16 +05:30
c4a52687b6
Ensure that pgAdmin works when opened in an iframe. #7681
2024-07-16 16:32:52 +05:30
a06c13623d
Fixed an issue where theme preview under theme options was broken in pgAdmin server mode. #7626
2024-07-16 10:25:48 +05:30
b303693ae8
Fix Dashboard minor UI issues.
...
Fix the issue where PG logs doesn't display in CSV or JSON format even if it gets selected through the UI.
2024-07-11 10:26:42 +05:30
6b012193e3
Pin Psycopg Binary packages to 3.1.19 for the ARM64 MacOS platform wheel packages.
2024-07-10 17:43:13 +05:30
cd6ff48cc0
Fix query tool, ERD closing issue in Electron. #7494
2024-07-10 15:01:35 +05:30
dbdea181a9
Fixed an issue where pop-up notifications from Object Explorer wouldn't get dismissed automatically if the Query Tool was opened. #6571
2024-07-09 16:25:04 +05:30
721a5da895
Fixed an issue where Generate Script button should be disabled if no objects are selected in the schema diff result. #7638
2024-07-09 13:44:04 +05:30
5c5b61c4db
Fixed an issue where paste operation in query tool data grid should skip bytea columns and put the value as NULL instead. #3199
2024-07-09 10:33:29 +05:30
760e38293c
Fix issues found during Electron testing. #7494
...
Fix application crash when using users dialog. #7607
2024-07-08 19:24:29 +05:30
dcfef154ce
- Set the browser target to ES6 and reduce the JS bundle size considerably
...
- Upgrade ESLint to v9.x and migrate the .eslintrc.js file to make it work
2024-07-04 18:25:47 +05:30
10b2e91e29
Update react-diagrams library which is used in ERD to the latest version. #7644
...
Added patch for DataGridView failing when adding a new row.
2024-07-03 18:19:27 +05:30
4f415f9768
Added support for viewing PostgreSQL Server Logs in Text, CSV and JSON formats. #3981
2024-07-03 16:17:29 +05:30
22cdb86aab
Fix issue with missing new added records in download file. #5345
2024-07-02 11:48:13 +05:30
576dc55615
Fixed the permission denied issue for functions of the pgstattuple extension when accessing statistics with a non-admin user. #7035
2024-07-02 11:47:43 +05:30
f8fa1cf6d6
- Fix few SonarQube issues.
...
- Cleanup NW.js related stuff.
2024-07-02 10:34:30 +05:30
3bb9f0ba8c
Remove support for Python 3.7 as Debian 10 is EOL.
2024-07-01 12:39:12 +05:30
91eb60a363
Replace pgAdmin NW.js container with Electron container. #7494
2024-07-01 11:27:42 +05:30
4457a6a6a1
Updated to the latest version of the Notistack library. #7501
2024-07-01 11:26:45 +05:30
391db5131d
Fixed an issue where sorting the database activity table on the dashboard by any column caused the details to expand in the wrong position. #7554
2024-06-28 14:47:26 +05:30
62a61b403e
Fixed an issue where users could not autofill their saved passwords in the connect server dialog in the browser. #7627
2024-06-28 14:44:39 +05:30
feb3093c6d
Automatically apply virtualization in the DataGridView of SchemaView if the schema contains only one collection. #7607
2024-06-27 13:21:18 +05:30
6f96f67655
Add the git commit hash details to the About dialog. #7623
2024-06-27 13:20:00 +05:30
3be2221948
Ensure that pgAdmin 4 is compatible with PostgreSQL v17. #7537
2024-06-27 13:18:26 +05:30
7d0bbf30ec
Fixed the issue causing the 2FA dialog to appear distorted.
2024-06-25 14:46:30 +05:30
19f5e41b09
Czech translation for version 8.9
2024-06-24 11:55:52 +05:30
a8f0f5bb4f
Fix one more styling issue broken due to JSS changes. #7363
2024-06-24 10:44:05 +05:30
44d40f0785
Fixed an issue where delete button in Users data was enabled for incorrect rows. #7616
2024-06-24 10:31:47 +05:30
d0b2752fea
Italian translation updated for v8.9
2024-06-21 13:14:48 +05:30
8e0c080faf
Update message catalogs for v8.9
2024-06-20 18:12:16 +05:30
6410ae5f69
Fixed some more styling issues broken due to JSS changes. #7363
2024-06-20 17:18:38 +05:30
3e7a220225
Fixed an issue where the schema diff incorrectly marked tables as different due to schema-qualified trigger functions in the trigger definitions. #7523
2024-06-20 16:55:38 +05:30
9026f46220
Fixed an issue where object explorer toolbar button not showing shortcut in the tooltip.#7316
2024-06-20 11:31:11 +05:30
fedbe550db
Optimise logic used for OS theme syncing. #5932
2024-06-20 11:05:47 +05:30
31a91409a0
Fixed incorrect sorting of size in statistics tab. #7542
2024-06-19 18:27:43 +05:30
9279393dcd
Add missing files from last commit. #7593
2024-06-19 17:57:34 +05:30
6984e97f8d
Use correct for loop syntax.
2024-06-19 13:15:45 +05:30
95ffd1b9a1
More fixes for issues reported while testing changes related to makeStyle JSS changes and auto-theme. #7363
2024-06-19 11:54:18 +05:30
0452828cc7
1) Change the cursor to a pointer for JSON editor toolbar buttons.
...
2) Remove the extra scrollbar in JSON editor.
3) Set the focus on the PSQL tool.
2024-06-18 16:42:17 +05:30
2b04f3ca1d
Fixed incorrect handling of the code smell for the reject API call
2024-06-17 18:22:38 +05:30
1ba9f005a7
Ensure that user should be able to clear comments in RLS Policy.
2024-06-17 18:11:57 +05:30
439d6cb28f
Fixed an issue where backslash breaks syntax highlighting. #7528
2024-06-17 16:16:15 +05:30
b0e7847962
Fixed bugs found while testing makeStyles JSS changes. #7363
2024-06-17 15:45:40 +05:30
a946c70869
Fixed an issue where changing a column name should reflect in all the constraints in table object dialog and ERD table dialog. #7476
2024-06-17 14:07:45 +05:30
5866da8194
Fixed SonarQube code smells.
2024-06-13 18:48:02 +05:30
ad34ee2699
Fixed new line indentation in query editor and add a user preference to disable it. #7295
2024-06-13 18:06:13 +05:30
e03d65d547
Fixed an issue where query tool shortcuts for find/replace are not working. #7555
2024-06-13 17:26:47 +05:30
b5c8692f34
Fixed an issue where resizable data editors in query tool should not be allowed to resize beyond the app window bounds. #7241
2024-06-13 14:07:44 +05:30
ab01dde2ba
Fixed RESQL test case.
2024-06-12 18:46:12 +05:30
dea5335ce5
Fixed the following SonarQube code smells:
...
1) Do not use the Array index in keys.
2) Import from the same module should be merged.
3) Mutable variables should not be exported.
4) Variables should not be initialized to undefined.
5) startswith or endswith method should be used.
6) Unwrap this unnecessarily grouped subpattern.
Additionally, addressed many other SonarQube rules.
2024-06-12 18:09:06 +05:30
288fd7ed12
Add support for comments on RLS policy object. #7414
2024-06-12 17:18:55 +05:30
c98cea2ea9
Search Objects dialog should focus on search input on open. #7536
2024-06-12 17:17:35 +05:30
056aff4742
Revert the changes done for removing support for Python 3.7
2024-06-12 16:23:27 +05:30
6357672387
Provide an option to set the theme based on the OS theme. #5932
2024-06-12 16:18:37 +05:30
df2f3460f0
Fix the following SonarQube code smells:
...
1) Use the "RegExp.exec()" method instead.
2) Remove parameter form or provide default value.
3) Extract this nested ternary operation into an independent statement.
4) Replace this character class by the character itself.
5) Unnecessary use of conditional expression for default assignment.
6) Prefer using an optional chain expression instead, as it's more concise and easier to read.
2024-06-11 18:07:22 +05:30
fff192eb95
Ensure that a user can connect to a server using SSL certificates and identity files from a shared storage. #7306
2024-06-11 14:48:11 +05:30
c47390e643
Fixed API test cases for BatchProcess
2024-06-11 12:59:48 +05:30
fd944280f1
Fixed an issue where dark theme shows white background when all tabs are closed. #7481
2024-06-11 12:03:43 +05:30
8857f0d179
Fix SonarQube code smells:
...
1) String literals should not be duplicated.
2) Prefer using an optional chain expression instead, as it's more concise and easier to read.
3) Expected the Promise rejection reason to be an Error.
2024-06-10 18:04:32 +05:30
285e3afeee
Indonesian translation for version 8.9
...
* Added translation using Weblate (Indonesian)
* Added translation using Weblate (Indonesian)
* Translated using Weblate (Indonesian)
---------
Co-authored-by: Weblate Admin <admin@example.com>
2024-06-10 11:33:03 +05:30
de712b0805
- Update JS packages.
...
- Remove support for Python 3.7 as Debian 10 is EOL.
2024-06-07 14:17:22 +05:30
85d4473af4
Disable the query tool editor input if any SQL is being loaded to prevent users from typing. #6357
2024-06-06 18:06:49 +05:30
cc999ae5a5
Remove the usage of MUI makeStyles as it doesn't support React 18. #7363
2024-06-06 17:13:12 +05:30
f66bd4bcfb
Remove the use of is_normalized function for Python 3.7.
2024-06-05 14:11:59 +05:30
a46f99d360
1) Partially fixed the issue with inserting characters at the end of the line by setting 'Underline query at cursor?' to false by default.
...
2) Update release note.
2024-06-04 18:18:16 +05:30
29a526626f
Fixed an issue where the size displayed as 'NaN B' for all databases in the statistics tab. #7524
2024-06-03 17:10:11 +05:30
24aefd2c7a
Fix an issue where user authentication fails with special characters in password. #5785
2024-05-31 11:22:36 +05:30
b5b0538fe3
Fixed an issue where canceling a query without privilege does not display any message on query tool. #7480
2024-05-31 11:19:44 +05:30
2ab2d6b57c
Fix the issue where the query tool documentation screen-shot displays the incorrect function key. #7507
2024-05-28 12:10:14 +05:30
6690b16f8a
Added support for executing the query at the cursor position in the query tool. #6841
2024-05-27 16:11:59 +05:30
16b9b103a2
Resolved the intermittent issue with macros not displaying in the macros dialog.
2024-05-27 15:56:02 +05:30
b1f70b02ff
Update object explorer icons for EPAS and replication related nodes
2024-05-27 12:29:38 +05:30
2a1394ce1f
Italian translation updated for v8.7
2024-05-27 11:24:51 +05:30
4e3ec91d23
Added support for the 'Add to macros' feature and fixed various usability issues. #4735
2024-05-24 15:30:31 +05:30
36a71dc7fa
1. Fixed an issue where resetting the password from the password reset link was not working. #7500
...
2. Fixed an issue where the recover password button was enabled even when no email id was provided. #7487
2024-05-24 13:18:05 +05:30
57e1dfa7ec
Update message catalogs for v8.7
2024-05-23 18:47:54 +05:30
5c30695d66
Fixed Typos
2024-05-23 12:52:41 +05:30
6c7bc1c815
Ensure that Schema Diff does not indicate a table as different when the trigger names are the same but the trigger function body is different. #5762
2024-05-21 16:04:25 +05:30
dd45f06d50
Added support for viewing PGD Clusters. #7215
2024-05-20 16:54:49 +05:30
d6a9f8a06c
Fixed issues found in testing of react-table upgrade changes. #7419
...
UI fixes and improvement in System Stats Dashboard.
2024-05-20 10:41:55 +05:30
9647482791
Fixed incorrect highlighting for C-Style escape strings in SQL editor. #7485
2024-05-20 10:13:30 +05:30
b9088b0afa
Use index as a key for the table header group in PgReactTableStyled component. #7419
2024-05-15 17:06:45 +05:30
1c44cfb714
Update the documentation for preferences dialog and keyboard shortcuts. #7349 , #7458
2024-05-15 15:21:23 +05:30
0e786c519e
Replace the current FontAwesome based PSQL tool icon with MUI Terminal icon. #7472
2024-05-14 11:05:27 +05:30
3b20cad5bb
Fixed an issue where drag and drop publication and subscription name in SQL editors was not working. #6086
2024-05-09 15:34:44 +05:30
afc28d95cf
1. Disable ERD for system Catalogs. #5849
...
2. Disable Debugger for system catalogs. #6060
3. Fixed an issue where the keyboard shortcut for launching the debugger from Object Explorer was not working.
2024-05-08 15:29:01 +05:30
5ec6faff13
Upgrade react-table from v7 to v8. #7419
2024-05-07 16:31:04 +05:30
3e6bd29198
Enhance the Delete dialog by highlighting the names of the objects to be deleted in bold. #7411
2024-05-07 11:56:50 +05:30
b85d8c1446
Changes in Query Tool, Debugger, and ERD Tool shortcuts to remove the use of Accesskey which will allow them to be customized. #7192
2024-05-06 11:15:44 +05:30
f4761f55f7
Fixed Multi-Factor Authentication bypass vulnerability (CVE-2024-4215). #7425
2024-04-29 13:41:02 +05:30
e18a8bf620
Fixed issue found during testing of #7163 .
2024-04-29 13:12:21 +05:30
7c6fdcb12e
Disabled auto-fill on password fields. #2410
2024-04-29 11:44:17 +05:30
f88c89f3eb
Fixed an issue when closing the materialized view data second tab; it raises the error that the 'MViewCommand' object has no attribute 'auto_commit'.
2024-04-26 15:53:15 +05:30
5949696ded
Italian translation updated for v8.6
2024-04-26 14:43:17 +05:30
f724578463
Fixed API test cases for exec/call procedure.
2024-04-26 13:01:35 +05:30
2324337149
Trigger the browser tree destroyed event so the consequences of destroying the tree are handled properly.
2024-04-26 11:59:53 +05:30
2dd009eb7c
Update message catalogs for version 8.6
2024-04-25 18:03:28 +05:30
92bb931b0a
Fixed an issue where incorrect select/exec scripts were generated for functions/procedures. #7334
2024-04-25 17:24:02 +05:30
10ba029980
Fixed an issue where connection to the database is not automatically re-established after connectivity drop. #7372
2024-04-24 14:37:33 +05:30
fd65f1b644
Fixed all input boxes in pgAdmin to show browser auto-fill only where it is relevant. #2410
2024-04-24 11:27:08 +05:30
9f6ddd3cf9
Fixed violates check constraint issue when creating a pgAgent schedule. #7390
2024-04-23 17:27:11 +05:30
673b5ea5a1
Fix the date-time picker broken after MUI5 upgrade.
2024-04-23 17:03:34 +05:30
84c024f6fa
Fixed an issue when closing the view data second tab; it raises the error that the 'ViewCommand' object has no attribute 'auto_commit'. #7384
2024-04-23 14:45:15 +05:30
3e0ade5a59
Fixed an issue where pressing backspace should remove the spaces and not the entire tab width, on enabling 'Use spaces?' in the preferences. #7317
2024-04-22 12:33:38 +05:30
f0185fbe7f
Fix issues reported while testing MUI5 library update.
2024-04-17 17:31:55 +05:30
0d1e3f36e1
Revert "Fixed an issue where function arguments were getting enclosed in double quotes if written in upper case. #7222"
...
This reverts commit fc4b419987
2024-04-17 11:33:25 +05:30
29ccdb3242
Fixed an issue where debugger was not scrolling automatically on stepping. #7275
2024-04-16 15:33:42 +05:30
5ee403fec7
Upgraded Flask, Flask-Security-Too, Werkzeug, and other dependencies, ensuring compatibility with Python 3.7. #7362
2024-04-16 12:23:03 +05:30
5a3fa59741
Fix id_token KeyError on OAuth2 logout.
2024-04-16 12:19:06 +05:30
f143aa05a3
Added support for excluding multiple tables while taking Backup. #7163
2024-04-15 11:50:08 +05:30
ee0687ecd3
Add a function getQueryAt to get the SQL query at given cursor position from a CodeMirror input
2024-04-13 15:47:18 +05:30
e384c9665a
Fixed a XSS vulnerability in the /settings/store endpoint. #7282
2024-04-10 17:58:51 +05:30
30d2d1b23e
Fixed the following code smells:
...
1) useState call is not destructured into value + setter pair.
2) A fragment with only one child is redundant.
3) Unnecessary '.apply()' and '.call()'.
4) Expected the Promise rejection reason to be an Error.
2024-04-09 19:18:56 +05:30
102e0a9839
- Update MUI v4 to v5
...
- Remove the SCSS dependency completely and use MUI for theming.
- Update - date-fns, @date-io, notistack. Remove - popper.js, sass-loader.
- Cleanup webpack config.
- Port PSQL tool to use MUI themes instead of SCSS theme.
- Theme change will reflect realtime without refreshing pgAdmin.
2024-04-09 08:21:14 +05:30
edec9adbfb
Fixed SonarQube code smell 'Unnecessary use of boolean literals in conditional expression'.
2024-04-08 17:19:51 +05:30
c9345ad618
Fixed an issue where double dollar quoted code is treated as string in syntax highlighter. #7294
2024-04-08 15:32:01 +05:30
fc4b419987
Fixed an issue where function arguments were getting enclosed in double quotes if written in upper case. #7222
2024-04-04 16:48:00 +05:30
475e3689f7
Added the new columns last_seq_scan and last_idx_scan from the pg_stat_all_tables and pg_stat_all_indexes tables respectively to the Statistics tab. #6728
2024-04-04 16:39:12 +05:30
a85d907351
Fixed an issue where user was unable to share a newly registered server. #7111
...
* Fixed an issue where the clear SSH tunnel password option was disabled in desktop mode.
2024-04-01 16:57:47 +05:30
9f31ec115a
Fixed Schema Diff issues while comparing Materialized View. #7271
2024-04-01 16:56:18 +05:30
fbbbfe22dd
Fixed a remote code execution issue in the validate binary path (CVE-2024-3116). #7326
2024-04-01 11:34:01 +05:30
26b279cc8a
Czech translation for version 8.5
2024-04-01 11:09:48 +05:30
3ac271e702
Italian translation update for v8.5
2024-03-29 11:41:44 +05:30
4ae9132b59
Fixed an issue with empty locale provider while editing collation. #5611
2024-03-29 11:40:44 +05:30
3fa48f26b8
Update message catalogs for v8.5
2024-03-28 17:58:24 +05:30
00e17ef152
Fixed an issue where the 'Save Password' option for SSH tunneling password was consistently disabled. #7139
2024-03-28 13:58:03 +05:30
ace73ebb60
Added support for viewing Log Based Clusters. #7216
...
Co-authored-by: Akshay Joshi <akshay.joshi@enterprisedb.com>
2024-03-28 12:19:34 +05:30
5931162556
Fixed an issue where maximize icon is missing from query tool panel. #7218
2024-03-28 11:53:56 +05:30
053b1e3d69
Fixed issues in create collation. #5611
2024-03-27 17:30:16 +05:30
082fb165d3
Implemented shortcut mapping for the edit menu in the query tool.
2024-03-27 16:41:08 +05:30
a02ebe192b
Fixed rollback and commit button activation on execute button click. #7248
2024-03-27 16:38:42 +05:30
8ab78dc40d
Fixed an issue where serial, bigserial, and smallserial columns were always shown as different in the schema diff.
2024-03-27 16:11:40 +05:30
b742487dc3
Fixed an issue where table properties were not updating from properties dialog. #7210
2024-03-27 11:41:01 +05:30
089f890f2e
Fixed an issue where Triggers, Rules, Indexes were absent from the Schema Diff when comparing views. #7271
...
Fixed an issue in Schema Diff where Columns with sequences get altered unnecessarily. #4413
2024-03-27 11:40:23 +05:30
1bcf343ceb
Fixed an issue where taking backup of a shared server was using server owner's user name. #7255
2024-03-26 11:28:20 +05:30
e99fc02f9e
Fixed issue related to email authentication of Two-factor authentication. #7308
2024-03-26 11:27:35 +05:30
c0a1429664
Fix failing feature tests
2024-03-26 11:20:04 +05:30
cc1ce09b73
More CodeMirror fixes. #7268
...
Fix query tool autocomplete results when cursor is in between the SQL query. #7299
Fix an issue in query tool where custom keyboard shortcuts are not working for some. #7305
2024-03-23 18:22:06 +05:30
25074e46b4
Added support for provider, deterministic, version and RULES parameter while creating collation. #5611
2024-03-19 16:52:22 +05:30
cee0945a78
Revert the changes made to include a separate 'ALTER TABLE ...' query for setting defaults, as per the previous fix for issue #7165 .
2024-03-19 15:12:04 +05:30
c56aef335b
Fixed RESQL test cases for DBMS Schedule
2024-03-18 13:44:07 +05:30
097b630738
Added support for EDB Job Scheduler. #7098
2024-03-18 11:53:59 +05:30
f351b10ed0
Fix an issue in query tool where toggle case of selected text loses selection. #7277
...
Also make changes to give pgAdmin shortcuts higher priority over CodeMirror default shortcuts.
2024-03-14 18:18:53 +05:30
1a02d13a28
Bug fixes and improvements in pgAdmin CLI. #7116
2024-03-14 18:12:28 +05:30
bece59d4b3
Fixed schema diff wrong query generation for table, foreign table and sequence. #7165
2024-03-14 11:21:19 +05:30
496acf5598
Polish up the system_stats not installed message.
2024-03-12 10:50:09 +05:30
36228fece7
Add a workaround in pgAdmin code to make Flask-Migrat>=4.0.6 work
2024-03-11 17:17:40 +05:30
794c7cb335
Fixed multiple editor related issues:
...
1. Replace option in query tool edit menu is not working on non-Mac OS. #7262
2. Format SQL shortcut and multiline selection are not working. #7268
3. "Use Spaces?" Preference of Editor is not working. #7269
2024-03-11 16:52:56 +05:30
7374997425
Fix an issue in table dialog where changing column name was not syncing table constraints appropriately. #7229
2024-03-08 11:45:32 +05:30
134e651989
Added support to exclude multiple tables while taking backup. #7163
2024-03-08 11:44:29 +05:30
4e49d752fb
Unsafe Deserialization and Remote Code Execution by an Authenticated user in pgAdmin 4 (CVE-2024-2044).
2024-03-04 13:22:09 +05:30
0cbb5324bf
Czech translation for version 8.4
2024-03-04 11:12:05 +05:30
3425bc0349
Ensure that the OAuth2 session is logged out when users log out from pgAdmin. #7193
2024-03-01 12:09:01 +05:30
7593bb98c1
Italian translation update for v8.4
2024-03-01 11:56:47 +05:30
0ea51861c7
Update message catalogs for v8.4
2024-02-29 18:40:50 +05:30
af88851228
Remove role related checks on the UI dashboard when terminating session/query and let PostgreSQL take care of it. #7217
2024-02-29 16:43:07 +05:30
8dffcf842f
Added documentation for System Statistics tab. #7148
2024-02-29 11:34:54 +05:30
43f4cc4e17
Fix an issue where type column in dependencies tab is not showing correct label. #7225
2024-02-26 11:59:30 +05:30
a5530f59f7
Fix sonarqube issues for the rule - 'If' statement should not be the only statement in 'else' block
2024-02-26 11:55:36 +05:30
a8ab714606
Fix multiple issues where PasswordExecCommand was not working in server mode and PasswordExecCommand was not loaded when importing servers. #6792
2024-02-23 14:05:26 +05:30
2ab419c8a5
Fixed EPAS RESQL test case failure.
2024-02-23 11:25:54 +05:30
29e85a6b06
Fix SonarQube issues
2024-02-22 16:54:20 +05:30
Yogesh Mahajan
Pravesh Sharma
Aditya Toshniwal
Anil Sahoo
Khushboo Vashi
Rohit Bhati
Akshay Joshi
John (Haipeng) Jiang
Kuo Chaoy
Nicolas
Domenico Sgarbossa
Kira
Libor M.
Ashesh Vashi
Comocen
Ashesh Vashi
Kundan
jcodeio
Ahmad
oon arfiandwi
RohitBhati8269
Neville Li
JyotiEdb
Anthony DeBarros
Florian