Re: Rename of triggers for partitioned tables

From: Arne Roland <A(dot)Roland(at)index(dot)de>
To: Pg Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: Rename of triggers for partitioned tables
Date: 2020-11-27 00:05:02
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers

I'm too unhappy with the interface change, so please view attached patch instead.



From: Arne Roland <A(dot)Roland(at)index(dot)de>
Sent: Friday, November 27, 2020 12:28:31 AM
To: Pg Hackers
Subject: Rename of triggers for partitioned tables


I got too annoyed at building queries for gexec all the time. So wrote a patch to fix the issue that the rename of partitioned trigger doesn't affect children.

In case there isn't a dependent trigger with the same name on the child the function errors out. If the user touched the trigger of the child, it's not a sensitive idea to mess with it.

I'm not happy with the interface change in trigger.h. Yet I don't like the idea of creating another layer of indirection either.

Even though it's a small patch, there might be other things I'm missing, so I'd appreciate feedback.



Attachment Content-Type Size
recursive_tgrename.1.patch text/x-patch 6.9 KB

In response to


Browse pgsql-hackers by date

  From Date Subject
Next Message David Rowley 2020-11-27 00:10:43 Re: Hybrid Hash/Nested Loop joins and caching results from subplans
Previous Message Tomas Vondra 2020-11-27 00:02:58 Re: [PoC] Non-volatile WAL buffer