Khushboo Vashi
f207818afa
Implemented a server-side cursor to enhance performance when retrieving large datasets. #5797
2025-07-02 12:47:01 +05:30
Akshay Joshi
eece396b30
Fixed an issue where the PSQL tool would hang when the database encoding was set to SQL_ASCII and certain commands were executed.
2025-05-14 14:05:29 +05:30
Akshay Joshi
627aa5d695
Added ability to use SQL in the 'DB Restriction' field. #2767
2025-04-04 15:53:12 +05:30
Akshay Joshi
f635df6ccf
Added support for post-connection SQL execution, which will be run automatically on each connection made to any database of the server. #4503
2025-03-18 16:54:38 +05:30
Aditya Toshniwal
a0ddfad655
Fixed an issue where deleting rows in the query tool would delete all rows in the table when 'Select All Remaining Rows' was used. #8460
2025-02-18 17:34:24 +05:30
Akshay Joshi
84a8a522e3
1) Fixed an issue where Default Privileges and Privileges not working correctly. #8369
...
2) Fixed <br/> tag visible issue.
2025-01-22 19:40:13 +05:30
Akshay Joshi
a410b15e30
Fixed an issue where <br/> tag is visible in the error message when delete any database and it is in use.
2025-01-17 17:16:36 +05:30
Khushboo Vashi
36df6d5c8a
Fix an issue where using the binary cursor, utf-8 decode error comes up. #8199
2025-01-13 12:23:50 +05:30
Akshay Joshi
8c461ffb86
Reverted changes for formatted exception message. #8165
2025-01-06 17:46:34 +05:30
Akshay Joshi
90cdeeff0a
Modified logic for formatted exception message. #8165
2025-01-03 20:56:47 +05:30
Akshay Joshi
ff1d9e20d1
Fixed an issue where error message from the database server need space between two sentences. #8165
2025-01-02 18:14:51 +05:30
Akshay Joshi
964d211260
Copyright updated for 2025
2025-01-01 11:26:42 +05:30
Akshay Joshi
fe6e21a08b
Enhanced pgAdmin 4 with support for Workspace layouts. #7708
2024-12-16 14:52:56 +05:30
Yogesh Mahajan
d8ed75dbfd
Ensure correct custom SSL certificate passed in connection string. #8215
2024-12-04 15:38:27 +05:30
Pravesh Sharma
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
Yogesh Mahajan
026c0d2389
Ensure the crypt key is retrieved correctly on backend server restart. #8065
2024-11-21 15:55:38 +05:30
Rohit Bhati
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
Anil Sahoo
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
Aditya Toshniwal
296befc881
Code refactoring at multiple places to improve re-usability
2024-11-14 14:16:38 +05:30
Yogesh Mahajan
2cc8f5f272
Ensure server connection is successful for sslrootcert=system in server configuration. #7907
2024-10-14 16:17:46 +05:30
Aditya Toshniwal
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
Pravesh Sharma
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
Yogesh Mahajan
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
Pravesh Sharma
a75273a714
Updated entrypoint.sh to utilize the email-validator package for email validation. #7297
2024-07-18 11:05:37 +05:30
Khushboo Vashi
4f415f9768
Added support for viewing PostgreSQL Server Logs in Text, CSV and JSON formats. #3981
2024-07-03 16:17:29 +05:30
Akshay Joshi
5866da8194
Fixed SonarQube code smells.
2024-06-13 18:48:02 +05:30
Akshay Joshi
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
Akshay Joshi
0e0cbc40b8
Fixed SonarQube code smell Replace the unused local variable with '_'.
2024-01-24 18:33:43 +05:30
Akshay Joshi
740ce15bd7
Update copyright notices for 2024
2024-01-01 14:13:48 +05:30
Akshay Joshi
a22b2a6074
Added keep-alive support for SSH sessions when connecting to a PostgreSQL server via an SSH tunnel. #7016
2023-12-19 16:16:03 +05:30
Anil Sahoo
0b707be615
Fixed restoration of query tool database connection after dropping and re-creating the database with the same name. #6487
2023-11-01 15:27:18 +05:30
Akshay Joshi
81dcc91747
Added 'hostaddr' and used host string as it is while creating SSHTunnel.
2023-10-12 17:57:40 +05:30
Aditya Toshniwal
10adb6a11b
Add support for setting prepare threshold in server connection. #6285
2023-10-12 16:54:06 +05:30
Aditya Toshniwal
779749a515
Fix an 'str expected' error in import/export when setting server password in env
2023-08-21 13:08:19 +05:30
Khushboo Vashi
30a0fb1cb3
Fix the issue where query tool window turns blank if the user tries to generate a graph on the result. #6500
2023-08-01 13:57:52 +05:30
Aditya Toshniwal
a1c7265c41
Fix PEP8 issues with latest pycodestyle ( #6636 )
2023-07-31 18:14:39 +05:30
Khushboo Vashi
715fa47eb6
Fix an error 'list' object has no attribute 'strip' while attempting to populate auto-complete manually the first time. #6556
2023-07-13 10:18:38 +05:30
Akshay Joshi
45b1794941
1) Added extra check in qtLiteral method.
...
2) Fixed some escaping issues.
2023-07-12 15:26:19 +05:30
Akshay Joshi
940d190bc8
Fixed an issue where pgAdmin failed to setup role with hyphens in name. #6531
2023-07-12 10:36:41 +05:30
Khushboo Vashi
115d4afd9e
Fix security hotspots reported by Sonarqube.
2023-07-10 12:42:48 +05:30
Khushboo Vashi
326dc2bbcc
Fix an issue where queries longer than 1 minute get stuck - Container 7.1. #6317 ( #6491 )
...
Fix an issue where queries longer than 1 minute get stuck - Container 7.1. #6317
Fix an issue where queries get stuck with auto-completion enabled. #6356
Fix an issue where queries can't complete execution. #6163
2023-07-04 10:44:46 +05:30
Khushboo Vashi
1184752540
Support UNICODE encoding as psycopg3 do not support it by default.
2023-06-21 15:32:13 +05:30
Khushboo Vashi
c5cbb33a06
Fix raise notice from func/proc or code blocks are no longer displayed live. #6420
2023-06-19 17:04:22 +05:30
Akshay Joshi
251bf05692
Fixed the following SonarQube code smells:
...
1) Do not use Array index in keys.
2) Unnecessary escape character.
3) Rename this local variable to match the regular expression ^[_a-z][a-z0-9_]*$
4) Remove the unused local variable.
2023-06-12 18:44:31 +05:30
Khushboo Vashi
a5b5ede8fd
Fix the UNICODE encoding issue while connecting through Pgbouncer after upgrading from 6.21 to 7.1 #6340 .
2023-06-09 16:24:05 +05:30
Nikhil Mohite
f6275688e7
Fixed following issues: ( #6361 )
...
1) Ensure that SSH Tunnel should work properly after upgrading to 7.2 from 7.1. #6341
2) Ensure that the master password dialog should not visible if the parameter MASTER_PASSWORD_REQUIRED is set to False. #6353
2023-06-05 12:45:34 +05:30
Khushboo Vashi
10077f13c4
Fixed an issue where pgadmin is unable to take the defined role. #6342
2023-06-05 12:37:33 +05:30
Pravesh Sharma
bfa859e9ce
Fixed an issue where PSQL tool prompts for password if using password exec command. #6247
2023-05-23 11:07:04 +05:30
Nikhil Mohite
736879567f
Added support to use standard OS secret store to save server/ssh tunnel passwords instead of master password in pgAdmin desktop mode. #5123
2023-05-22 11:08:29 +05:30
Khushboo Vashi
2a22cf077c
Fix circular reference error for the multirange data types in the query tool. #6221
...
Add support for the multirange data types.
2023-05-10 10:32:47 +05:30