Hello
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 request ?
thanks
--