Re: CREATE TABLE .. PARTITION OF fails to preserve tgenabled for inherited row triggers

Alvaro Herrera <alvherre@alvh.no-ip.org>

From: Alvaro Herrera <alvherre@alvh.no-ip.org>

To: Justin Pryzby <pryzby@telsasoft.com>

Cc: pgsql-hackers@postgresql.org, Amit Langote <amitlangote09@gmail.com>

Date: 2020-10-16T16:59:34Z

Lists: pgsql-hackers

Attachments

Same, with a little test.

I also just noticed that ALTER TABLE ONLY recurses to children, which it
should not.

Fix pg_dump for disabled triggers on partitioned tables
- f0e21f2f6167 15.0 landed
- ccfc3cbb341a 11.13 landed
- cc340af33453 13.4 landed
- 5992c94dc7e4 12.8 landed
- 3c5b7c628621 14.0 landed
Preserve firing-on state when cloning row triggers to partitions
- fed35bd4a650 11.13 landed
- eef92de11e50 14.0 landed
- df80fa2ee504 15.0 landed
- c31516ae5b43 13.4 landed
- 7584ec1f6098 12.8 landed
Fix ALTER TABLE .. ENABLE/DISABLE TRIGGER recursion
- bbb927b4db9b 14.0 landed
- a795f6782fa8 11.10 landed
- 5f6463a20af1 13.1 landed
- 0e6b6f8c7192 12.5 landed
psql \d: Display table where trigger is defined, if inherited
- c33869cc3bfc 13.0 cited
Fix cloning of row triggers to sub-partitions
- 1fa846f1c9af 13.0 cited
Make pg_dump emit ATTACH PARTITION instead of PARTITION OF (reprise)
- 33a53130a894 12.0 cited