Re: Require suggestion for issue #8007
Hi Dave, On Tue, Oct 8, 2024 at 6:34 PM Dave Page wrote: > > > On Tue, 8 Oct 2024 at 13:56, Pravesh Sharma < > pravesh.sha...@enterprisedb.com> wrote: > >> Hi Hackers, >> >> We have been working on issue #8007 >> <https://github.com/pgadmin-org/pgadmin4/issues/8007>. After our >> analysis, we found that the length and scale of the argument's data type >> are not stored in the database server, making it difficult to fetch. In the >> debugger, pgAdmin typecasts the provided value to its data type when >> calling the function, which is causing the issue. >> >> If we typecast the value to a character without specifying the length, it >> is treated as a character (1) (character of length 1). For example, the >> output of SELECT 'pgadmin', 'pgadmin'::character; is different. >> >> There are two solutions we can consider: >> >>1. Do not typecast if the data type is character. >>2. Typecast to varchar when the data type is character. >> >> Please provide your suggestions which solution looks good to you. >> > > Why not include the length in the cast? We know what the input string is, > so can't we just do the equivalent of: > > 'pgadmin'::character(7); > Just to confirm, this will be only for the character data type? > -- > Dave Page > pgAdmin: https://www.pgadmin.org > PostgreSQL: https://www.postgresql.org > EDB: https://www.enterprisedb.com > >
Require suggestion for issue #8007
Hi Hackers, We have been working on issue #8007 <https://github.com/pgadmin-org/pgadmin4/issues/8007>. After our analysis, we found that the length and scale of the argument's data type are not stored in the database server, making it difficult to fetch. In the debugger, pgAdmin typecasts the provided value to its data type when calling the function, which is causing the issue. If we typecast the value to a character without specifying the length, it is treated as a character (1) (character of length 1). For example, the output of SELECT 'pgadmin', 'pgadmin'::character; is different. There are two solutions we can consider: 1. Do not typecast if the data type is character. 2. Typecast to varchar when the data type is character. Please provide your suggestions which solution looks good to you. Thanks, Pravesh -- Pravesh Sharma Software Engineer +91 9406461406 enterprisedb.com
Re: Require suggestions on issue #7811
Hi Dave, On Tue, Sep 3, 2024 at 1:47 PM Dave Page wrote: > Hi > > On Tue, 3 Sept 2024 at 09:10, Pravesh Sharma < > pravesh.sha...@enterprisedb.com> wrote: > >> Hi Hackers, >> >> I am working on issue #7811 >> <https://github.com/pgadmin-org/pgadmin4/issues/7811>, where using an >> external database for storing pgAdmin configuration results in duplicate >> server entries when a container with a mapped servers.json file is >> restarted. >> >> The proposed solution is to implement a check when loading servers. We >> would verify the server’s name, host, port, and username to determine if >> the server already exists in the database. If it does, we would skip >> registering it again. >> >> >> Please share any suggestions or feedback on this approach. >> > > I would say "Won't fix". If someone is using persistent storage for > settings, why launch containers to import the same servers over and over > again? Just load them once, manually. > What if the container needs to be restarted? In that case it will again import the server making a duplicate entry. > > -- > Dave Page > pgAdmin: https://www.pgadmin.org > PostgreSQL: https://www.postgresql.org > EDB: https://www.enterprisedb.com > > PGDay UK 2024, 11th September, London: https://2024.pgday.uk/ > >
Require suggestions on issue #7811
Hi Hackers, I am working on issue #7811 <https://github.com/pgadmin-org/pgadmin4/issues/7811>, where using an external database for storing pgAdmin configuration results in duplicate server entries when a container with a mapped servers.json file is restarted. The proposed solution is to implement a check when loading servers. We would verify the server’s name, host, port, and username to determine if the server already exists in the database. If it does, we would skip registering it again. Please share any suggestions or feedback on this approach. -- Pravesh Sharma Software Engineer +91 9406461406 enterprisedb.com
[pgadmin-org/pgadmin4] 1c44cf: Update the documentation for preferences dialog an...
Branch: refs/heads/master Home: https://github.com/pgadmin-org/pgadmin4 Commit: 1c44cfb714ec1f6b65ff3a6ff52bfbcf50207dfc https://github.com/pgadmin-org/pgadmin4/commit/1c44cfb714ec1f6b65ff3a6ff52bfbcf50207dfc Author: Pravesh Sharma Date: 2024-05-15 (Wed, 15 May 2024) Changed paths: M docs/en_US/debugger.rst M docs/en_US/erd_tool.rst M docs/en_US/images/preferences_browser_display.png M docs/en_US/images/preferences_browser_keyboard_shortcuts.png M docs/en_US/images/preferences_dashboard_refresh.png M docs/en_US/images/preferences_erd_options.png M docs/en_US/images/preferences_paths_binary.png M docs/en_US/images/preferences_sql_display.png M docs/en_US/images/preferences_sql_editor.png M docs/en_US/images/preferences_sql_formatting.png M docs/en_US/images/preferences_sql_results_grid.png M docs/en_US/images/query_editing.png M docs/en_US/keyboard_shortcuts.rst M docs/en_US/preferences.rst M docs/en_US/query_tool_toolbar.rst M web/pgadmin/browser/register_browser_preferences.py M web/pgadmin/browser/static/js/keyboard.js Log Message: --- Update the documentation for preferences dialog and keyboard shortcuts. #7349, #7458 To unsubscribe from these emails, change your notification settings at https://github.com/pgadmin-org/pgadmin4/settings/notifications
Re: Next Library/Package update
Hi Team, I have reviewed the list of upcoming OS releases and EOL dates. Below are the details: Upcoming OS versions: 1. Fedora 40 - released on 23 Apr 2024 2. Ubuntu 24.04 - released on 25 Apr 2024 OS nearing EOL: 1. Fedora 38 - 14 May 2024 2. Debian 10 - 30 Jun 2024 3. Ubuntu 23.10 - 01 Jul 2024 Please note that Python 3.8 security support will end on 31 Oct 2024. I have referenced the details from here <https://endoflife.date/>. Regards, Pravesh Sharma On Thu, Apr 11, 2024 at 5:04 PM Pravesh Sharma < pravesh.sha...@enterprisedb.com> wrote: > Hi Dave/ Team, > > While updating to the latest Flask version, I found that support for > Python 3.7 has been dropped on most of the packages. Debian 10, which > defaults to Python 3.7, will reach its End of Life on 30th June 2024. > Should we drop support for Python 3.7 in the upcoming May release with the > package update, or should we wait? > > > @team Please share your suggestions. > > > > Regards, > > Pravesh > > On Wed, Jun 21, 2023 at 12:55 PM Akshay Joshi < > akshay.jo...@enterprisedb.com> wrote: > >> Hi Dave/Team >> >> Following things that we should update as the next big change: >> >>1. Flask and other dependent packages( Can't pick until we drop >>support for Python 3.7) >>2. WCDocker >>3. Mui 5 >>4. Code Mirror 6 >>5. React Aspen tree with React Arborist ( >>https://www.npmjs.com/package/react-arborist) >> >> >> -- >> Akshay Joshi >> Principal Software Architect >> www.enterprisedb.com >> >> *Blog*: https://www.enterprisedb.com/akshay-joshi >> *GitHub*: https://github.com/akshay-joshi >> *LinkedIn*: https://www.linkedin.com/in/akshay-joshi-086497216 >> > > > -- > > <http://www.enterprisedb.com> > > Pravesh Sharma > > Software Engineer > > +91 9406461406 > > www.enterprisedb.com > > Power to Postgres > > <https://www.linkedin.com/company/edbpostgres> > <https://twitter.com/edbpostgres?lang=en> > <https://www.facebook.com/EDBpostgres> > <https://www.instagram.com/EDBpostgres/> >
[pgadmin-org/pgadmin4] f7045b: Fixed an issue where format sql was messing up ope...
Branch: refs/heads/master Home: https://github.com/pgadmin-org/pgadmin4 Commit: f7045b58d4d1b98b6a2f035267d2dd01c7235aa6 https://github.com/pgadmin-org/pgadmin4/commit/f7045b58d4d1b98b6a2f035267d2dd01c7235aa6 Author: Pravesh Sharma Date: 2024-02-02 (Fri, 02 Feb 2024) Changed paths: M docs/en_US/images/preferences_sql_formatting.png M docs/en_US/preferences.rst M web/package.json M web/pgadmin/misc/__init__.py R web/pgadmin/misc/sql/__init__.py M web/pgadmin/tools/sqleditor/static/js/components/sections/Query.jsx M web/pgadmin/tools/sqleditor/utils/query_tool_preferences.py M web/yarn.lock Log Message: --- Fixed an issue where format sql was messing up operator. #5083 - The formatting is done on client side now using sql-formattor JS lib. Backend API based formatting is removed. - Added new options data type case, expression width, function case, lines between queries, logical operator new line and new line before semicolon available in the new lib. - Removed old options comma-first notations, re-indent aligned, re-indent, strip comments and wrap after N characters as not available in the new library. - Capitalise casing is replaced with Preserve casing as it is not supported by the new library. - Also fixes #6785, #6990, #7115.
[pgadmin-org/pgadmin4] 3de19f: Added support for column storage syntax while crea...
Branch: refs/heads/master Home: https://github.com/pgadmin-org/pgadmin4 Commit: 3de19f66f2f77c4869b4ebaddafac7cbab50f852 https://github.com/pgadmin-org/pgadmin4/commit/3de19f66f2f77c4869b4ebaddafac7cbab50f852 Author: Pravesh Sharma Date: 2024-01-29 (Mon, 29 Jan 2024) Changed paths: M docs/en_US/column_dialog.rst M docs/en_US/images/column_definition.png M web/pgadmin/browser/server_groups/servers/databases/schemas/tables/columns/static/js/column.ui.js M web/pgadmin/browser/server_groups/servers/databases/schemas/tables/columns/tests/column_test_data.json A web/pgadmin/browser/server_groups/servers/databases/schemas/tables/columns/tests/pg/16_plus/alter_column_storage.msql A web/pgadmin/browser/server_groups/servers/databases/schemas/tables/columns/tests/pg/16_plus/alter_column_storage.sql A web/pgadmin/browser/server_groups/servers/databases/schemas/tables/columns/tests/pg/16_plus/create_column_with_storage.msql A web/pgadmin/browser/server_groups/servers/databases/schemas/tables/columns/tests/pg/16_plus/create_column_with_storage.sql A web/pgadmin/browser/server_groups/servers/databases/schemas/tables/columns/tests/pg/16_plus/test.json A web/pgadmin/browser/server_groups/servers/databases/schemas/tables/columns/tests/ppas/16_plus/alter_column_storage.msql A web/pgadmin/browser/server_groups/servers/databases/schemas/tables/columns/tests/ppas/16_plus/alter_column_storage.sql A web/pgadmin/browser/server_groups/servers/databases/schemas/tables/columns/tests/ppas/16_plus/create_column_with_storage.msql A web/pgadmin/browser/server_groups/servers/databases/schemas/tables/columns/tests/ppas/16_plus/create_column_with_storage.sql A web/pgadmin/browser/server_groups/servers/databases/schemas/tables/columns/tests/ppas/16_plus/test.json A web/pgadmin/browser/server_groups/servers/databases/schemas/tables/templates/columns/sql/16_plus/create.sql A web/pgadmin/browser/server_groups/servers/databases/schemas/tables/templates/columns/sql/16_plus/update.sql A web/pgadmin/browser/server_groups/servers/databases/schemas/tables/templates/tables/sql/16_plus/create.sql A web/pgadmin/browser/server_groups/servers/databases/schemas/tables/tests/pg/16_plus/create_table_with_column_storage.sql A web/pgadmin/browser/server_groups/servers/databases/schemas/tables/tests/pg/16_plus/create_table_with_column_storage_msql.sql A web/pgadmin/browser/server_groups/servers/databases/schemas/tables/tests/pg/16_plus/test.json A web/pgadmin/browser/server_groups/servers/databases/schemas/tables/tests/ppas/16_plus/create_table_with_column_storage.sql A web/pgadmin/browser/server_groups/servers/databases/schemas/tables/tests/ppas/16_plus/create_table_with_column_storage_msql.sql A web/pgadmin/browser/server_groups/servers/databases/schemas/tables/tests/ppas/16_plus/test.json M web/pgadmin/browser/server_groups/servers/databases/schemas/tables/tests/table_test_data.json Log Message: --- Added support for column storage syntax while creating table. #6450
[pgadmin-org/pgadmin4] b28df5: Fixed an issue where multiple errors were showing ...
Branch: refs/heads/master Home: https://github.com/pgadmin-org/pgadmin4 Commit: b28df5874e1723bad4a01215947f340bfcd7a89f https://github.com/pgadmin-org/pgadmin4/commit/b28df5874e1723bad4a01215947f340bfcd7a89f Author: Pravesh Sharma Date: 2024-01-12 (Fri, 12 Jan 2024) Changed paths: M web/pgadmin/browser/server_groups/servers/databases/static/js/database.js M web/pgadmin/static/js/helpers/Notifier.jsx Log Message: --- Fixed an issue where multiple errors were showing if user does not have connect privileges. #7073
[pgadmin-org/pgadmin4] 701085: Fixed an issue where group membership information ...
Branch: refs/heads/master Home: https://github.com/pgadmin-org/pgadmin4 Commit: 701085adaf836567ba54caf5e061a67d6547d41c https://github.com/pgadmin-org/pgadmin4/commit/701085adaf836567ba54caf5e061a67d6547d41c Author: Pravesh Sharma Date: 2024-01-12 (Fri, 12 Jan 2024) Changed paths: M web/pgadmin/browser/server_groups/servers/roles/static/js/role.ui.js Log Message: --- Fixed an issue where group membership information was displayed incorrectly. #7085
[pgadmin-org/pgadmin4] fd8af4: Fixed an issue where user is not able to cancel or...
Branch: refs/heads/master Home: https://github.com/pgadmin-org/pgadmin4 Commit: fd8af4034abda6b8cc8aaeff5a1c1a1d0d7e463a https://github.com/pgadmin-org/pgadmin4/commit/fd8af4034abda6b8cc8aaeff5a1c1a1d0d7e463a Author: Pravesh Sharma Date: 2023-12-29 (Fri, 29 Dec 2023) Changed paths: M web/pgadmin/dashboard/static/js/Dashboard.jsx Log Message: --- Fixed an issue where user is not able to cancel or terminate active queries from dashboard. #7078
[pgadmin-org/pgadmin4] cede5c: Fixed an issue where object explorer last tree sta...
Branch: refs/heads/master Home: https://github.com/pgadmin-org/pgadmin4 Commit: cede5cf89987209712db11c565435021d914e210 https://github.com/pgadmin-org/pgadmin4/commit/cede5cf89987209712db11c565435021d914e210 Author: Pravesh Sharma Date: 2023-12-25 (Mon, 25 Dec 2023) Changed paths: M web/pgadmin/static/js/tree/pgadmin_tree_save_state.js Log Message: --- Fixed an issue where object explorer last tree state was not saving. #7066
[pgadmin-org/pgadmin4] 2d60bc: Fixed an issue where export servers was not adding...
Branch: refs/heads/master Home: https://github.com/pgadmin-org/pgadmin4 Commit: 2d60bc280026774841426173490d6a75b6e71ee5 https://github.com/pgadmin-org/pgadmin4/commit/2d60bc280026774841426173490d6a75b6e71ee5 Author: Pravesh Sharma Date: 2023-12-20 (Wed, 20 Dec 2023) Changed paths: M web/pgadmin/tools/import_export_servers/__init__.py Log Message: --- Fixed an issue where export servers was not adding extension if not specified. #6781
[pgadmin-org/pgadmin4] a01b09: Fixed an issue where syntax error was not highligh...
Branch: refs/heads/master Home: https://github.com/pgadmin-org/pgadmin4 Commit: a01b0973fcf6aa650580c79eb7f5161097200c89 https://github.com/pgadmin-org/pgadmin4/commit/a01b0973fcf6aa650580c79eb7f5161097200c89 Author: Pravesh Sharma Date: 2023-12-11 (Mon, 11 Dec 2023) Changed paths: M web/pgadmin/static/js/api_instance.js M web/pgadmin/tools/sqleditor/__init__.py M web/pgadmin/tools/sqleditor/static/js/components/sections/Query.jsx M web/pgadmin/tools/sqleditor/static/js/components/sections/ResultSet.jsx M web/pgadmin/tools/sqleditor/utils/apply_explain_plan_wrapper.py M web/pgadmin/utils/ajax.py Log Message: --- Fixed an issue where syntax error was not highlighting for explain query. #6887
[pgadmin-org/pgadmin4] e64f4f: 1. Fixed an issue where all rows and filter rows b...
Branch: refs/heads/master Home: https://github.com/pgadmin-org/pgadmin4 Commit: e64f4f632d8bd830f1d4e7828b4d8139e539aa33 https://github.com/pgadmin-org/pgadmin4/commit/e64f4f632d8bd830f1d4e7828b4d8139e539aa33 Author: Pravesh Sharma Date: 2023-12-04 (Mon, 04 Dec 2023) Changed paths: M web/pgadmin/static/js/UtilityView.jsx M web/pgadmin/static/js/helpers/ObjectExplorerToolbar.jsx Log Message: --- 1. Fixed an issue where all rows and filter rows buttons of object explorer toolbar were disabled for views and other supported nodes. #7011 2. Fixed an issue where View/Edit data -> Filter dialog was not editable for catalog objects.
[pgadmin-org/pgadmin4] 412375: - Add support for creating a function with custom ...
Branch: refs/heads/master Home: https://github.com/pgadmin-org/pgadmin4 Commit: 412375af3c9dc4b1e6b908cfcd6ab268371ea9b7 https://github.com/pgadmin-org/pgadmin4/commit/412375af3c9dc4b1e6b908cfcd6ab268371ea9b7 Author: Pravesh Sharma Date: 2023-11-28 (Tue, 28 Nov 2023) Changed paths: M docs/en_US/function_dialog.rst M docs/en_US/images/function_definition.png M web/pgadmin/browser/server_groups/servers/databases/schemas/functions/__init__.py M web/pgadmin/browser/server_groups/servers/databases/schemas/functions/static/js/function.ui.js M web/pgadmin/browser/server_groups/servers/databases/schemas/functions/tests/pg/11_plus/test_function.json M web/pgadmin/browser/server_groups/servers/databases/schemas/functions/tests/pg/12_plus/test_function.json M web/pgadmin/browser/server_groups/servers/databases/schemas/functions/tests/pg/14_plus/test_function.json A web/pgadmin/browser/server_groups/servers/databases/schemas/functions/tests/pg/default/create_function_with_custom_return.msql A web/pgadmin/browser/server_groups/servers/databases/schemas/functions/tests/pg/default/create_function_with_custom_return.sql M web/pgadmin/browser/server_groups/servers/databases/schemas/functions/tests/pg/default/test_function.json M web/pgadmin/browser/server_groups/servers/databases/schemas/functions/tests/ppas/11_plus/test_function.json M web/pgadmin/browser/server_groups/servers/databases/schemas/functions/tests/ppas/12_plus/test_function.json M web/pgadmin/browser/server_groups/servers/databases/schemas/functions/tests/ppas/14_plus/test_function.json A web/pgadmin/browser/server_groups/servers/databases/schemas/functions/tests/ppas/default/create_function_with_custom_return.msql A web/pgadmin/browser/server_groups/servers/databases/schemas/functions/tests/ppas/default/create_function_with_custom_return.sql M web/pgadmin/browser/server_groups/servers/databases/schemas/functions/tests/ppas/default/test_function.json M web/pgadmin/browser/static/js/node.js M web/pgadmin/tools/erd/static/js/erd_tool/components/ERDTool.jsx Log Message: --- - Add support for creating a function with custom return type. #6854 - Fixed an issue where create object dialog title was not showing object type name.
[pgadmin-org/pgadmin4] b51df0: Fixed an issue where syntax error was not highligh...
Branch: refs/heads/master Home: https://github.com/pgadmin-org/pgadmin4 Commit: b51df0e5fdc2252554cbe3865f7d6fc104451264 https://github.com/pgadmin-org/pgadmin4/commit/b51df0e5fdc2252554cbe3865f7d6fc104451264 Author: Pravesh Sharma Date: 2023-11-23 (Thu, 23 Nov 2023) Changed paths: M web/pgadmin/tools/sqleditor/static/js/components/sections/ResultSet.jsx Log Message: --- Fixed an issue where syntax error was not highlighting in query tool. #6887
[pgadmin-org/pgadmin4] 01d1e6: Server config information in the about dialog shou...
Branch: refs/heads/master Home: https://github.com/pgadmin-org/pgadmin4 Commit: 01d1e6f70680d7c69a754db0f7bba00362d82481 https://github.com/pgadmin-org/pgadmin4/commit/01d1e6f70680d7c69a754db0f7bba00362d82481 Author: Pravesh Sharma Date: 2023-11-03 (Fri, 03 Nov 2023) Changed paths: M web/pgadmin/about/__init__.py M web/pgadmin/about/static/js/AboutComponent.jsx Log Message: --- Server config information in the about dialog should be only visible to admin users. #6769
[pgadmin-org/pgadmin4] 5d7080: 1. Fixed an issue where psql was not taking the ro...
Branch: refs/heads/master Home: https://github.com/pgadmin-org/pgadmin4 Commit: 5d70803d6d4b5156dbf6ff480fe3675cbbf9dbc7 https://github.com/pgadmin-org/pgadmin4/commit/5d70803d6d4b5156dbf6ff480fe3675cbbf9dbc7 Author: Pravesh Sharma Date: 2023-11-02 (Thu, 02 Nov 2023) Changed paths: M web/pgadmin/tools/psql/__init__.py M web/pgadmin/tools/psql/static/js/psql_module.js M web/pgadmin/tools/psql/templates/editor_template.html Log Message: --- 1. Fixed an issue where psql was not taking the role used to connect in server properties. #5807 2. Corrected title in query tool connection link.
[pgadmin-org/pgadmin4] 5bb6e9: Fixed query history slowness issue by storing quer...
Branch: refs/heads/master Home: https://github.com/pgadmin-org/pgadmin4 Commit: 5bb6e9133fa5234a4648cf7614926b13071b1234 https://github.com/pgadmin-org/pgadmin4/commit/5bb6e9133fa5234a4648cf7614926b13071b1234 Author: Pravesh Sharma Date: 2023-10-17 (Tue, 17 Oct 2023) Changed paths: M web/pgadmin/tools/sqleditor/static/js/components/QueryToolComponent.jsx M web/pgadmin/tools/sqleditor/static/js/components/QueryToolConstants.js M web/pgadmin/tools/sqleditor/static/js/components/sections/QueryHistory.jsx Log Message: --- Fixed query history slowness issue by storing query only for those having certain threshold max length. #
[pgadmin-org/pgadmin4] eead9b: Fixed issue where MSQL for delete column was not g...
Branch: refs/heads/master Home: https://github.com/pgadmin-org/pgadmin4 Commit: eead9b77e7d28149928a931e885c7ad559695fd7 https://github.com/pgadmin-org/pgadmin4/commit/eead9b77e7d28149928a931e885c7ad559695fd7 Author: Pravesh Sharma Date: 2023-10-16 (Mon, 16 Oct 2023) Changed paths: M web/pgadmin/browser/server_groups/servers/databases/schemas/tables/utils.py Log Message: --- Fixed issue where MSQL for delete column was not generating. #5749
[pgadmin-org/pgadmin4] 73430a: Fixed an issue where user was not able to assign n...
Branch: refs/heads/master Home: https://github.com/pgadmin-org/pgadmin4 Commit: 73430a20620a2f4c8f0decaa4066675c5fcd3c7a https://github.com/pgadmin-org/pgadmin4/commit/73430a20620a2f4c8f0decaa4066675c5fcd3c7a Author: Pravesh Sharma Date: 2023-10-11 (Wed, 11 Oct 2023) Changed paths: M web/pgadmin/browser/server_groups/servers/databases/schemas/tables/columns/static/js/column.ui.js M web/pgadmin/browser/server_groups/servers/databases/schemas/tables/static/js/table.ui.js M web/pgadmin/static/js/SchemaView/index.jsx Log Message: --- Fixed an issue where user was not able to assign new/old columns as primary key once column with primary key is deleted. #5749
[pgadmin-org/pgadmin4] 325885: Access method for partitions not visible when open...
Branch: refs/heads/master Home: https://github.com/pgadmin-org/pgadmin4 Commit: 32588514254c93c808fee2b13ced43a14ed21748 https://github.com/pgadmin-org/pgadmin4/commit/32588514254c93c808fee2b13ced43a14ed21748 Author: Pravesh Sharma Date: 2023-09-18 (Mon, 18 Sep 2023) Changed paths: M web/pgadmin/browser/server_groups/servers/databases/schemas/tables/static/js/partition.utils.ui.js M web/pgadmin/browser/server_groups/servers/databases/schemas/tables/utils.py Log Message: --- Access method for partitions not visible when opening table properties. #6378
[pgadmin-org/pgadmin4] d69b42: Fixed issues reported while testing feature #6378
Branch: refs/heads/master Home: https://github.com/pgadmin-org/pgadmin4 Commit: d69b4282c8ea6e21256f242fef252acd50d9d638 https://github.com/pgadmin-org/pgadmin4/commit/d69b4282c8ea6e21256f242fef252acd50d9d638 Author: Pravesh Sharma Date: 2023-09-13 (Wed, 13 Sep 2023) Changed paths: M web/pgadmin/browser/server_groups/servers/databases/schemas/tables/templates/tables/sql/12_plus/create.sql M web/pgadmin/browser/server_groups/servers/databases/schemas/tables/templates/tables/sql/14_plus/create.sql M web/pgadmin/browser/server_groups/servers/databases/schemas/views/static/js/mview.ui.js Log Message: --- Fixed issues reported while testing feature #6378
[pgadmin-org/pgadmin4] 8c91d4: Fixed RESQL test case failure for EPAS 15. #6400
Branch: refs/heads/master Home: https://github.com/pgadmin-org/pgadmin4 Commit: 8c91d40932742c9c5ad5ada6f1c7a315f32e8f1d https://github.com/pgadmin-org/pgadmin4/commit/8c91d40932742c9c5ad5ada6f1c7a315f32e8f1d Author: Pravesh Sharma Date: 2023-09-13 (Wed, 13 Sep 2023) Changed paths: M web/pgadmin/browser/server_groups/servers/databases/schemas/views/tests/ppas/15_plus/test_mview.json M web/pgadmin/browser/server_groups/servers/databases/schemas/views/tests/ppas/16_plus/test_mview.json Log Message: --- Fixed RESQL test case failure for EPAS 15. #6400
[pgadmin-org/pgadmin4] cfc338: Fix an issue where login form doesn't appear if in...
Branch: refs/heads/master Home: https://github.com/pgadmin-org/pgadmin4 Commit: cfc338c5f0677dfcf32c107403d4da54a0f26e54 https://github.com/pgadmin-org/pgadmin4/commit/cfc338c5f0677dfcf32c107403d4da54a0f26e54 Author: Pravesh Sharma Date: 2023-09-12 (Tue, 12 Sep 2023) Changed paths: M web/pgadmin/static/js/SecurityPages/LoginPage.jsx Log Message: --- Fix an issue where login form doesn't appear if internal auth source is removed. #6378
[pgadmin-org/pgadmin4] a43b70: 1. Added USING method while creating the table. #6378
Branch: refs/heads/master Home: https://github.com/pgadmin-org/pgadmin4 Commit: a43b70e36003da5bc6c7ac79f87bb1cd55d60ba1 https://github.com/pgadmin-org/pgadmin4/commit/a43b70e36003da5bc6c7ac79f87bb1cd55d60ba1 Author: Pravesh Sharma Date: 2023-09-06 (Wed, 06 Sep 2023) Changed paths: A docs/en_US/images/materialized_view_code.png M docs/en_US/images/materialized_view_definition.png M docs/en_US/images/materialized_view_parameter.png M docs/en_US/images/materialized_view_security.png M docs/en_US/images/materialized_view_sql.png R docs/en_US/images/materialized_view_storage.png M docs/en_US/images/table_advanced.png M docs/en_US/materialized_view_dialog.rst M docs/en_US/table_dialog.rst M web/pgadmin/browser/server_groups/servers/databases/schemas/tables/__init__.py A web/pgadmin/browser/server_groups/servers/databases/schemas/tables/indexes/tests/11_plus/alter_expr_statistics_msql.sql R web/pgadmin/browser/server_groups/servers/databases/schemas/tables/indexes/tests/default/alter_expr_statistics_msql.sql M web/pgadmin/browser/server_groups/servers/databases/schemas/tables/indexes/tests/default/test_indexes.json M web/pgadmin/browser/server_groups/servers/databases/schemas/tables/indexes/tests/index_test_data.json M web/pgadmin/browser/server_groups/servers/databases/schemas/tables/indexes/tests/test_indexes_put.py M web/pgadmin/browser/server_groups/servers/databases/schemas/tables/partitions/__init__.py M web/pgadmin/browser/server_groups/servers/databases/schemas/tables/partitions/static/js/partition.ui.js M web/pgadmin/browser/server_groups/servers/databases/schemas/tables/static/js/partition.utils.ui.js M web/pgadmin/browser/server_groups/servers/databases/schemas/tables/static/js/table.ui.js M web/pgadmin/browser/server_groups/servers/databases/schemas/tables/templates/indexes/sql/default/create.sql A web/pgadmin/browser/server_groups/servers/databases/schemas/tables/templates/partitions/sql/pg/12_plus/create.sql A web/pgadmin/browser/server_groups/servers/databases/schemas/tables/templates/partitions/sql/pg/12_plus/nodes.sql M web/pgadmin/browser/server_groups/servers/databases/schemas/tables/templates/partitions/sql/pg/12_plus/properties.sql M web/pgadmin/browser/server_groups/servers/databases/schemas/tables/templates/partitions/sql/pg/14_plus/nodes.sql A web/pgadmin/browser/server_groups/servers/databases/schemas/tables/templates/partitions/sql/ppas/12_plus/create.sql A web/pgadmin/browser/server_groups/servers/databases/schemas/tables/templates/partitions/sql/ppas/12_plus/nodes.sql M web/pgadmin/browser/server_groups/servers/databases/schemas/tables/templates/partitions/sql/ppas/12_plus/properties.sql M web/pgadmin/browser/server_groups/servers/databases/schemas/tables/templates/partitions/sql/ppas/14_plus/nodes.sql M web/pgadmin/browser/server_groups/servers/databases/schemas/tables/templates/tables/sql/12_plus/create.sql A web/pgadmin/browser/server_groups/servers/databases/schemas/tables/templates/tables/sql/12_plus/get_access_methods.sql M web/pgadmin/browser/server_groups/servers/databases/schemas/tables/templates/tables/sql/12_plus/properties.sql M web/pgadmin/browser/server_groups/servers/databases/schemas/tables/templates/tables/sql/14_plus/create.sql A web/pgadmin/browser/server_groups/servers/databases/schemas/tables/templates/tables/sql/15_plus/update.sql M web/pgadmin/browser/server_groups/servers/databases/schemas/tables/utils.py M web/pgadmin/browser/server_groups/servers/databases/schemas/views/__init__.py M web/pgadmin/browser/server_groups/servers/databases/schemas/views/static/js/mview.js M web/pgadmin/browser/server_groups/servers/databases/schemas/views/static/js/mview.ui.js A web/pgadmin/browser/server_groups/servers/databases/schemas/views/templates/mviews/pg/12_plus/sql/create.sql A web/pgadmin/browser/server_groups/servers/databases/schemas/views/templates/mviews/pg/12_plus/sql/create_access_method.sql A web/pgadmin/browser/server_groups/servers/databases/schemas/views/templates/mviews/pg/12_plus/sql/get_access_methods.sql A web/pgadmin/browser/server_groups/servers/databases/schemas/views/templates/mviews/pg/12_plus/sql/properties.sql A web/pgadmin/browser/server_groups/servers/databases/schemas/views/templates/mviews/pg/12_plus/sql/update.sql A web/pgadmin/browser/server_groups/servers/databases/schemas/views/templates/mviews/pg/15_plus/sql/update.sql A web/pgadmin/browser/server_groups/servers/databases/schemas/views/templates/mviews/ppas/12_plus/sql/create.sql A web/pgadmin/browser/server_groups/servers/databases/schemas/views/templates/mviews/ppas/12_plus/sql/get_access_methods.sql A web/pgadmin/browser/server_groups/servers/databases/schemas/views/templates/mviews/ppas/12_plus/sql/properties.sql A web/pgadmin/browser
[pgadmin-org/pgadmin4] 27c7ea: Added all like options while creating a table. #6377
Branch: refs/heads/master Home: https://github.com/pgadmin-org/pgadmin4 Commit: 27c7ea2ff15e73cde6aa9e59ff8f8ccfc01500e0 https://github.com/pgadmin-org/pgadmin4/commit/27c7ea2ff15e73cde6aa9e59ff8f8ccfc01500e0 Author: Pravesh Sharma Date: 2023-08-07 (Mon, 07 Aug 2023) Changed paths: M docs/en_US/images/table_advanced.png M docs/en_US/table_dialog.rst M web/pgadmin/browser/server_groups/servers/databases/schemas/tables/static/js/table.ui.js M web/pgadmin/browser/server_groups/servers/databases/schemas/tables/templates/tables/sql/11_plus/create.sql M web/pgadmin/browser/server_groups/servers/databases/schemas/tables/templates/tables/sql/12_plus/create.sql A web/pgadmin/browser/server_groups/servers/databases/schemas/tables/templates/tables/sql/14_plus/create.sql M web/pgadmin/browser/server_groups/servers/databases/schemas/tables/templates/tables/sql/default/create.sql M web/pgadmin/browser/server_groups/servers/databases/schemas/tables/tests/pg/11_plus/create_partition_table_with_collate.sql M web/pgadmin/browser/server_groups/servers/databases/schemas/tables/tests/pg/11_plus/create_table_with_hash_partition.sql M web/pgadmin/browser/server_groups/servers/databases/schemas/tables/tests/pg/11_plus/test.json M web/pgadmin/browser/server_groups/servers/databases/schemas/tables/tests/pg/12_plus/alter_table_add_exclude_constraint.sql M web/pgadmin/browser/server_groups/servers/databases/schemas/tables/tests/pg/12_plus/alter_table_add_exclude_constraint_msql.sql M web/pgadmin/browser/server_groups/servers/databases/schemas/tables/tests/pg/12_plus/alter_table_update_grants.sql M web/pgadmin/browser/server_groups/servers/databases/schemas/tables/tests/pg/12_plus/create_partition_table_with_collate.sql M web/pgadmin/browser/server_groups/servers/databases/schemas/tables/tests/pg/12_plus/create_table_with_hash_partition.sql M web/pgadmin/browser/server_groups/servers/databases/schemas/tables/tests/pg/12_plus/create_table_with_lik_tbl_msql.sql M web/pgadmin/browser/server_groups/servers/databases/schemas/tables/tests/pg/12_plus/create_table_with_partition.sql M web/pgadmin/browser/server_groups/servers/databases/schemas/tables/tests/pg/12_plus/create_table_with_range_partition.sql M web/pgadmin/browser/server_groups/servers/databases/schemas/tables/tests/pg/12_plus/test.json A web/pgadmin/browser/server_groups/servers/databases/schemas/tables/tests/pg/14_plus/create_table_with_lik_tbl_msql.sql A web/pgadmin/browser/server_groups/servers/databases/schemas/tables/tests/pg/14_plus/test.json M web/pgadmin/browser/server_groups/servers/databases/schemas/tables/tests/pg/default/alter_table_add_exclude_constraint.sql M web/pgadmin/browser/server_groups/servers/databases/schemas/tables/tests/pg/default/alter_table_add_exclude_constraint_msql.sql M web/pgadmin/browser/server_groups/servers/databases/schemas/tables/tests/pg/default/alter_table_update_grants.sql M web/pgadmin/browser/server_groups/servers/databases/schemas/tables/tests/pg/default/create_table_with_lik_tbl_msql.sql M web/pgadmin/browser/server_groups/servers/databases/schemas/tables/tests/pg/default/test.json M web/pgadmin/browser/server_groups/servers/databases/schemas/tables/tests/ppas/11_plus/test.json M web/pgadmin/browser/server_groups/servers/databases/schemas/tables/tests/ppas/12_plus/alter_table_add_exclude_constraint.sql M web/pgadmin/browser/server_groups/servers/databases/schemas/tables/tests/ppas/12_plus/alter_table_add_exclude_constraint_msql.sql M web/pgadmin/browser/server_groups/servers/databases/schemas/tables/tests/ppas/12_plus/create_table_with_lik_tbl_msql.sql M web/pgadmin/browser/server_groups/servers/databases/schemas/tables/tests/ppas/12_plus/test.json A web/pgadmin/browser/server_groups/servers/databases/schemas/tables/tests/ppas/14_plus/create_table_with_lik_tbl_msql.sql A web/pgadmin/browser/server_groups/servers/databases/schemas/tables/tests/ppas/14_plus/test.json M web/pgadmin/browser/server_groups/servers/databases/schemas/tables/tests/ppas/default/alter_table_add_exclude_constraint.sql M web/pgadmin/browser/server_groups/servers/databases/schemas/tables/tests/ppas/default/alter_table_add_exclude_constraint_msql.sql M web/pgadmin/browser/server_groups/servers/databases/schemas/tables/tests/ppas/default/alter_table_update_grants.sql M web/pgadmin/browser/server_groups/servers/databases/schemas/tables/tests/ppas/default/create_table_with_lik_tbl_msql.sql M web/pgadmin/browser/server_groups/servers/databases/schemas/tables/tests/ppas/default/test.json M web/pgadmin/browser/server_groups/servers/databases/schemas/tables/tests/table_test_data.json M web/regression/javascript/schema_ui_files/table.ui.spec.js Log Message: --- Added all like options while creating a table. #6377
[pgadmin-org/pgadmin4] 00011b: Fixed issue where cycle syntax was not added in SQ...
Branch: refs/heads/master Home: https://github.com/pgadmin-org/pgadmin4 Commit: 00011b387a9470b81ab36ffa5993db4bcc0b6ba2 https://github.com/pgadmin-org/pgadmin4/commit/00011b387a9470b81ab36ffa5993db4bcc0b6ba2 Author: Pravesh Sharma Date: 2023-08-04 (Fri, 04 Aug 2023) Changed paths: M web/pgadmin/browser/server_groups/servers/databases/schemas/sequences/templates/sequences/sql/15_plus/create.sql M web/pgadmin/browser/server_groups/servers/databases/schemas/sequences/templates/sequences/sql/default/create.sql Log Message: --- Fixed issue where cycle syntax was not added in SQL when creating new sequence from UI. #6639
[pgadmin-org/pgadmin4] 5c2d24: Added unlogged option while creating a sequence. #...
Branch: refs/heads/master Home: https://github.com/pgadmin-org/pgadmin4 Commit: 5c2d242ff8a227172b046401e4bf318f3a24f45d https://github.com/pgadmin-org/pgadmin4/commit/5c2d242ff8a227172b046401e4bf318f3a24f45d Author: Pravesh Sharma Date: 2023-07-27 (Thu, 27 Jul 2023) Changed paths: M docs/en_US/images/sequence_definition.png M docs/en_US/sequence_dialog.rst M web/pgadmin/browser/server_groups/servers/databases/schemas/sequences/static/js/sequence.ui.js A web/pgadmin/browser/server_groups/servers/databases/schemas/sequences/templates/sequences/sql/15_plus/create.sql A web/pgadmin/browser/server_groups/servers/databases/schemas/sequences/templates/sequences/sql/15_plus/properties.sql A web/pgadmin/browser/server_groups/servers/databases/schemas/sequences/templates/sequences/sql/15_plus/update.sql A web/pgadmin/browser/server_groups/servers/databases/schemas/sequences/tests/pg/15_plus/alter_seq_set_logged.sql A web/pgadmin/browser/server_groups/servers/databases/schemas/sequences/tests/pg/15_plus/alter_seq_set_logged_msql.sql A web/pgadmin/browser/server_groups/servers/databases/schemas/sequences/tests/pg/15_plus/alter_seq_set_unlogged.sql A web/pgadmin/browser/server_groups/servers/databases/schemas/sequences/tests/pg/15_plus/alter_seq_set_unlogged_msql.sql A web/pgadmin/browser/server_groups/servers/databases/schemas/sequences/tests/pg/15_plus/create_unlogged_sequence.sql A web/pgadmin/browser/server_groups/servers/databases/schemas/sequences/tests/pg/15_plus/create_unlogged_sequence_msql.sql A web/pgadmin/browser/server_groups/servers/databases/schemas/sequences/tests/pg/15_plus/test_sequences_pg.json A web/pgadmin/browser/server_groups/servers/databases/schemas/sequences/tests/ppas/15_plus/alter_seq_set_logged.sql A web/pgadmin/browser/server_groups/servers/databases/schemas/sequences/tests/ppas/15_plus/alter_seq_set_logged_msql.sql A web/pgadmin/browser/server_groups/servers/databases/schemas/sequences/tests/ppas/15_plus/alter_seq_set_unlogged.sql A web/pgadmin/browser/server_groups/servers/databases/schemas/sequences/tests/ppas/15_plus/alter_seq_set_unlogged_msql.sql A web/pgadmin/browser/server_groups/servers/databases/schemas/sequences/tests/ppas/15_plus/create_unlogged_sequence.sql A web/pgadmin/browser/server_groups/servers/databases/schemas/sequences/tests/ppas/15_plus/create_unlogged_sequence_msql.sql A web/pgadmin/browser/server_groups/servers/databases/schemas/sequences/tests/ppas/15_plus/test_sequences_ppas.json M web/pgadmin/browser/server_groups/servers/databases/schemas/sequences/tests/test_sequence_add.py M web/pgadmin/browser/server_groups/servers/databases/schemas/sequences/tests/test_sequence_put.py Log Message: --- Added unlogged option while creating a sequence. #6376
[pgadmin-org/pgadmin4] b4991a: fixed issue where deduplicate_items was selected f...
Branch: refs/heads/master Home: https://github.com/pgadmin-org/pgadmin4 Commit: b4991a49a2aa15cde8afedbc290d074cb97d https://github.com/pgadmin-org/pgadmin4/commit/b4991a49a2aa15cde8afedbc290d074cb97d Author: Pravesh Sharma Date: 2023-07-17 (Mon, 17 Jul 2023) Changed paths: M web/pgadmin/browser/server_groups/servers/databases/schemas/tables/indexes/static/js/index.ui.js Log Message: --- fixed issue where deduplicate_items was selected for PG version 12 and below. #6374
[pgadmin-org/pgadmin4] ab0b1d: Added all supported index storage parameters while...
Branch: refs/heads/master Home: https://github.com/pgadmin-org/pgadmin4 Commit: ab0b1dd40c34763769647040b9672e5e01a70d25 https://github.com/pgadmin-org/pgadmin4/commit/ab0b1dd40c34763769647040b9672e5e01a70d25 Author: Pravesh Sharma Date: 2023-07-11 (Tue, 11 Jul 2023) Changed paths: M docs/en_US/index_dialog.rst M web/pgadmin/browser/server_groups/servers/databases/schemas/tables/indexes/__init__.py M web/pgadmin/browser/server_groups/servers/databases/schemas/tables/indexes/static/js/index.js M web/pgadmin/browser/server_groups/servers/databases/schemas/tables/indexes/static/js/index.ui.js A web/pgadmin/browser/server_groups/servers/databases/schemas/tables/indexes/tests/13_plus/create_btree_asc_null_first.sql A web/pgadmin/browser/server_groups/servers/databases/schemas/tables/indexes/tests/13_plus/create_btree_asc_null_first_msql.sql A web/pgadmin/browser/server_groups/servers/databases/schemas/tables/indexes/tests/13_plus/create_btree_asc_null_last.sql A web/pgadmin/browser/server_groups/servers/databases/schemas/tables/indexes/tests/13_plus/create_btree_asc_null_last_msql.sql A web/pgadmin/browser/server_groups/servers/databases/schemas/tables/indexes/tests/13_plus/create_btree_desc_null_last.sql A web/pgadmin/browser/server_groups/servers/databases/schemas/tables/indexes/tests/13_plus/create_btree_desc_null_last_msql.sql A web/pgadmin/browser/server_groups/servers/databases/schemas/tables/indexes/tests/13_plus/test_indexes.json M web/pgadmin/browser/server_groups/servers/databases/schemas/tables/indexes/tests/15_plus/alter_name_fillfactor_comment.sql M web/pgadmin/browser/server_groups/servers/databases/schemas/tables/indexes/tests/15_plus/create_btree_asc_null_first.sql M web/pgadmin/browser/server_groups/servers/databases/schemas/tables/indexes/tests/15_plus/create_btree_asc_null_first_msql.sql M web/pgadmin/browser/server_groups/servers/databases/schemas/tables/indexes/tests/15_plus/create_btree_asc_null_last.sql M web/pgadmin/browser/server_groups/servers/databases/schemas/tables/indexes/tests/15_plus/create_btree_asc_null_last_msql.sql M web/pgadmin/browser/server_groups/servers/databases/schemas/tables/indexes/tests/15_plus/create_btree_desc_null_last.sql M web/pgadmin/browser/server_groups/servers/databases/schemas/tables/indexes/tests/15_plus/create_btree_desc_null_last_msql.sql M web/pgadmin/browser/server_groups/servers/databases/schemas/tables/indexes/tests/default/alter_name_fillfactor_comment.sql M web/pgadmin/browser/server_groups/servers/databases/schemas/tables/indexes/tests/default/alter_name_fillfactor_comment_msql.sql M web/pgadmin/browser/server_groups/servers/databases/schemas/tables/indexes/tests/default/alter_reset_fillfactor_cluster_msql.sql M web/pgadmin/browser/server_groups/servers/databases/schemas/tables/indexes/tests/default/create_btree_asc_null_first.sql M web/pgadmin/browser/server_groups/servers/databases/schemas/tables/indexes/tests/default/create_btree_asc_null_first_msql.sql M web/pgadmin/browser/server_groups/servers/databases/schemas/tables/indexes/tests/default/create_btree_asc_null_last.sql M web/pgadmin/browser/server_groups/servers/databases/schemas/tables/indexes/tests/default/create_btree_asc_null_last_msql.sql M web/pgadmin/browser/server_groups/servers/databases/schemas/tables/indexes/tests/default/create_btree_desc_null_last.sql M web/pgadmin/browser/server_groups/servers/databases/schemas/tables/indexes/tests/default/create_btree_desc_null_last_msql.sql M web/pgadmin/browser/server_groups/servers/databases/schemas/tables/indexes/tests/index_test_data.json M web/pgadmin/browser/server_groups/servers/databases/schemas/tables/indexes/utils.py M web/pgadmin/browser/server_groups/servers/databases/schemas/tables/templates/indexes/sql/11_plus/create.sql A web/pgadmin/browser/server_groups/servers/databases/schemas/tables/templates/indexes/sql/11_plus/properties.sql A web/pgadmin/browser/server_groups/servers/databases/schemas/tables/templates/indexes/sql/13_plus/properties.sql M web/pgadmin/browser/server_groups/servers/databases/schemas/tables/templates/indexes/sql/15_plus/create.sql M web/pgadmin/browser/server_groups/servers/databases/schemas/tables/templates/indexes/sql/15_plus/properties.sql M web/pgadmin/browser/server_groups/servers/databases/schemas/tables/templates/indexes/sql/default/update.sql Log Message: --- Added all supported index storage parameters while creating an index. #6374
[pgadmin-org/pgadmin4] 62056c: Fixed sonaqube security smells and bugs
Branch: refs/heads/master Home: https://github.com/pgadmin-org/pgadmin4 Commit: 62056cab14e52017dd3a4c9a81ccc5a36508da65 https://github.com/pgadmin-org/pgadmin4/commit/62056cab14e52017dd3a4c9a81ccc5a36508da65 Author: Pravesh Sharma Date: 2023-07-10 (Mon, 10 Jul 2023) Changed paths: M runtime/src/js/pgadmin.js M web/pgadmin/__init__.py M web/pgadmin/authenticate/mfa/authenticator.py M web/pgadmin/browser/server_groups/servers/databases/casts/static/js/cast.ui.js M web/pgadmin/browser/server_groups/servers/databases/publications/__init__.py M web/pgadmin/browser/server_groups/servers/databases/schemas/domains/static/js/domain.ui.js M web/pgadmin/browser/server_groups/servers/databases/schemas/synonyms/static/js/synonym.ui.js M web/pgadmin/browser/server_groups/servers/static/js/server.js M web/pgadmin/static/js/pgadmin.js M web/regression/javascript/SecurityPages/ForgotPasswordPage.spec.js M web/regression/javascript/SecurityPages/LoginPage.spec.js M web/regression/javascript/SecurityPages/MfaRegisterPage.spec.js M web/regression/javascript/SecurityPages/MfaValidatePage.spec.js M web/regression/javascript/SecurityPages/PasswordResetPage.spec.js Log Message: --- Fixed sonaqube security smells and bugs 1. Delete unreachable code or refactor the code to make it reachable. 2. Unexpected var, use let or const instead. 3. Remove useless assignment to variable. 4. Define a constant instead of duplicating the literal 5. Remove commented out code
[pgadmin-org/pgadmin4] 595a0d: Added 'OR REPLACE' clause while creating trigger. ...
Branch: refs/heads/master Home: https://github.com/pgadmin-org/pgadmin4 Commit: 595a0dfc55ef29112e33512caeef05384fc04176 https://github.com/pgadmin-org/pgadmin4/commit/595a0dfc55ef29112e33512caeef05384fc04176 Author: Pravesh Sharma Date: 2023-06-21 (Wed, 21 Jun 2023) Changed paths: A web/pgadmin/browser/server_groups/servers/databases/schemas/tables/constraints/index_constraint/tests/15_plus/alter_unique_constraint.sql A web/pgadmin/browser/server_groups/servers/databases/schemas/tables/constraints/index_constraint/tests/15_plus/alter_unique_reset_fillfactor.sql A web/pgadmin/browser/server_groups/servers/databases/schemas/tables/constraints/index_constraint/tests/15_plus/test_primary_key.json M web/pgadmin/browser/server_groups/servers/databases/schemas/tables/constraints/index_constraint/tests/15_plus/test_unique_constraint.json A web/pgadmin/browser/server_groups/servers/databases/schemas/tables/indexes/tests/15_plus/alter_name_fillfactor_comment.sql A web/pgadmin/browser/server_groups/servers/databases/schemas/tables/indexes/tests/15_plus/alter_reset_fillfactor_cluster.sql M web/pgadmin/browser/server_groups/servers/databases/schemas/tables/indexes/tests/15_plus/test_indexes.json A web/pgadmin/browser/server_groups/servers/databases/schemas/tables/templates/triggers/sql/pg/14_plus/create.sql A web/pgadmin/browser/server_groups/servers/databases/schemas/tables/templates/triggers/sql/pg/14_plus/update.sql A web/pgadmin/browser/server_groups/servers/databases/schemas/tables/templates/triggers/sql/ppas/14_plus/create.sql A web/pgadmin/browser/server_groups/servers/databases/schemas/tables/templates/triggers/sql/ppas/14_plus/update.sql A web/pgadmin/browser/server_groups/servers/databases/schemas/tables/triggers/tests/pg/14_plus/alter_after_delete_event_trigger_with_transition.sql A web/pgadmin/browser/server_groups/servers/databases/schemas/tables/triggers/tests/pg/14_plus/alter_after_insert_event_trigger_with_transition.sql A web/pgadmin/browser/server_groups/servers/databases/schemas/tables/triggers/tests/pg/14_plus/alter_before_insert_event_trigger.sql A web/pgadmin/browser/server_groups/servers/databases/schemas/tables/triggers/tests/pg/14_plus/alter_before_update_event_trigger_enable_replica.sql A web/pgadmin/browser/server_groups/servers/databases/schemas/tables/triggers/tests/pg/14_plus/create_after_delete_event_trigger_with_transition.sql A web/pgadmin/browser/server_groups/servers/databases/schemas/tables/triggers/tests/pg/14_plus/create_after_delete_event_trigger_with_transition_msql.sql A web/pgadmin/browser/server_groups/servers/databases/schemas/tables/triggers/tests/pg/14_plus/create_after_insert_event_trigger_with_transition.sql A web/pgadmin/browser/server_groups/servers/databases/schemas/tables/triggers/tests/pg/14_plus/create_after_insert_event_trigger_with_transition_msql.sql A web/pgadmin/browser/server_groups/servers/databases/schemas/tables/triggers/tests/pg/14_plus/create_b4r_update_multiple_event_trigger.sql A web/pgadmin/browser/server_groups/servers/databases/schemas/tables/triggers/tests/pg/14_plus/create_b4r_update_multiple_event_trigger_msql.sql A web/pgadmin/browser/server_groups/servers/databases/schemas/tables/triggers/tests/pg/14_plus/create_before_insert_event_at_statement.sql A web/pgadmin/browser/server_groups/servers/databases/schemas/tables/triggers/tests/pg/14_plus/create_before_insert_event_at_statement_msql.sql A web/pgadmin/browser/server_groups/servers/databases/schemas/tables/triggers/tests/pg/14_plus/create_before_insert_event_trigger.sql A web/pgadmin/browser/server_groups/servers/databases/schemas/tables/triggers/tests/pg/14_plus/create_before_insert_event_trigger_msql.sql A web/pgadmin/browser/server_groups/servers/databases/schemas/tables/triggers/tests/pg/14_plus/create_before_update_event_trigger.sql A web/pgadmin/browser/server_groups/servers/databases/schemas/tables/triggers/tests/pg/14_plus/create_before_update_event_trigger_msql.sql A web/pgadmin/browser/server_groups/servers/databases/schemas/tables/triggers/tests/pg/14_plus/test.json A web/pgadmin/browser/server_groups/servers/databases/schemas/tables/triggers/tests/ppas/14_plus/alter_after_delete_event_trigger_with_transition.sql A web/pgadmin/browser/server_groups/servers/databases/schemas/tables/triggers/tests/ppas/14_plus/alter_after_insert_event_trigger_with_transition.sql A web/pgadmin/browser/server_groups/servers/databases/schemas/tables/triggers/tests/ppas/14_plus/alter_before_insert_event_trigger.sql A web/pgadmin/browser/server_groups/servers/databases/schemas/tables/triggers/tests/ppas/14_plus/alter_before_update_event_trigger_enable_replica.sql A web/pgadmin/browser/server_groups/servers/databases/schemas/tables/triggers/tests/ppas/14_plus/create_after_delete_event_trigger_with_transition.sql A
[pgadmin-org/pgadmin4] 36949a: Added option to create unique index with nulls not...
Branch: refs/heads/master Home: https://github.com/pgadmin-org/pgadmin4 Commit: 36949aef996b919a8f75ac160fceed8cc42448cb https://github.com/pgadmin-org/pgadmin4/commit/36949aef996b919a8f75ac160fceed8cc42448cb Author: Pravesh Sharma Date: 2023-06-19 (Mon, 19 Jun 2023) Changed paths: M docs/en_US/images/index_definition.png M docs/en_US/images/unique_constraint_definition.png M docs/en_US/index_dialog.rst M docs/en_US/unique_constraint_dialog.rst M web/pgadmin/browser/server_groups/servers/databases/schemas/tables/indexes/__init__.py M web/pgadmin/browser/server_groups/servers/databases/schemas/tables/indexes/static/js/index.ui.js A web/pgadmin/browser/server_groups/servers/databases/schemas/tables/indexes/tests/15_plus/create_btree_asc_null_first.sql A web/pgadmin/browser/server_groups/servers/databases/schemas/tables/indexes/tests/15_plus/create_btree_asc_null_first_msql.sql A web/pgadmin/browser/server_groups/servers/databases/schemas/tables/indexes/tests/15_plus/create_btree_asc_null_last.sql A web/pgadmin/browser/server_groups/servers/databases/schemas/tables/indexes/tests/15_plus/create_btree_asc_null_last_msql.sql A web/pgadmin/browser/server_groups/servers/databases/schemas/tables/indexes/tests/15_plus/create_btree_desc_null_first.sql A web/pgadmin/browser/server_groups/servers/databases/schemas/tables/indexes/tests/15_plus/create_btree_desc_null_first_msql.sql A web/pgadmin/browser/server_groups/servers/databases/schemas/tables/indexes/tests/15_plus/create_btree_desc_null_last.sql A web/pgadmin/browser/server_groups/servers/databases/schemas/tables/indexes/tests/15_plus/create_btree_desc_null_last_msql.sql A web/pgadmin/browser/server_groups/servers/databases/schemas/tables/indexes/tests/15_plus/test_indexes.json M web/pgadmin/browser/server_groups/servers/databases/schemas/tables/indexes/tests/index_test_data.json M web/pgadmin/browser/server_groups/servers/databases/schemas/tables/indexes/tests/test_indexes_add.py A web/pgadmin/browser/server_groups/servers/databases/schemas/tables/templates/indexes/sql/15_plus/create.sql A web/pgadmin/browser/server_groups/servers/databases/schemas/tables/templates/indexes/sql/15_plus/properties.sql Log Message: --- Added option to create unique index with nulls not distinct. #6368
[pgadmin-org/pgadmin4] 644467: Add a precautionary fix to handle connection timeo...
Branch: refs/heads/master Home: https://github.com/pgadmin-org/pgadmin4 Commit: 64446790d32d618e614cf9665dc3749136e3 https://github.com/pgadmin-org/pgadmin4/commit/64446790d32d618e614cf9665dc3749136e3 Author: Pravesh Sharma Date: 2023-06-14 (Wed, 14 Jun 2023) Changed paths: M web/pgadmin/tools/sqleditor/static/js/components/sections/ResultSet.jsx Log Message: --- Add a precautionary fix to handle connection timeout issue when fetching more rows in query tool grid. #6291
[pgadmin-org/pgadmin4] 3e713c: Fixed an issue where preview images for themes wer...
Branch: refs/heads/master Home: https://github.com/pgadmin-org/pgadmin4 Commit: 3e713cf58b36f2f1bb10c944b9acbe184d204504 https://github.com/pgadmin-org/pgadmin4/commit/3e713cf58b36f2f1bb10c944b9acbe184d204504 Author: Pravesh Sharma Date: 2023-06-12 (Mon, 12 Jun 2023) Changed paths: M web/webpack.config.js M web/webpack.test.config.js Log Message: --- Fixed an issue where preview images for themes were not loading in preferences. #6363
[pgadmin-org/pgadmin4] f4ea95: Fixed few query tool query tool shortcuts. #6065
Branch: refs/heads/master Home: https://github.com/pgadmin-org/pgadmin4 Commit: f4ea95da124a884d5b5dd6e68b6cd40331f857e8 https://github.com/pgadmin-org/pgadmin4/commit/f4ea95da124a884d5b5dd6e68b6cd40331f857e8 Author: Pravesh Sharma Date: 2023-06-09 (Fri, 09 Jun 2023) Changed paths: M web/pgadmin/tools/sqleditor/static/js/components/QueryToolComponent.jsx M web/pgadmin/tools/sqleditor/static/js/components/sections/ResultSetToolbar.jsx M web/pgadmin/tools/sqleditor/utils/query_tool_preferences.py Log Message: --- Fixed few query tool query tool shortcuts. #6065
[pgadmin-org/pgadmin4] bfa859: Fixed an issue where PSQL tool prompts for passwor...
Branch: refs/heads/master Home: https://github.com/pgadmin-org/pgadmin4 Commit: bfa859e9cecf5b1a64478faef51659ebd74f1846 https://github.com/pgadmin-org/pgadmin4/commit/bfa859e9cecf5b1a64478faef51659ebd74f1846 Author: Pravesh Sharma Date: 2023-05-23 (Tue, 23 May 2023) Changed paths: M web/pgadmin/utils/driver/psycopg3/server_manager.py Log Message: --- Fixed an issue where PSQL tool prompts for password if using password exec command. #6247
[pgadmin-org/pgadmin4] 4b183f: Fixed resql test case. #5926
Branch: refs/heads/master Home: https://github.com/pgadmin-org/pgadmin4 Commit: 4b183f7988b770cf0afd7cdc0400a3fc96acd0a0 https://github.com/pgadmin-org/pgadmin4/commit/4b183f7988b770cf0afd7cdc0400a3fc96acd0a0 Author: Pravesh Sharma Date: 2023-05-22 (Mon, 22 May 2023) Changed paths: M web/pgadmin/browser/server_groups/servers/databases/schemas/tables/tests/ppas/12_plus/alter_table_update_grants.sql Log Message: --- Fixed resql test case. #5926
[pgadmin-org/pgadmin4] e04f5a: Fixed an issue where REVOKE ALL DDL in table SQL w...
Branch: refs/heads/master Home: https://github.com/pgadmin-org/pgadmin4 Commit: e04f5a0938ecd2aa627372c188bb26c959488dc4 https://github.com/pgadmin-org/pgadmin4/commit/e04f5a0938ecd2aa627372c188bb26c959488dc4 Author: Pravesh Sharma Date: 2023-05-22 (Mon, 22 May 2023) Changed paths: M web/pgadmin/browser/server_groups/servers/databases/schemas/tables/utils.py Log Message: --- Fixed an issue where REVOKE ALL DDL in table SQL was added only for one role. #5926
[pgadmin-org/pgadmin4] c06728: Fixed an issue where win 10 was not showing pgAdmi...
Branch: refs/heads/master Home: https://github.com/pgadmin-org/pgadmin4 Commit: c06728901208b871f4e7b3e906e5264fd1583ec5 https://github.com/pgadmin-org/pgadmin4/commit/c06728901208b871f4e7b3e906e5264fd1583ec5 Author: Pravesh Sharma Date: 2023-05-15 (Mon, 15 May 2023) Changed paths: M Make.bat M pkg/linux/build-functions.sh M pkg/mac/build-functions.sh M runtime/package.json M runtime/yarn.lock Log Message: --- Fixed an issue where win 10 was not showing pgAdmin icon on taskbar for NW.js v0.73 and above. #6080
[pgadmin-org/pgadmin4] 2ec460: Fix the browser tree state that is not remembered ...
Branch: refs/heads/master Home: https://github.com/pgadmin-org/pgadmin4 Commit: 2ec460bf8f5f8daf69756e2073f3ca45c350fd67 https://github.com/pgadmin-org/pgadmin4/commit/2ec460bf8f5f8daf69756e2073f3ca45c350fd67 Author: Pravesh Sharma Date: 2023-05-11 (Thu, 11 May 2023) Changed paths: M web/pgadmin/static/js/tree/pgadmin_tree_save_state.js Log Message: --- Fix the browser tree state that is not remembered when reopening pgAdmin. #5777
[pgadmin-org/pgadmin4] 861c66: Ensure that when pasting a row in query tool grid,...
Branch: refs/heads/master Home: https://github.com/pgadmin-org/pgadmin4 Commit: 861c66d180c5bd15873cb82e5c6dd4ca343808df https://github.com/pgadmin-org/pgadmin4/commit/861c66d180c5bd15873cb82e5c6dd4ca343808df Author: Pravesh Sharma Date: 2023-04-26 (Wed, 26 Apr 2023) Changed paths: M docs/en_US/images/query_data_editing.png M docs/en_US/query_tool_toolbar.rst M web/pgadmin/browser/server_groups/servers/databases/schemas/tables/templates/columns/sql/default/nodes.sql M web/pgadmin/tools/sqleditor/static/js/components/sections/ResultSet.jsx M web/pgadmin/tools/sqleditor/static/js/components/sections/ResultSetToolbar.jsx M web/pgadmin/tools/sqleditor/utils/get_column_types.py Log Message: --- Ensure that when pasting a row in query tool grid, default value is used for autogenerated/serial columns. #5922
[pgadmin-org/pgadmin4] 288ba1: Fixed an issue where collation was set to none if ...
Branch: refs/heads/master Home: https://github.com/pgadmin-org/pgadmin4 Commit: 288ba1d1f90e575a6f9415001fb1b3bdb85659d4 https://github.com/pgadmin-org/pgadmin4/commit/288ba1d1f90e575a6f9415001fb1b3bdb85659d4 Author: Pravesh Sharma Date: 2023-04-13 (Thu, 13 Apr 2023) Changed paths: M web/pgadmin/browser/server_groups/servers/databases/schemas/collations/__init__.py M web/pgadmin/browser/server_groups/servers/databases/schemas/tables/utils.py Log Message: --- Fixed an issue where collation was set to none if we remove it while creating partitioned table. #5820
[pgadmin-org/pgadmin4] c2a54f: Fixed an issue where browser tree state is not rem...
Branch: refs/heads/master Home: https://github.com/pgadmin-org/pgadmin4 Commit: c2a54f3524ffd00ab2a32b19f7ff013100d1dec7 https://github.com/pgadmin-org/pgadmin4/commit/c2a54f3524ffd00ab2a32b19f7ff013100d1dec7 Author: Pravesh Sharma Date: 2023-04-13 (Thu, 13 Apr 2023) Changed paths: M web/pgadmin/static/js/tree/pgadmin_tree_save_state.js Log Message: --- Fixed an issue where browser tree state is not remembered when reopening pgAdmin. #5777
[pgadmin-org/pgadmin4] 097080: Ensure that save button is enabled when registerin...
Branch: refs/heads/master Home: https://github.com/pgadmin-org/pgadmin4 Commit: 097080ba97afad5efbf71ffdd3519feb2350e4f9 https://github.com/pgadmin-org/pgadmin4/commit/097080ba97afad5efbf71ffdd3519feb2350e4f9 Author: Pravesh Sharma Date: 2023-04-13 (Thu, 13 Apr 2023) Changed paths: M web/pgadmin/static/js/SchemaView/index.jsx Log Message: --- Ensure that save button is enabled when registering new server fails due to API error. #6075 Incorporated review comments
[pgadmin-org/pgadmin4] 6c7116: Fix an issue where insert was failing when copy pa...
Branch: refs/heads/master Home: https://github.com/pgadmin-org/pgadmin4 Commit: 6c7116a20c932c8d383cc7aaa551f86d81c5aa37 https://github.com/pgadmin-org/pgadmin4/commit/6c7116a20c932c8d383cc7aaa551f86d81c5aa37 Author: Pravesh Sharma Date: 2023-04-03 (Mon, 03 Apr 2023) Changed paths: M web/pgadmin/tools/sqleditor/static/js/components/sections/ResultSet.jsx Log Message: --- Fix an issue where insert was failing when copy pasting a row and saving in result grid. #5934
[pgadmin-org/pgadmin4] eef746: Ensure that default values are set only for insert...
Branch: refs/heads/master Home: https://github.com/pgadmin-org/pgadmin4 Commit: eef7461ae639c9e6d2d3786c10f8aad2f6834a4f https://github.com/pgadmin-org/pgadmin4/commit/eef7461ae639c9e6d2d3786c10f8aad2f6834a4f Author: Pravesh Sharma Date: 2023-03-27 (Mon, 27 Mar 2023) Changed paths: M web/pgadmin/tools/sqleditor/static/js/components/sections/ResultSet.jsx M web/pgadmin/tools/sqleditor/templates/sqleditor/sql/default/insert.sql M web/pgadmin/tools/sqleditor/utils/save_changed_data.py Log Message: --- Ensure that default values are set only for insert statement if user does not provide any values, in case of updating existing values to blank it should be set to null. #5934 Incorporated review comments
[pgadmin-org/pgadmin4] a93990: Fixed issue where pgAgent jobs were not getting dr...
Branch: refs/heads/master Home: https://github.com/pgadmin-org/pgadmin4 Commit: a9399030f4c70fd967ea325b9aaff631681f55f4 https://github.com/pgadmin-org/pgadmin4/commit/a9399030f4c70fd967ea325b9aaff631681f55f4 Author: Pravesh Sharma Date: 2023-03-17 (Fri, 17 Mar 2023) Changed paths: M web/pgadmin/misc/properties/CollectionNodeProperties.jsx Log Message: --- Fixed issue where pgAgent jobs were not getting dropped from properties tab #5834
[pgadmin-org/pgadmin4] 89c8a7: Added option to create unique constraint with null...
Branch: refs/heads/master Home: https://github.com/pgadmin-org/pgadmin4 Commit: 89c8a7f907ba186c78c7cba8f571a03621b97e88 https://github.com/pgadmin-org/pgadmin4/commit/89c8a7f907ba186c78c7cba8f571a03621b97e88 Author: Pravesh Sharma Date: 2023-03-15 (Wed, 15 Mar 2023) Changed paths: M web/pgadmin/browser/server_groups/servers/databases/schemas/tables/constraints/index_constraint/static/js/primary_key.ui.js M web/pgadmin/browser/server_groups/servers/databases/schemas/tables/constraints/index_constraint/static/js/unique_constraint.ui.js A web/pgadmin/browser/server_groups/servers/databases/schemas/tables/constraints/index_constraint/tests/15_plus/create_unique_constraint.sql A web/pgadmin/browser/server_groups/servers/databases/schemas/tables/constraints/index_constraint/tests/15_plus/create_unique_constraint_msql.sql A web/pgadmin/browser/server_groups/servers/databases/schemas/tables/constraints/index_constraint/tests/15_plus/test_unique_constraint.json M web/pgadmin/browser/server_groups/servers/databases/schemas/tables/constraints/index_constraint/tests/index_constraint_test_data.json M web/pgadmin/browser/server_groups/servers/databases/schemas/tables/constraints/index_constraint/tests/test_index_constraint_add.py A web/pgadmin/browser/server_groups/servers/databases/schemas/tables/templates/index_constraint/sql/15_plus/create.sql A web/pgadmin/browser/server_groups/servers/databases/schemas/tables/templates/index_constraint/sql/15_plus/properties.sql M web/pgadmin/browser/server_groups/servers/databases/schemas/tables/templates/tables/sql/macros/constraints.macro M web/pgadmin/browser/server_groups/servers/databases/subscriptions/static/js/subscription.ui.js M web/pgadmin/tools/backup/static/js/backup.ui.js M web/pgadmin/tools/restore/static/js/restore.ui.js Log Message: --- Added option to create unique constraint with nulls not distinct. #5855
[pgadmin-org/pgadmin4] 59b478: Fixed an issue where user MFA entry was not gettin...
Branch: refs/heads/master Home: https://github.com/pgadmin-org/pgadmin4 Commit: 59b47847d71081a467a6003f1fb2dbeea8e4c55c https://github.com/pgadmin-org/pgadmin4/commit/59b47847d71081a467a6003f1fb2dbeea8e4c55c Author: Pravesh Sharma Date: 2023-02-27 (Mon, 27 Feb 2023) Changed paths: M web/pgadmin/model/__init__.py Log Message: --- Fixed an issue where user MFA entry was not getting delete after deleting a user. #5833
[pgadmin-org/pgadmin4] b1e6ea: Fixed an issue where query was not pasted to edito...
Branch: refs/heads/master Home: https://github.com/pgadmin-org/pgadmin4 Commit: b1e6eaad61c7dfb323c2b97721a7de1f513d1446 https://github.com/pgadmin-org/pgadmin4/commit/b1e6eaad61c7dfb323c2b97721a7de1f513d1446 Author: Pravesh Sharma Date: 2023-02-20 (Mon, 20 Feb 2023) Changed paths: M web/pgadmin/static/js/components/CodeMirror.jsx Log Message: --- Fixed an issue where query was not pasted to editor after trojan source warning. #5760
[pgadmin-org/pgadmin4] 8388f1: Fix for query tool prompting for unsaved changes e...
Branch: refs/heads/master Home: https://github.com/pgadmin-org/pgadmin4 Commit: 8388f1e7ba9e44696157039c803163a8843e4cd8 https://github.com/pgadmin-org/pgadmin4/commit/8388f1e7ba9e44696157039c803163a8843e4cd8 Author: Pravesh Sharma Date: 2023-02-14 (Tue, 14 Feb 2023) Changed paths: M web/pgadmin/tools/sqleditor/static/js/components/QueryToolComponent.jsx Log Message: --- Fix for query tool prompting for unsaved changes even if no changes have been made. #5756
[pgadmin-org/pgadmin4] ff6f08: Fixed an issue where lock layout menu was not in s...
Branch: refs/heads/master Home: https://github.com/pgadmin-org/pgadmin4 Commit: ff6f0825b89c042abc6c7c75b0073c9b93a579c3 https://github.com/pgadmin-org/pgadmin4/commit/ff6f0825b89c042abc6c7c75b0073c9b93a579c3 Author: Pravesh Sharma Date: 2023-02-10 (Fri, 10 Feb 2023) Changed paths: M web/pgadmin/browser/__init__.py M web/pgadmin/browser/templates/browser/js/utils.js M web/pgadmin/preferences/static/js/components/PreferencesComponent.jsx Log Message: --- Fixed an issue where lock layout menu was not in sync with preferences. #5758
[pgadmin-org/pgadmin4] e24786: Incorporated review comments for #5705
Branch: refs/heads/master Home: https://github.com/pgadmin-org/pgadmin4 Commit: e247867abf75d8f0e489b449f5ce7bd9b2458928 https://github.com/pgadmin-org/pgadmin4/commit/e247867abf75d8f0e489b449f5ce7bd9b2458928 Author: Pravesh Sharma Date: 2023-02-01 (Wed, 01 Feb 2023) Changed paths: M docs/en_US/change_password_dialog.rst M docs/en_US/change_user_password.rst M web/config.py M web/pgadmin/__init__.py M web/pgadmin/browser/__init__.py M web/pgadmin/browser/templates/browser/js/utils.js M web/pgadmin/setup/user_info.py M web/pgadmin/tools/user_management/static/js/UserManagementDialog.jsx Log Message: --- Incorporated review comments for #5705
[pgadmin-org/pgadmin4] 9c4573: Ensure that all parts of the application recommend...
Branch: refs/heads/master Home: https://github.com/pgadmin-org/pgadmin4 Commit: 9c4573fd807d29ef2077a9c79be597fad54c1f3e https://github.com/pgadmin-org/pgadmin4/commit/9c4573fd807d29ef2077a9c79be597fad54c1f3e Author: Pravesh Sharma Date: 2023-01-17 (Tue, 17 Jan 2023) Changed paths: M web/config.py Log Message: --- Ensure that all parts of the application recommend and enforce the same length of passwords. #5705
[pgadmin-org/pgadmin4] af2fc3: Fixed an issue where rename panel was losing focus...
Branch: refs/heads/master Home: https://github.com/pgadmin-org/pgadmin4 Commit: af2fc30b952227cf3f2e3026f27ff70d70fb6a03 https://github.com/pgadmin-org/pgadmin4/commit/af2fc30b952227cf3f2e3026f27ff70d70fb6a03 Author: Pravesh Sharma Date: 2023-01-05 (Thu, 05 Jan 2023) Changed paths: M web/pgadmin/static/js/Dialogs/RenamePanelContent.jsx Log Message: --- Fixed an issue where rename panel was losing focus when trying to add name if input box is empty. #5675
[pgadmin-org/pgadmin4] e987b3: Fixed jasmine test case failure.
Branch: refs/heads/master Home: https://github.com/pgadmin-org/pgadmin4 Commit: e987b3074dc39fab040394cb911cc58d15296087 https://github.com/pgadmin-org/pgadmin4/commit/e987b3074dc39fab040394cb911cc58d15296087 Author: Pravesh Sharma Date: 2023-01-03 (Tue, 03 Jan 2023) Changed paths: M web/regression/javascript/table/enable_disable_triggers_spec.js Log Message: --- Fixed jasmine test case failure.
[pgadmin-org/pgadmin4] 33aea8: Incorporated review comments. #5647
Branch: refs/heads/master Home: https://github.com/pgadmin-org/pgadmin4 Commit: 33aea87deaaeeb4142d465c61b9eeff09b9f1218 https://github.com/pgadmin-org/pgadmin4/commit/33aea87deaaeeb4142d465c61b9eeff09b9f1218 Author: Pravesh Sharma Date: 2023-01-02 (Mon, 02 Jan 2023) Changed paths: M web/pgadmin/browser/server_groups/servers/databases/schemas/tables/__init__.py M web/pgadmin/browser/server_groups/servers/databases/schemas/tables/static/js/table.js M web/pgadmin/browser/static/js/node_view.jsx M web/pgadmin/static/js/SchemaView/index.jsx M web/pgadmin/static/js/helpers/Notifier.jsx Log Message: --- Incorporated review comments. #5647
[pgadmin-org/pgadmin4] 67bc0c: Fixed an issue where row count notification was di...
Branch: refs/heads/master Home: https://github.com/pgadmin-org/pgadmin4 Commit: 67bc0c23ef953a01d735514393e81d8c8ce496b1 https://github.com/pgadmin-org/pgadmin4/commit/67bc0c23ef953a01d735514393e81d8c8ce496b1 Author: Pravesh Sharma Date: 2023-01-02 (Mon, 02 Jan 2023) Changed paths: M web/pgadmin/browser/server_groups/servers/databases/schemas/tables/static/js/table.js M web/pgadmin/browser/static/js/node_view.jsx M web/pgadmin/static/js/SchemaView/index.jsx M web/pgadmin/static/js/helpers/Notifier.jsx Log Message: --- Fixed an issue where row count notification was disappearing automatically. #5647
[pgadmin-org/pgadmin4] cc9d51: Incorporate review comments.
Branch: refs/heads/master Home: https://github.com/pgadmin-org/pgadmin4 Commit: cc9d519fac62872fb1613bbdab507a552bca33ba https://github.com/pgadmin-org/pgadmin4/commit/cc9d519fac62872fb1613bbdab507a552bca33ba Author: Pravesh Sharma Date: 2022-12-14 (Wed, 14 Dec 2022) Changed paths: M web/pgadmin/browser/static/js/node_view.jsx M web/pgadmin/static/js/SchemaView/index.jsx Log Message: --- Incorporate review comments.
[pgadmin-org/pgadmin4] 3f0eee: Fixed an issue where properties tab was refreshing...
Branch: refs/heads/master Home: https://github.com/pgadmin-org/pgadmin4 Commit: 3f0eee4c39d0054cfb532ee14ba24762ecddb284 https://github.com/pgadmin-org/pgadmin4/commit/3f0eee4c39d0054cfb532ee14ba24762ecddb284 Author: Pravesh Sharma Date: 2022-12-14 (Wed, 14 Dec 2022) Changed paths: M web/pgadmin/browser/static/js/node.js M web/pgadmin/browser/static/js/node_view.jsx M web/pgadmin/static/js/SchemaView/index.jsx Log Message: --- Fixed an issue where properties tab was refreshing on tab change even if the selected node is same. #5536
[pgadmin-org/pgadmin4] d7eb9f: Fixed RESQL test case failure. #5470
Branch: refs/heads/master Home: https://github.com/pgadmin-org/pgadmin4 Commit: d7eb9f723fd2a984fe2dd3a9d94bdf01247cd489 https://github.com/pgadmin-org/pgadmin4/commit/d7eb9f723fd2a984fe2dd3a9d94bdf01247cd489 Author: Pravesh Sharma Date: 2022-12-09 (Fri, 09 Dec 2022) Changed paths: M web/pgadmin/browser/server_groups/servers/databases/schemas/tables/tests/pg/default/create_partition_table_with_collate.sql M web/pgadmin/browser/server_groups/servers/databases/schemas/tables/tests/pg/default/create_table_with_partition.sql M web/pgadmin/browser/server_groups/servers/databases/schemas/tables/tests/pg/default/create_table_with_range_partition.sql M web/pgadmin/browser/server_groups/servers/databases/schemas/tables/tests/ppas/11_plus/create_partition_table_with_collate.sql M web/pgadmin/browser/server_groups/servers/databases/schemas/tables/tests/ppas/11_plus/create_table_with_hash_partition.sql M web/pgadmin/browser/server_groups/servers/databases/schemas/tables/tests/ppas/12_plus/create_partition_table_with_collate.sql M web/pgadmin/browser/server_groups/servers/databases/schemas/tables/tests/ppas/12_plus/create_table_with_hash_partition.sql M web/pgadmin/browser/server_groups/servers/databases/schemas/tables/tests/ppas/12_plus/create_table_with_partition.sql M web/pgadmin/browser/server_groups/servers/databases/schemas/tables/tests/ppas/12_plus/create_table_with_range_partition.sql M web/pgadmin/browser/server_groups/servers/databases/schemas/tables/tests/ppas/default/create_partition_table_with_collate.sql M web/pgadmin/browser/server_groups/servers/databases/schemas/tables/tests/ppas/default/create_table_with_partition.sql M web/pgadmin/browser/server_groups/servers/databases/schemas/tables/tests/ppas/default/create_table_with_range_partition.sql Log Message: --- Fixed RESQL test case failure. #5470
[pgadmin-org/pgadmin4] c42a90: Fixed an issue where tablespace was missing on par...
Branch: refs/heads/master Home: https://github.com/pgadmin-org/pgadmin4 Commit: c42a90db8ab0ed133bb8ca1460df3f20eb57a6c5 https://github.com/pgadmin-org/pgadmin4/commit/c42a90db8ab0ed133bb8ca1460df3f20eb57a6c5 Author: Pravesh Sharma Date: 2022-12-08 (Thu, 08 Dec 2022) Changed paths: M web/pgadmin/browser/server_groups/servers/databases/schemas/tables/partitions/__init__.py M web/pgadmin/browser/server_groups/servers/databases/schemas/tables/partitions/tests/pg/10_plus/alter_table_add_partition.sql M web/pgadmin/browser/server_groups/servers/databases/schemas/tables/partitions/tests/pg/12_plus/alter_table_add_partition.sql M web/pgadmin/browser/server_groups/servers/databases/schemas/tables/partitions/tests/ppas/10_plus/alter_table_add_partition.sql M web/pgadmin/browser/server_groups/servers/databases/schemas/tables/partitions/tests/ppas/12_plus/alter_table_add_partition.sql M web/pgadmin/browser/server_groups/servers/databases/schemas/tables/templates/partitions/sql/pg/default/nodes.sql M web/pgadmin/browser/server_groups/servers/databases/schemas/tables/templates/partitions/sql/ppas/default/nodes.sql M web/pgadmin/browser/server_groups/servers/databases/schemas/tables/utils.py Log Message: --- Fixed an issue where tablespace was missing on partition tables in SQL. #5470
[pgadmin-org/pgadmin4] a824d9: Improved error message to make it easier for users...
Branch: refs/heads/master Home: https://github.com/pgadmin-org/pgadmin4 Commit: a824d9dd59eceb10537a8ea06c26f84245fc5807 https://github.com/pgadmin-org/pgadmin4/commit/a824d9dd59eceb10537a8ea06c26f84245fc5807 Author: Pravesh Sharma Date: 2022-11-29 (Tue, 29 Nov 2022) Changed paths: M web/pgadmin/browser/static/js/node_view.jsx M web/pgadmin/misc/sql/static/js/SQL.jsx Log Message: --- Improved error message to make it easier for users to understand. #5539
[pgadmin-org/pgadmin4] a954f2: Fixed an issue where the CSV file would not downlo...
Branch: refs/heads/master Home: https://github.com/pgadmin-org/pgadmin4 Commit: a954f22fe86d7c68635cbe4b1e1558468c29096c https://github.com/pgadmin-org/pgadmin4/commit/a954f22fe86d7c68635cbe4b1e1558468c29096c Author: Pravesh Sharma Date: 2022-11-28 (Mon, 28 Nov 2022) Changed paths: M web/pgadmin/static/js/components/FormComponents.jsx M web/pgadmin/tools/sqleditor/utils/query_tool_preferences.py Log Message: --- Fixed an issue where the CSV file would not download if the CSV quote character length exceeded 1. #5505
[pgadmin-org/pgadmin4] a305c0: Fixed an issue where editor position was wrong whe...
Branch: refs/heads/master Home: https://github.com/pgadmin-org/pgadmin4 Commit: a305c032384564672f61503db973080b43037307 https://github.com/pgadmin-org/pgadmin4/commit/a305c032384564672f61503db973080b43037307 Author: Pravesh Sharma Date: 2022-11-25 (Fri, 25 Nov 2022) Changed paths: M web/pgadmin/tools/sqleditor/static/js/components/QueryToolDataGrid/Editors.jsx Log Message: --- Fixed an issue where editor position was wrong when editing data from result grid. #5548
[pgadmin-org/pgadmin4] e701da: Fixed an issue where the editor was not visible in...
Branch: refs/heads/master Home: https://github.com/pgadmin-org/pgadmin4 Commit: e701da739031ed985af7b0d8254669ecd54aa78f https://github.com/pgadmin-org/pgadmin4/commit/e701da739031ed985af7b0d8254669ecd54aa78f Author: Pravesh Sharma Date: 2022-11-14 (Mon, 14 Nov 2022) Changed paths: M web/pgadmin/tools/sqleditor/static/js/components/QueryToolDataGrid/Editors.jsx Log Message: --- Fixed an issue where the editor was not visible in the result grid when editing a cell with a large string. #5463
[pgadmin-org/pgadmin4] c8666f: Fixed an issue where the result grid was not worki...
Branch: refs/heads/master Home: https://github.com/pgadmin-org/pgadmin4 Commit: c8666f002969e1b98465094dd1b33a77bd6c4fe5 https://github.com/pgadmin-org/pgadmin4/commit/c8666f002969e1b98465094dd1b33a77bd6c4fe5 Author: Pravesh Sharma Date: 2022-11-10 (Thu, 10 Nov 2022) Changed paths: M web/pgadmin/tools/sqleditor/static/js/components/QueryToolDataGrid/index.jsx Log Message: --- Fixed an issue where the result grid was not working properly while trying to edit data by hitting Enter key. #5463
[pgadmin-org/pgadmin4] 8d3398: Fixed an issue where the screen was freezing while...
Branch: refs/heads/master Home: https://github.com/pgadmin-org/pgadmin4 Commit: 8d33987f1c1913b78bb33c3aee9595542427455d https://github.com/pgadmin-org/pgadmin4/commit/8d33987f1c1913b78bb33c3aee9595542427455d Author: Pravesh Sharma Date: 2022-11-09 (Wed, 09 Nov 2022) Changed paths: M web/package.json M web/yarn.lock Log Message: --- Fixed an issue where the screen was freezing while closing the wcDocker panel. #5465
[pgadmin-org/pgadmin4] 16e28b: Fixed an issue where parameters for roles were not...
Branch: refs/heads/master Home: https://github.com/pgadmin-org/pgadmin4 Commit: 16e28bb99829c4f9c939b98eed48987dbd7d3b88 https://github.com/pgadmin-org/pgadmin4/commit/16e28bb99829c4f9c939b98eed48987dbd7d3b88 Author: Pravesh Sharma Date: 2022-11-02 (Wed, 02 Nov 2022) Changed paths: M web/pgadmin/browser/server_groups/servers/roles/__init__.py Log Message: --- Fixed an issue where parameters for roles were not visible. #5429
[pgadmin-org/pgadmin4] ad8716: Fixed an issue where the dependents tab wasn't wor...
Branch: refs/heads/master Home: https://github.com/pgadmin-org/pgadmin4 Commit: ad871694cc5a783fbb5ff635dac40cc80f17dc53 https://github.com/pgadmin-org/pgadmin4/commit/ad871694cc5a783fbb5ff635dac40cc80f17dc53 Author: Pravesh Sharma Date: 2022-10-31 (Mon, 31 Oct 2022) Changed paths: M web/pgadmin/browser/server_groups/servers/roles/templates/roles/sql/default/dependents.sql Log Message: --- Fixed an issue where the dependents tab wasn't working for PG 15. #5455 changes after review
[pgadmin-org/pgadmin4] 1647fc: Use SocketIO instead of REST for schema diff compa...
Branch: refs/heads/master Home: https://github.com/pgadmin-org/pgadmin4 Commit: 1647fc54e19565f484fdc5ad4b5d109ccd3588b8 https://github.com/pgadmin-org/pgadmin4/commit/1647fc54e19565f484fdc5ad4b5d109ccd3588b8 Author: Pravesh Sharma Date: 2022-10-21 (Fri, 21 Oct 2022) Changed paths: M web/pgadmin/tools/schema_diff/__init__.py M web/pgadmin/tools/schema_diff/model.py M web/pgadmin/tools/schema_diff/static/js/components/SchemaDiffCompare.jsx M web/pgadmin/tools/schema_diff/tests/test_schema_diff_comp.py Log Message: --- Use SocketIO instead of REST for schema diff compare. #4841
[pgadmin-org/pgadmin4] 8a7612: Fixed an issue where filtered rows was not working...
Branch: refs/heads/master Home: https://github.com/pgadmin-org/pgadmin4 Commit: 8a7612294922346c235cfb18ef11e9e0ab1778f4 https://github.com/pgadmin-org/pgadmin4/commit/8a7612294922346c235cfb18ef11e9e0ab1778f4 Author: Pravesh Sharma Date: 2022-10-13 (Thu, 13 Oct 2022) Changed paths: M web/pgadmin/tools/sqleditor/static/js/show_view_data.js Log Message: --- Fixed an issue where filtered rows was not working. #5427
[pgadmin-org/pgadmin4] b100df: Fixed an issue where the password recovery link wa...
Branch: refs/heads/master Home: https://github.com/pgadmin-org/pgadmin4 Commit: b100df3160f82e5422c86fb08b8271b08c4eb7b9 https://github.com/pgadmin-org/pgadmin4/commit/b100df3160f82e5422c86fb08b8271b08c4eb7b9 Author: Pravesh Sharma Date: 2022-10-11 (Tue, 11 Oct 2022) Changed paths: M web/pgadmin/browser/__init__.py Log Message: --- Fixed an issue where the password recovery link was not working. #5397
[pgadmin-org/pgadmin4] 176ea5: Fixed copy sql to query tool feature test
Branch: refs/heads/master Home: https://github.com/pgadmin-org/pgadmin4 Commit: 176ea5949bd983d26560c4fc975c3e75851dc260 https://github.com/pgadmin-org/pgadmin4/commit/176ea5949bd983d26560c4fc975c3e75851dc260 Author: Pravesh Sharma Date: 2022-10-10 (Mon, 10 Oct 2022) Changed paths: M web/regression/feature_tests/test_copy_sql_to_query_tool.py Log Message: --- Fixed copy sql to query tool feature test
[pgadmin-org/pgadmin4] f79844: Fixed an issue where notifications disappeared qui...
Branch: refs/heads/master Home: https://github.com/pgadmin-org/pgadmin4 Commit: f79844e926ae1e9c879f4296e36bc1df88f12f33 https://github.com/pgadmin-org/pgadmin4/commit/f79844e926ae1e9c879f4296e36bc1df88f12f33 Author: Pravesh Sharma Date: 2022-10-07 (Fri, 07 Oct 2022) Changed paths: M web/pgadmin/browser/server_groups/servers/databases/schemas/tables/static/js/table.js Log Message: --- Fixed an issue where notifications disappeared quickly. #5364
[pgadmin-org/pgadmin4] 9817a9: Fixed an issue where user was unable to select pri...
Branch: refs/heads/master Home: https://github.com/pgadmin-org/pgadmin4 Commit: 9817a9b20fc197b0149a986ad34c48ac20aeed67 https://github.com/pgadmin-org/pgadmin4/commit/9817a9b20fc197b0149a986ad34c48ac20aeed67 Author: Pravesh Sharma Date: 2022-09-29 (Thu, 29 Sep 2022) Changed paths: M docs/en_US/release_notes_6_15.rst M web/pgadmin/static/js/components/Privilege.jsx Log Message: --- Fixed an issue where user was unable to select privileges in Safari #5327
[pgadmin-org/pgadmin4] 5d4bac: Fixed browser toolbar feature test. #5293
Branch: refs/heads/master Home: https://github.com/pgadmin-org/pgadmin4 Commit: 5d4bac85e5ae119b5f1bdcb2df5ac6b09bf5bf8a https://github.com/pgadmin-org/pgadmin4/commit/5d4bac85e5ae119b5f1bdcb2df5ac6b09bf5bf8a Author: Pravesh Sharma Date: 2022-09-28 (Wed, 28 Sep 2022) Changed paths: M web/regression/feature_utils/locators.py Log Message: --- Fixed browser toolbar feature test. #5293
[pgadmin-org/pgadmin4] add540: Fixed an issue where the prompt is not visible whe...
Branch: refs/heads/master Home: https://github.com/pgadmin-org/pgadmin4 Commit: add5404f5e4f12d11886d9732cd23894fa99aa58 https://github.com/pgadmin-org/pgadmin4/commit/add5404f5e4f12d11886d9732cd23894fa99aa58 Author: Pravesh Sharma Date: 2022-09-27 (Tue, 27 Sep 2022) Changed paths: M docs/en_US/release_notes_6_15.rst M web/pgadmin/tools/sqleditor/static/js/components/sections/ResultSet.jsx Log Message: --- Fixed an issue where the prompt is not visible when clicking on the 'save results to file' button on the large data. #5338 corrected issue id corrected order of release notes
[pgadmin-org/pgadmin4] 94ca48: made tooltip consistent across the application (#5...
Branch: refs/heads/master Home: https://github.com/pgadmin-org/pgadmin4 Commit: 94ca48674a086900fb266c63b1a263cec2ff1928 https://github.com/pgadmin-org/pgadmin4/commit/94ca48674a086900fb266c63b1a263cec2ff1928 Author: Pravesh Sharma <111979571+pravesh-sha...@users.noreply.github.com> Date: 2022-09-23 (Fri, 23 Sep 2022) Changed paths: M docs/en_US/release_notes_6_15.rst M web/package.json M web/pgadmin/browser/static/js/browser.js M web/pgadmin/browser/static/js/preferences.js M web/pgadmin/static/scss/_webcabin.pgadmin.scss M web/yarn.lock Log Message: --- made tooltip consistent across the application (#5351) Ensure that the tooltips are consistent throughout the entire application. #5293
Sonarqube fixes
Hi, Attached patch contains sonarqube fix for rule ternary operators should not be nested. Thanks, Pravesh -- <http://www.enterprisedb.com> Pravesh Sharma Software Engineer +91 9406461406 www.enterprisedb.com Power to Postgres <https://www.linkedin.com/company/edbpostgres> <https://twitter.com/edbpostgres?lang=en> <https://www.facebook.com/EDBpostgres> <https://www.instagram.com/EDBpostgres/> sonaqube_nested_ternary_fix_v1 Description: Binary data