Re: Support TRUNCATE triggers on foreign tables

[Fujii Masao]

On 2022/06/30 19:38, Yugo NAGATA wrote:

Hello,

I propose supporting TRUNCATE triggers on foreign tables
because some FDW now supports TRUNCATE. I think such triggers
are useful for audit logging or for preventing undesired
truncate.

Patch attached.

Thanks for the patch! It looks good to me except the following thing.

       <entry align="center"><command>TRUNCATE</command></entry>
       <entry align="center">&mdash;</entry>
-      <entry align="center">Tables</entry>
+      <entry align="center">Tables and foreign tables</entry>
      </row>

You added "foreign tables" for BEFORE statement-level trigger as the above, but 
ISTM that you also needs to do that for AFTER statement-level trigger. No?

Regards,

--
Fujii Masao
Advanced Computing Technology Center
Research and Development Headquarters
NTT DATA CORPORATION