Just a thought...
Is it possible to create a trigger for a system table?
Not sure, and doesn't seem documented either way, but seems easy enough to try on a test cluster...
[...]
Successful "CREATE TABLE..." statement creates a row inside the
information_schema.tables
Given that information_schema.tables is a view, not a table, it doesn't make a valid hook point for the trigger regardless of the previous point.
David J.