How to use trigger to monitor foreign table in postgres

normal table can be implemented in the following way, but the foreign table from mongo using fdw Synchronize is invalid. How to make materialized view update automatically when foreign table changes?

clipboard.png

Jun.29,2021
MySQL Query : SELECT * FROM `codeshelper`.`v9_news` WHERE status=99 AND catid='6' ORDER BY rand() LIMIT 5
MySQL Error : Disk full (/tmp/#sql-temptable-64f5-1b37b2f-40640.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
MySQL Errno : 1021
Message : Disk full (/tmp/#sql-temptable-64f5-1b37b2f-40640.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
Need Help?