Hi,
I am trying to bundle a script file with my extension. Script has event triggers and trigger function does a select query on pg_event_trigger_ddl_commands .
While executing "create extension" following error is thrown :
ERROR: pg_event_trigger_ddl_commands() can only be called in an event trigger function
CONTEXT: SQL statement "SELECT * FROM pg_event_trigger_ddl_commands() WHERE object_type ='table'
Found that there is already a bug posted related to this
https://www.postgresql.org/message-id/flat/20170913075559(dot)25630(dot)41587%40wrigleys(dot)postgresql(dot)org#20170913075559(dot)25630(dot)41587(at)wrigleys(dot)postgresql(dot)org
I couldn't understand much from the above thread but like to solve this problem.
Thanks,
Sanyam Jain