Hello. Is it possible to get the currently executing query in an event
trigger, for example, a create table event trigger function firing after
ddl_command_end, aside from checking pg_stat_activity for the current
process?
When I am debugging the source code, after executing a statement I can see
the variable query_string which has the entire SQL statement, however, I
would be very interested if it's possible to get this query_string value in
a c function called during an event trigger, for a given process, or if by
that time the memory has been freed and/or it's just not possible for some
other reason to get the query string of a particular process.
Any thoughts much appreciated.