Thread: [pgAdmin][RM5666]: Added missing dependencies/dependent node
Attachment
Hi Akshay,
The partition of a table is showing an extra "Partition index" dependents, whereas there are no nodes under indexes node.
The primary key displayed twice is an existing issue, confirmed with 4.23.
Apart from that, the patch looks good to me. Test cases success on all the server versions.
On Tue, Jul 14, 2020 at 1:15 PM Aditya Toshniwal <aditya.toshniwal@enterprisedb.com> wrote:
Hi,I'll be reviewing the patch.On Tue, Jul 14, 2020 at 12:46 PM Akshay Joshi <akshay.joshi@enterprisedb.com> wrote:Hi HackersAttached is the patch to add missing dependencies/dependent nodesAdded following missing nodes:
- Materialized View
- Event Trigger
- Collation
- FTS Configuration, FTS Dictionary, FTS Parser, FTS Template,
- RLS Policy
- Extension
- Synonyms (EPAS)
- Packages (EPAS)
- Compound Trigger (EPAS)
Following bugs fixed with this patch:Please review it.
- Foreign Table is interpreted as a Foreign Data Wrapper.
- Domain is interpreted as a type.
- Domain constraint is interpreted as a check constraint.
- Partitioned Table is interpreted as a Partition.
- Trigger function is interpreted as a function in the dependencies tab for Event Triggers.
- Procedure interpreted as a Function.
--Thanks & RegardsAkshay JoshiSr. Software ArchitectEnterpriseDB Software India Private LimitedMobile: +91 976-788-8246--Thanks and Regards,Aditya ToshniwalpgAdmin Hacker | Sr. Software Engineer | EnterpriseDB India | Pune"Don't Complain about Heat, Plant a TREE"
Thanks and Regards,
Aditya Toshniwal
pgAdmin Hacker | Sr. Software Engineer | EnterpriseDB India | Pune
"Don't Complain about Heat, Plant a TREE"
Attachment
Hi Aditya
On Tue, Jul 14, 2020 at 4:22 PM Aditya Toshniwal <aditya.toshniwal@enterprisedb.com> wrote:
Hi Akshay,The partition of a table is showing an extra "Partition index" dependents, whereas there are no nodes under indexes node.The primary key displayed twice is an existing issue, confirmed with 4.23.Apart from that, the patch looks good to me. Test cases success on all the server versions.
Partition Index is newly added dependent as per PostgreSQL documentation, this index is system generated index, so we are not showing them.
We will check whether it should be visible or not. I have committed the code.
On Tue, Jul 14, 2020 at 1:15 PM Aditya Toshniwal <aditya.toshniwal@enterprisedb.com> wrote:Hi,I'll be reviewing the patch.On Tue, Jul 14, 2020 at 12:46 PM Akshay Joshi <akshay.joshi@enterprisedb.com> wrote:Hi HackersAttached is the patch to add missing dependencies/dependent nodesAdded following missing nodes:
- Materialized View
- Event Trigger
- Collation
- FTS Configuration, FTS Dictionary, FTS Parser, FTS Template,
- RLS Policy
- Extension
- Synonyms (EPAS)
- Packages (EPAS)
- Compound Trigger (EPAS)
Following bugs fixed with this patch:Please review it.
- Foreign Table is interpreted as a Foreign Data Wrapper.
- Domain is interpreted as a type.
- Domain constraint is interpreted as a check constraint.
- Partitioned Table is interpreted as a Partition.
- Trigger function is interpreted as a function in the dependencies tab for Event Triggers.
- Procedure interpreted as a Function.
--Thanks & RegardsAkshay JoshiSr. Software ArchitectEnterpriseDB Software India Private LimitedMobile: +91 976-788-8246--Thanks and Regards,Aditya ToshniwalpgAdmin Hacker | Sr. Software Engineer | EnterpriseDB India | Pune"Don't Complain about Heat, Plant a TREE"--Thanks and Regards,Aditya ToshniwalpgAdmin Hacker | Sr. Software Engineer | EnterpriseDB India | Pune"Don't Complain about Heat, Plant a TREE"
Thanks & Regards
Akshay Joshi
Sr. Software Architect
EnterpriseDB Software India Private Limited
Mobile: +91 976-788-8246