Postgres Pro
Downloads
Home   >   mailing lists

Re: [pgAdmin][RM4842] trigger/compound trigger on a partitioned table - Mailing list pgadmin-hackers

From Akshay Joshi
Subject Re: [pgAdmin][RM4842] trigger/compound trigger on a partitioned table
Date
Msg-id CANxoLDdBt-tHJ9XgDKS=cj7en17o09yDPZKajeJrwYs3wxQxMQ@mail.gmail.com
Whole thread Raw
In response to [pgAdmin][RM4842] trigger/compound trigger on a partitioned table  (Aditya Toshniwal <aditya.toshniwal@enterprisedb.com>)
Responses Re: [pgAdmin][RM4842] trigger/compound trigger on a partitioned table
List pgadmin-hackers
Tree view
Hi Aditya

I have applied the patch and found one issue collection nodes are visible twice under the child node of the partition table. Please fix that.
Screenshot 2019-12-31 at 1.24.26 PM.png

On Wed, Dec 25, 2019 at 4:59 PM Aditya Toshniwal <aditya.toshniwal@enterprisedb.com> wrote:
Hi Hackers,

Attached is the patch to fix the issue where it was not possible to add constraints, index, rules, triggers and compound triggers on child tables of a partitioned table.
The problem was with URLs formed which also included parent table OID, which was not needed. The code is changed to add "url_jump_after_node" param to skip after a certain node, which will will skip all the value between jump_after_node to the last node, excluding jump_after_node and the last node. Partitioned table itself is a "table" and can be multilevel.

Kindly review.

--
Thanks and Regards,
Aditya Toshniwal
pgAdmin 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
Attachment

pgadmin-hackers by date:

Previous
From: Akshay Joshi
Date:
Subject: Re: [pgAdmin][RM5024] Refactoring SQL of Functions and Procedures.
Next
From: Ganesh Jaybhay
Date:
Subject: [pgAdmin4][RM#5047] Add tab navigation for tabs under explain panelin query tool