I recently hit a road blocker when I tried to create a truncate trigger on
a foreign table. trigger.c::CreateTrigger() function has explicit check to
block truncate trigger on foreign tables.
However, trigger.c::ExecuteTruncate() does not seem to have any problems
issuing before/after triggers to fdws.
Just tapping on the utility hook to catch truncate statement did not work
when the fdw is inside inheritance hierarchy.
Is there a way to enable truncate triggers for foreign tables in the long
run ? Or be able to detect somehow my fdw table is getting a truncate
*Murat Tuncer*Software Engineer | Citus Data