pgAdmin 4 commit: Fixed schema diff issue where function's difference D

[Akshay Joshi]

Fixed schema diff issue where function's difference DDL was showing incorrectly 
when arguments had default values with commas. Fixes #7263

Branch
--
master

Details
---
https://git.postgresql.org/gitweb?p=pgadmin4.git;a=commitdiff;h=9f992a9e5df410aaa78a67738fe3a9f2629d2582

Modified Files
--
docs/en_US/release_notes_6_8.rst| 1 +
.../server_groups/servers/databases/schemas/functions/__init__.py   | 6 +++---
2 files changed, 4 insertions(+), 3 deletions(-)

[pgAdmin][RM7249] Support Unique Key in ERD

[Aditya Toshniwal]

Hi Hackers,

Attached patch adds support for unique keys in ERD and also fixes a bug
where foreign key relationships do not update when the primary key is
modified #7197.

Please review.

-- 
Thanks,
Aditya Toshniwal
pgAdmin Hacker | Software Architect | *edbpostgres.com*

"Don't Complain about Heat, Plant a TREE"


RM7249_7197.patch
Description: Binary data

pgAdmin 4 commit: 1) Added support for unique keys in ERD. Fixes #7249

[Akshay Joshi]

1) Added support for unique keys in ERD. Fixes #7249
2) Fixed an issue where foreign key relationships do not update when the 
primary key is modified. Fixes #7197

Branch
--
master

Details
---
https://git.postgresql.org/gitweb?p=pgadmin4.git;a=commitdiff;h=903b300b9ec43767b91260ce6d7c2522a8b5cb9b
Author: Aditya Toshniwal 

Modified Files
--
docs/en_US/release_notes_6_8.rst   |  5 +-
.../static/img/unique_constraint.svg   |  2 +-
.../databases/schemas/tables/static/js/table.ui.js |  8 +--
web/pgadmin/static/js/Theme/index.jsx  |  2 +-
.../tools/erd/static/js/erd_tool/ERDCore.js| 57 --
.../erd/static/js/erd_tool/nodes/TableNode.jsx | 39 ---
web/regression/javascript/erd/fake_item.js |  1 -
web/regression/javascript/erd/table_node_spec.js   | 25 --
.../erd/ui_components/body_widget_spec.js  |  1 +
9 files changed, 84 insertions(+), 56 deletions(-)

Re: [pgAdmin][RM7249] Support Unique Key in ERD

[Akshay Joshi]

Thanks, the patch applied.

On Mon, Mar 28, 2022 at 1:52 PM Aditya Toshniwal <
aditya.toshni...@enterprisedb.com> wrote:

> Hi Hackers,
>
> Attached patch adds support for unique keys in ERD and also fixes a bug
> where foreign key relationships do not update when the primary key is
> modified #7197.
>
> Please review.
>
> --
> Thanks,
> Aditya Toshniwal
> pgAdmin Hacker | Software Architect | *edbpostgres.com*
> 
> "Don't Complain about Heat, Plant a TREE"
>


-- 
*Thanks & Regards*
*Akshay Joshi*
*pgAdmin Hacker | Principal Software Architect*
*EDB Postgres *

*Mobile: +91 976-788-8246*

pgAdmin 4 commit: Correct the release notes

[Akshay Joshi]

Correct the release notes

Branch
--
master

Details
---
https://git.postgresql.org/gitweb?p=pgadmin4.git;a=commitdiff;h=7ecc0169dfad6d82a244a68e8e94944bd7810c9a

Modified Files
--
docs/en_US/release_notes_6_8.rst | 2 +-
1 file changed, 1 insertion(+), 1 deletion(-)

Re: [Patch] Bug #4256 - ALTER DEFAULT PRIVILEGES FOR ROLE some_role REVOKE EXECUTE ON FUNCTIONS FROM PUBLIC:

[Yogesh Mahajan]

Hello Team,

Please find the updated patch which fixes sql revoke statements shown for
databases.


Thanks,
Yogesh Mahajan
EnterpriseDB


On Tue, Mar 1, 2022 at 12:50 PM Aditya Toshniwal <
aditya.toshni...@enterprisedb.com> wrote:

> Hi Yogesh,
>
> The original bug is not fixed with the patch. You might have fixed the
> related ones.
>
> On Mon, Feb 28, 2022 at 6:24 PM Akshay Joshi <
> akshay.jo...@enterprisedb.com> wrote:
>
>> Hi Aditya
>>
>> Can you please review it?
>>
>> On Mon, Feb 28, 2022 at 6:03 PM Yogesh Mahajan <
>> yogesh.maha...@enterprisedb.com> wrote:
>>
>>> Hi Team,
>>>
>>> Please find a patch which fixes sql for alter default privileges.
>>>
>>> Thanks,
>>> Yogesh Mahajan
>>> EnterpriseDB
>>>
>>
>>
>> --
>> *Thanks & Regards*
>> *Akshay Joshi*
>> *pgAdmin Hacker | Principal Software Architect*
>> *EDB Postgres *
>>
>> *Mobile: +91 976-788-8246*
>>
>
>
> --
> Thanks,
> Aditya Toshniwal
> pgAdmin Hacker | Software Architect | *edbpostgres.com*
> 
> "Don't Complain about Heat, Plant a TREE"
>


RM_4256_v2.patch
Description: Binary data

pgAdmin 4 commit: Fixed an issue where SQL for revoke statements are no

[Akshay Joshi]

Fixed an issue where SQL for revoke statements are not shown for databases. 
Fixes #4258

Branch
--
master

Details
---
https://git.postgresql.org/gitweb?p=pgadmin4.git;a=commitdiff;h=7f2ff5af5c1fc2dce250d0a77987bbe0a8b92478
Author: Yogesh Mahajan 

Modified Files
--
docs/en_US/release_notes_6_8.rst   |   1 +
.../server_groups/servers/databases/__init__.py|   4 +-
.../templates/schemas/pg/9.2_plus/sql/create.sql   |   2 +-
.../templates/schemas/pg/9.2_plus/sql/update.sql   |  10 +-
.../templates/schemas/pg/default/sql/create.sql|   2 +-
.../templates/schemas/pg/default/sql/update.sql|  10 +-
.../templates/schemas/ppas/9.1_plus/sql/create.sql |   2 +-
.../templates/schemas/ppas/9.1_plus/sql/update.sql |  26 ++--
.../templates/schemas/ppas/9.2_plus/sql/create.sql |   2 +-
.../templates/schemas/ppas/9.2_plus/sql/update.sql |  34 ++---
.../tests/pg/9.2_plus/alter_schema_add_priv.sql|   8 +-
.../pg/9.2_plus/alter_schema_add_priv_msql.sql |   8 +-
.../tests/pg/9.2_plus/alter_schema_drop_priv.sql   |   4 +-
.../pg/9.2_plus/alter_schema_drop_priv_msql.sql|   4 +-
.../tests/pg/9.2_plus/alter_schema_update_priv.sql |   8 +-
.../pg/9.2_plus/alter_schema_update_priv_msql.sql  |   8 +-
.../pg/9.2_plus/create_schema_all_options.sql  |   8 +-
.../pg/9.2_plus/create_schema_all_options_msql.sql |   8 +-
.../tests/ppas/9.2_plus/alter_schema_add_priv.sql  |   8 +-
.../ppas/9.2_plus/alter_schema_add_priv_msql.sql   |   8 +-
.../tests/ppas/9.2_plus/alter_schema_drop_priv.sql |   4 +-
.../ppas/9.2_plus/alter_schema_drop_priv_msql.sql  |   4 +-
.../ppas/9.2_plus/alter_schema_update_priv.sql |   8 +-
.../9.2_plus/alter_schema_update_priv_msql.sql |   8 +-
.../ppas/9.2_plus/create_schema_all_options.sql|   8 +-
.../9.2_plus/create_schema_all_options_msql.sql|   8 +-
.../databases/sql/9.3_plus/alter_online.sql|  32 ++---
.../templates/databases/sql/9.3_plus/defacl.sql| 129 ++-
.../templates/databases/sql/9.3_plus/grant.sql |  27 +++-
.../templates/databases/sql/default/create.sql |   2 +-
.../alter_default_db_privileges_function.sql   |  14 ++
.../alter_default_db_privileges_function_msql.sql  |   4 +
.../alter_default_db_privileges_reset_all.sql  |  12 ++
.../alter_default_db_privileges_sequences.sql  |  21 +++
.../alter_default_db_privileges_sequences_msql.sql |   9 ++
.../default/alter_default_db_privileges_tables.sql |  19 +++
.../alter_default_db_privileges_tables_msql.sql|   6 +
.../default/alter_default_db_privileges_types.sql  |  23 
.../databases/tests/pg/default/test_database.json  | 141 +
.../alter_default_db_privileges_function.sql   |  14 ++
.../alter_default_db_privileges_function_msql.sql  |   4 +
.../alter_default_db_privileges_reset_all.sql  |  12 ++
.../alter_default_db_privileges_sequences.sql  |  21 +++
.../alter_default_db_privileges_sequences_msql.sql |   9 ++
.../default/alter_default_db_privileges_tables.sql |  19 +++
.../alter_default_db_privileges_tables_msql.sql|   6 +
.../default/alter_default_db_privileges_types.sql  |  23 
.../tests/ppas/default/test_database.json  | 141 +
.../templates/macros/default_privilege.macros  |  29 +++--
web/pgadmin/browser/server_groups/servers/utils.py |   8 +-
web/regression/python_test_utils/test_utils.py |   9 +-
web/regression/re_sql/tests/test_resql.py  |   7 +-
52 files changed, 807 insertions(+), 139 deletions(-)

Re: [Patch] Bug #4256 - ALTER DEFAULT PRIVILEGES FOR ROLE some_role REVOKE EXECUTE ON FUNCTIONS FROM PUBLIC:

[Akshay Joshi]

Thanks, the patch applied

On Mon, Mar 28, 2022 at 4:43 PM Yogesh Mahajan <
yogesh.maha...@enterprisedb.com> wrote:

> Hello Team,
>
> Please find the updated patch which fixes sql revoke statements shown for
> databases.
>
>
> Thanks,
> Yogesh Mahajan
> EnterpriseDB
>
>
> On Tue, Mar 1, 2022 at 12:50 PM Aditya Toshniwal <
> aditya.toshni...@enterprisedb.com> wrote:
>
>> Hi Yogesh,
>>
>> The original bug is not fixed with the patch. You might have fixed the
>> related ones.
>>
>> On Mon, Feb 28, 2022 at 6:24 PM Akshay Joshi <
>> akshay.jo...@enterprisedb.com> wrote:
>>
>>> Hi Aditya
>>>
>>> Can you please review it?
>>>
>>> On Mon, Feb 28, 2022 at 6:03 PM Yogesh Mahajan <
>>> yogesh.maha...@enterprisedb.com> wrote:
>>>
 Hi Team,

 Please find a patch which fixes sql for alter default privileges.

 Thanks,
 Yogesh Mahajan
 EnterpriseDB

>>>
>>>
>>> --
>>> *Thanks & Regards*
>>> *Akshay Joshi*
>>> *pgAdmin Hacker | Principal Software Architect*
>>> *EDB Postgres *
>>>
>>> *Mobile: +91 976-788-8246*
>>>
>>
>>
>> --
>> Thanks,
>> Aditya Toshniwal
>> pgAdmin Hacker | Software Architect | *edbpostgres.com*
>> 
>> "Don't Complain about Heat, Plant a TREE"
>>
>

-- 
*Thanks & Regards*
*Akshay Joshi*
*pgAdmin Hacker | Principal Software Architect*
*EDB Postgres *

*Mobile: +91 976-788-8246*

pgAdmin 4 commit: Correct the typo of RM number.

[Akshay Joshi]

Correct the typo of RM number.

Branch
--
master

Details
---
https://git.postgresql.org/gitweb?p=pgadmin4.git;a=commitdiff;h=63c9aaea35b2ec94422db8b53bece2e48042adc7

Modified Files
--
docs/en_US/release_notes_6_8.rst | 2 +-
1 file changed, 1 insertion(+), 1 deletion(-)

Accessibility Conformance Report (VCAT)

[Patricia Pierson]

Hello,

I am working on getting the pgAdmin version upgrade to a new version.
Companyis requested an  ACR/VCAT document.

Would you have a document I could use ?

Thank you

-- 
Regards,

Patricia Pierson

pgAdmin 4 commit: Pin Werkzeug to version 2.0.3 as the latest version t

[Akshay Joshi]

Pin Werkzeug to version 2.0.3 as the latest version throwing error cannot 
import name 'safe_str_cmp' from 'werkzeug.security'

Branch
--
master

Details
---
https://git.postgresql.org/gitweb?p=pgadmin4.git;a=commitdiff;h=38b69c91a1ed9c388c42aa793d863dfb8ad9bd82

Modified Files
--
requirements.txt | 1 +
1 file changed, 1 insertion(+)