When I call a PL/PgSQL function (not a trigger) from another such function, is it possible to know the name or some kind of ID of a calling function?
+1
A:
this is a close as you will get, and it wont work in nested calls.
select current_query from pg_stat_activity where procpid = pg_backend_pid();
You might want to email [email protected] with a feature request, including the use case you have for wanting to know this information.
xzilla
2009-05-16 20:37:53
This gives me a full text of the calling query. Thanks!
Denys
2009-05-20 15:39:34