[pgAdmin][RM6770] Foreign Key multiple fixes

2021-09-21 Thread Aditya Toshniwal
Hi Hackers, Attached patch fixes: 1. Auto FK related fixes. 2. Properties tab not showing columns. 3. Toggle button is editable even if set to readonly. 4. Dropdown placeholder should be blank for readonly/disabled. 5. Input control help text color on dark theme. Please review. -- Thanks, Adity

Re: Autovacuum on Toast table

2021-09-21 Thread Aditya Toshniwal
Hi Satish, The question is more suitable to be redirected to pgsql-ad...@postgresql.org On Tue, Sep 21, 2021 at 5:48 PM satish v wrote: > Hi, > We deleted the old data around 300GB from a table.i can see the auto > vacuum performing on base table but not on toast table.due to this db size > i

Autovacuum on Toast table

2021-09-21 Thread satish v
Hi, We deleted the old data around 300GB from a table.i can see the auto vacuum performing on base table but not on toast table.due to this db size is growing rapidly. I am using the Azure PostgreSQL service. In the base/parent table dead tuples are zero. Is it possible to run the vacuum on toast

Re: [pgAdmin][RM2546]: Partitioned table should be created using COLLATE and opclass.

2021-09-21 Thread Akshay Joshi
Thanks, the patch applied. On Tue, Sep 21, 2021 at 5:38 PM Pradip Parkale < pradip.park...@enterprisedb.com> wrote: > Hi Akshay, > > Please find the attached patch for jasmine failures. > > On Wed, Sep 15, 2021 at 11:58 AM Akshay Joshi < > akshay.jo...@enterprisedb.com> wrote: > >> Thanks, the pa

pgAdmin 4 commit: Fixed jasmine test cases.

2021-09-21 Thread Akshay Joshi
Fixed jasmine test cases. Branch -- master Details --- https://git.postgresql.org/gitweb?p=pgadmin4.git;a=commitdiff;h=7330b3520f1288a16b5fb1c3c253eebabdbd91b3 Author: Pradip Parkale Modified Files -- .../databases/schemas/tables/static/js/partition.utils.ui.js | 12 +++-

Re: [pgAdmin][RM2546]: Partitioned table should be created using COLLATE and opclass.

2021-09-21 Thread Pradip Parkale
Hi Akshay, Please find the attached patch for jasmine failures. On Wed, Sep 15, 2021 at 11:58 AM Akshay Joshi wrote: > Thanks, the patch applied. > > On Wed, Sep 15, 2021 at 11:10 AM Pradip Parkale < > pradip.park...@enterprisedb.com> wrote: > >> Hi Akshay, >> >> Please find the attached patch

Re: [pgAdmin][RM6763] Default values are not populated in case of inherited table.

2021-09-21 Thread Akshay Joshi
Thanks, the patch applied. On Tue, Sep 21, 2021 at 4:27 PM Aditya Toshniwal < aditya.toshni...@enterprisedb.com> wrote: > Hi Hackers, > > Please ignore the previous patch. Attached is the updated patch. > > On Tue, Sep 21, 2021 at 4:24 PM Aditya Toshniwal < > aditya.toshni...@enterprisedb.com> wr

pgAdmin 4 commit: 1) Make default values column read-only for inherited

2021-09-21 Thread Akshay Joshi
1) Make default values column read-only for inherited columns when creating table. 2) Default values not populated for inherited columns. The existing issue, API changed. 3) Options are not populated for Name in Column > Variable tab. 4) The empty check error message is changed from Label cannot

pgAdmin 4 commit: Fixed an issue where Refresh view options are not wor

2021-09-21 Thread Akshay Joshi
Fixed an issue where Refresh view options are not working for materialized view. Fixes #6736. Branch -- master Details --- https://git.postgresql.org/gitweb?p=pgadmin4.git;a=commitdiff;h=b60bd73f883cf3ad83c2caa133eb0fdc1c4396db Modified Files -- docs/en_US/release_notes_6_0.

pgAdmin 4 commit: Remove word break for dialog labels.

2021-09-21 Thread Akshay Joshi
Remove word break for dialog labels. Branch -- master Details --- https://git.postgresql.org/gitweb?p=pgadmin4.git;a=commitdiff;h=6b100b60f87ba674578449bf992dfe63a2b55a9e Modified Files -- web/pgadmin/static/js/Theme/index.jsx | 1 - 1 file changed, 1 deletion(-)

Re: [pgAdmin][RM6763] Default values are not populated in case of inherited table.

2021-09-21 Thread Aditya Toshniwal
Hi Hackers, Please ignore the previous patch. Attached is the updated patch. On Tue, Sep 21, 2021 at 4:24 PM Aditya Toshniwal < aditya.toshni...@enterprisedb.com> wrote: > Hi Hackers, > > Attached patch fixes: > 1) Make default values column readonly for inherited columns when creating > table.

[pgAdmin][RM6763] Default values are not populated in case of inherited table.

2021-09-21 Thread Aditya Toshniwal
Hi Hackers, Attached patch fixes: 1) Make default values column readonly for inherited columns when creating table. 2) Default values not populated for inherited columns. Existing issue, API changed. 3) Options are not populated for Name in Column > Variable tab. 4) The empty check error message i

Re: [pgAdmin][patch] ERD table dialog failing to open

2021-09-21 Thread Akshay Joshi
Thanks, the patch applied. On Tue, Sep 21, 2021 at 3:02 PM Aditya Toshniwal < aditya.toshni...@enterprisedb.com> wrote: > Hi, > > Please find the updated patch. > > On Tue, Sep 21, 2021 at 2:33 PM Akshay Joshi < > akshay.jo...@enterprisedb.com> wrote: > >> Hi Aditya >> >> Patch throwing linter er

Re: [pgAdmin][RM6762] Unable to create primary key from Table>Column tab

2021-09-21 Thread Akshay Joshi
Thanks, the patch applied. On Tue, Sep 21, 2021 at 2:54 PM Aditya Toshniwal < aditya.toshni...@enterprisedb.com> wrote: > Hi Hackers, > > Attached path synchronises the columns primary key flag and primary key > constraint. > Please review. > > -- > Thanks, > Aditya Toshniwal > pgAdmin Hacker | S

pgAdmin 4 commit: Synchronises the column's primary key flag and primar

2021-09-21 Thread Akshay Joshi
Synchronises the column's primary key flag and primary key constraint. Fixes #6762 Branch -- master Details --- https://git.postgresql.org/gitweb?p=pgadmin4.git;a=commitdiff;h=af230c812b62444d6e2372051cb4bc12d5cffe4b Author: Aditya Toshniwal Modified Files -- .../index_cons

pgAdmin 4 commit: Fixed an issue where ERD table dialog is failing to o

2021-09-21 Thread Akshay Joshi
Fixed an issue where ERD table dialog is failing to open after React Porting Branch -- master Details --- https://git.postgresql.org/gitweb?p=pgadmin4.git;a=commitdiff;h=5f104b0e0eba471c273193bd1bb54be8141a7aa9 Author: Aditya Toshniwal Modified Files -- .../index_constraint/

Re: [pgAdmin][patch] ERD table dialog failing to open

2021-09-21 Thread Aditya Toshniwal
Hi, Please find the updated patch. On Tue, Sep 21, 2021 at 2:33 PM Akshay Joshi wrote: > Hi Aditya > > Patch throwing linter error, "Backgrid and Backform are not defined". > > On Tue, Sep 21, 2021 at 1:25 PM Aditya Toshniwal < > aditya.toshni...@enterprisedb.com> wrote: > >> Hi, >> >> Attached

pgAdmin 4 commit: Set the nwjs version to '0.55.0' to fixed the blank s

2021-09-21 Thread Akshay Joshi
Set the nwjs version to '0.55.0' to fixed the blank screen issue, caused by the latest version on Windows 2016/2019 server. Branch -- master Details --- https://git.postgresql.org/gitweb?p=pgadmin4.git;a=commitdiff;h=9bf0d0ace0f2dac385672bb32b424691ab9bd4c8 Modified Files --

[pgAdmin][RM6762] Unable to create primary key from Table>Column tab

2021-09-21 Thread Aditya Toshniwal
Hi Hackers, Attached path synchronises the columns primary key flag and primary key constraint. Please review. -- Thanks, Aditya Toshniwal pgAdmin Hacker | Software Architect | *edbpostgres.com* "Don't Complain about Heat, Plant a TREE" RM6762.patch Description: Binary

Re: [pgAdmin][patch] ERD table dialog failing to open

2021-09-21 Thread Akshay Joshi
Hi Aditya Patch throwing linter error, "Backgrid and Backform are not defined". On Tue, Sep 21, 2021 at 1:25 PM Aditya Toshniwal < aditya.toshni...@enterprisedb.com> wrote: > Hi, > > Attached is the patch. :D > > On Tue, Sep 21, 2021 at 1:21 PM Akshay Joshi < > akshay.jo...@enterprisedb.com> wro

Re: [pgAdmin][patch] ERD table dialog failing to open

2021-09-21 Thread Aditya Toshniwal
Hi, Attached is the patch. :D On Tue, Sep 21, 2021 at 1:21 PM Akshay Joshi wrote: > Hi Aditya > > You forgot to attach the patch. > > On Tue, Sep 21, 2021 at 12:21 PM Aditya Toshniwal < > aditya.toshni...@enterprisedb.com> wrote: > >> Hi Hackers, >> >> As the primary key backbone model is remov

Re: [pgAdmin][patch] ERD table dialog failing to open

2021-09-21 Thread Akshay Joshi
Hi Aditya You forgot to attach the patch. On Tue, Sep 21, 2021 at 12:21 PM Aditya Toshniwal < aditya.toshni...@enterprisedb.com> wrote: > Hi Hackers, > > As the primary key backbone model is removed after porting, ERD table > dialog is failing to open. > Attached patch will restore the removed m