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

Tom Lane <tgl@sss.pgh.pa.us>

From: Tom Lane <tgl@sss.pgh.pa.us>

To: Justin Pryzby <pryzby@telsasoft.com>

Cc: Alvaro Herrera <alvherre@alvh.no-ip.org>, pgsql-hackers@postgresql.org, Amit Langote <amitlangote09@gmail.com>

Date: 2021-07-16T18:15:26Z

Lists: pgsql-hackers

Justin Pryzby <pryzby@telsasoft.com> writes:
> I think there's still an issue that comments on child triggers aren't
> preserved, right ?

Do we care?  That seems like messing with a system-internal object.
In general we won't promise to preserve the results of doing so.

			regards, tom lane

Commits

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