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 ?



*Murat Tuncer*Software Engineer | Citus Data

Reply via email to