Re: Rename of triggers for partitioned tables
От | Alvaro Herrera |
---|---|
Тема | Re: Rename of triggers for partitioned tables |
Дата | |
Msg-id | 202107212216.kj4i5us2i33k@alvherre.pgsql обсуждение исходный текст |
Ответ на | Re: Rename of triggers for partitioned tables (Alvaro Herrera <alvherre@alvh.no-ip.org>) |
Ответы |
Re: Rename of triggers for partitioned tables
|
Список | pgsql-hackers |
... now, thinking about how does pg_dump deal with this, I think this thread is all wrong, or at least mostly wrong. We cannot have triggers in partitions with different names from the triggers in the parents. pg_dump would only dump the trigger in the parent and totally ignore the ones in children if they have different names. So we still need the recursion bits; but 1. if we detect that we're running in a trigger which has tgparentid set, we have to raise an error, 2. if we are running on a trigger in a partitioned table, then ONLY must not be specified. -- Álvaro Herrera Valdivia, Chile — https://www.EnterpriseDB.com/ "Puedes vivir sólo una vez, pero si lo haces bien, una vez es suficiente"
В списке pgsql-hackers по дате отправления: